如何才能將DB處于的quiesce狀態
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>
如何, conn, system, restricted, ERROR
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（8）
在10G的document中有就相關要設resource_manager_plan的說明！
9i的Document沒有相關的說明！
10G中的說明如下：
To be able to quiesce the database, you must have the Database Resource Manager
feature activated, and it must have been activated since the current instance (or all
instances in an Oracle Real Application Clusters environment) started up. It is
through the facilities of the Database Resource Manager that non-DBA sessions are
prevented from becoming active. Also, while this statement is in effect, any attempt
to change the current resource plan will be queued until after the system is
unquiesced.
查看有那些的可用的plan:
SQL> select plan from DBA_RSRC_PLANS;
PLAN
------------------------------
SYSTEM_PLAN
INTERNAL_QUIESCE
INTERNAL_PLAN
ERP_PLAN
SQL>
Oracle9i的新特性之一,restrict模式的一种替代
可以在不重起数据库的情况下进行维护
首先：感謝eygle: 現在可以了！
關resource_manager_plan:
说明: 如果指定该值, 资源管理器将激活计划和例程的所有子项 (子计划, 指令和使用者组)。如果不指定, 资源管理器将被禁用, 但使用ALTER SYSTEM 命令还可以启用。
值范围: 任何有效的字符串。
默认值: NULL
Oracle9 i
Database Administrator’s Guide
Release 2 (9.2)
上是這么說的！
There are times when there is a need to put a database into a state where only DBA transactions, queries, fetches, or PL/SQL statements are allowed. This is called a quiesced state, in the sense that there are no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements in the system.
Without the ability to quiesce the database, you would be required to shut down
the database and reopen it in restricted mode. This is a serious restriction, especially
for systems requiring 24 x 7 availability. Quiescing a database is much less of a
restriction because it eliminates the disruption to users and downtime associated
with shutting down and restarting the database.
请问楼主进入quiesce状态有什么用？
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>
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:
如何設定resource 才能將DB置于quiesce狀態！
請各位幫忙！