oracle Switchover

--从库检查同步状态

SELECT STATUS, GAP_STATUS FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID = 2;
 COLUMN NAME FORMAT A24
 COLUMN VALUE FORMAT A16     
 COLUMN DATUM_TIME FORMAT A24
 SELECT NAME, VALUE, DATUM_TIME FROM V$DATAGUARD_STATS;
 
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE NODELAY DISCONNECT FROM SESSION;



--主库执行 

ALTER DATABASE COMMIT TO SWITCHOVER TO physical  STANDBY WITH SESSION SHUTDOWN;

--主库会自动 shutdown，需要手动重启到 mount 状态，并查看日志应用状态，
--此时 primary 已经变成 standby

--备库执行

select db_unique_name,open_mode,database_role,switchover_status from 
v$database;


 ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WITH SESSION SHUTDOWN;



ALTER DATABASE OPEN;