ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

在进行物理主备库角色转换的时候遇到ORA-01093错误

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL 
*
ERROR at line 1:
ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

 

此错误的因为主库中有活动的会话造成的，解决的办法为：

1.杀掉活动会话，重新执行该命令

2.在该命令后面加上with session shutdown即

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL  WITH SESSION SHUTDOWN;

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

转载于:http://blog.itpub.net/29108856/viewspace-2141152/