我有待机数据库(版本:Oracle数据库11G企业版本版本11.2.0.1.0)中的"已安装"模式。
SQL> select database_role,open_mode from v$database;
DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY MOUNTED
当我想将open_mode从"安装"更改为"仅使用apply"模式时,将发生错误(ORA-01093)。
SQL> SHUTDOWN IMMEDIATE;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 2.7793E+10 bytes
Fixed Size 2189008 bytes
Variable Size 1.1207E+10 bytes
Database Buffers 1.6576E+10 bytes
Redo Buffers 7385088 bytes
Database mounted.
SQL> ALTER DATABASE OPEN READ ONLY;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
如何解决错误,换句话说如何杀死其他会话?
正确的语法如下所示:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT USING CURRENT LOGFILE;
我们以前已经将数据库从10G版(10.2.0.4.0)升级到11GR2(11.2.0.1.0),然后为了使用活动数据守护设置为11.0.0。兼容参数的当前值为10.2.0.4.0,如下查询中所示:
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 10.2.0.4.0
您是在普通坐骑
中启动DB让我们说您正在使用会话断开模式的自动恢复...
然后,您将停止恢复,然后在仅读取模式
中打开ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE OPEN READ ONLY;
然后将自动恢复放在
上ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;