Oracle DG --检查
检查DG是否同步
01, 查看主备可切换状态
select switchover_status from v$database;
select db_unique_name,open_mode,database_role,switchover_status from v$database
02, 查看进程
select process ,status , sequence# from v$managed_standby;
03,查看最后一行的归档日志
select max(sequence#),to_char(max(first_time),'yyyy-mm-dd hh24:mi:ss') from v$log_history;
04 主库
select DEST_NAME,STATUS,RECOVERY_MODE from v$archive_dest_status where DEST_NAME='LOG_ARCHIVE_DEST_2';
05,备库
select DEST_NAME,STATUS,RECOVERY_MODE from v$archive_dest_status where DEST_NAME='LOG_ARCHIVE_DEST_1';
看是否一样
人生就像一滴水,非要落下才后悔!
--kingle