不想用dg了，将stanby库切换为primary

下面将STANDBY数据库切换为PRIMARY数据库：
SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PHYSICAL STANDBY NOT ALLOWED

  SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; 

Database altered.

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PHYSICAL STANDBY TO PRIMARY

SQL> alter database commit to switchover to primary;

Database altered.

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS
---------------- --------------------
PRIMARY          NOT ALLOWED

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

转载于:http://blog.itpub.net/31414383/viewspace-2137233/