HOWTO--alter system quiesce restricted

我們如何把open狀態下DB改成quiesce(靜默)狀態呢，如果要啟用quiesce需用到資源計划，我們看下面的實例：

how to do in DB status [quiesce]
cause:

SQL> conn sys/password as sysdba
Connected.
SQL> alter system quiesce restricted;
alter system quiesce restricted
*
ERROR at line 1:
ORA-25507: resource manager has not been continuously on

SQL>
SQL> host oerr ora 25507
25507, 00000, "resource manager has not been continuously on"
// *Cause: Cannot quiesce the system because resource manager has not been
// continuously on since startup.
// *Action:

answer:

SQL> connect / as sysdba
Connected.
SQL> alter system set resource_manager_plan='SYSTEM_PLAN' scope=spfile ;

System altered.

SQL> startup force
ORACLE instance started.

Total System Global Area 135336972 bytes
Fixed Size 451596 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> alter system quiesce restricted;

System altered.

SQL> select instance_number,active_state from v$instance;

INSTANCE_NUMBER ACTIVE_ST
--------------- ---------
1 QUIESCED

SQL>alter system unquiesce;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29987/viewspace-51701/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29987/viewspace-51701/