FAILOVER

主库

SQL> shutdown abort

ORACLE instance shut down.

 

备库切换成主库

SQL> alter database recover managed standby database cancel;

 

Database altered.

 

SQL>  alter database recover managed standby database finish;

 

Database altered.

 

SQL> select open_mode,database_role,switchover_status from v$database;

 

OPEN_MODE             DATABASE_ROLE    SWITCHOVER_STATUS

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

READ ONLY             PHYSICAL STANDBY TO PRIMARY

 

SQL>  alter database commit to switchover to primary;

 

Database altered.

SQL> alter database open;

 

Database altered.

 

或者 shutdown immediate+startup

新主库查看状态

SQL> select open_mode,database_role,switchover_status from v$database;

 

OPEN_MODE             DATABASE_ROLE    SWITCHOVER_STATUS

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

READ WRITE             PRIMARY              FAILED DESTINATION