Oracle DG --检查

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

select process ,status , sequence# from v$managed_standby;

select max(sequence#),to_char(max(first_time),'yyyy-mm-dd hh24:mi:ss') from v$log_history;

select DEST_NAME,STATUS,RECOVERY_MODE from v$archive_dest_status where DEST_NAME='LOG_ARCHIVE_DEST_2';

select DEST_NAME,STATUS,RECOVERY_MODE from v$archive_dest_status where DEST_NAME='LOG_ARCHIVE_DEST_1';