ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to Quiesce a Database

How to Quiesce a Database

原创 Linux操作系统 作者:lwitpub 时间:2009-09-18 11:38:33 0 删除 编辑

How to Quiesce a Database

By Alexander Geldutes

Quiesce a database is a new
feature in Oracle 9i.It is similar to the restricted mode.When a database in a quiesced mode no one can connect to the database except SYS and SYSTEM and all current user sessions are suspended.As the result in the quiesced mode DBA can perform. some maintenance task.

In order to quiesce a database(oracle versions above 9i :
Set the RESOURCE_MANAGER_PLAN parameter to a non-null value.
alter system set resource_manager_plan='SYSPLAN'scope=both;

(oracle versions above 10g

SQL>conn /  as sysdba

Connected
.

SQL> alter system quiesce restricted;

System altered.
SQL> select status,active_state from v$instance;

STATUS       ACTIVE_ST
------------     ---------
OPEN         QUIESCED

To bring a database back in the fully operational mode, usethe following command:

SQL>alter system unquiesce;

System altered.

SQL>select active_state from v$instance;

ACTIVE_ST
---------
NORMAL
(oracle system Default)

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

请登录后发表评论 登录
全部评论

注册时间:2009-05-08

  • 博文量
    107
  • 访问量
    381215