DG SWITCH OVER

DG SWITCH OVER

1.验证当前主库的状态

 

SQL> SELECT NAME,DATABASE_ROLE FROM V$DATABASE;

 

NAME      DATABASE_ROLE

--------- ----------------

SZSCPDB   PRIMARY

 

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 

SWITCHOVER_STATUS

--------------------

TO STANDBY

注：当SWITCHOVER_STATUS的值为TO STANDBY or SESSIONS ACTIVE的时候表示主库可以支持SWITCHOVER.

2.初始化将要切换的主库

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH -

> SESSION SHUTDOWN;

注:当上面的查询中返回的值为TO STANDBY 的时候，该语句中的SESSION SHUTDOWN可以忽略掉。

 

3.关闭并且mount上老的主库

SQL> SHUTDOWN ABORT;

SQL> STARTUP MOUNT;

 

4.验证备库的状态

验证将要切换成新主库的备库状态

 

 

 

 

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 

SWITCHOVER_STATUS

--------------------

NOT ALLOWED

 

SQL> alter database recover managed standby database disconnect from session;

 

Database altered.

 

SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

 

SWITCHOVER_STATUS

--------------------

SESSIONS ACTIVE

注：只有SWITCHOVER_STATUS的值为TO PRIMARY or SESSIONS ACTIVE的状态时，表示备库当前支持switch over操作。

 

5.将目标备库的角色切换成主库角色

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY-

> WITH SESSION SHUTDOWN;

注：当上面查询返回的值为TO PRIMARY的时候WITH SESSION SHUTDOWN;子句可以忽略.

 

6.打开新的主库

SQL> ALTER DATABASE OPEN;

 

7.启动新的备库的redo apply机制

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE -

> DISCONNECT FROM SESSION;

 

 

 

 

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

转载于:http://blog.itpub.net/26169542/viewspace-767478/