dg状态查看

select status,instance_name,database_role,open_mode,protection_mode,switchover_status from gv$instance,gv$database;

select destination,status,error,DEST_ID,DEST_NAME from v$archive_dest;

select * from v$archive_processes where status <> 'STOPPED';

select status,error from v$archive_dest where status <>'INACTIVE';

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

select 'Last applied  : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time
from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log where applied='YES')
union
select 'Last received : ' Logs, to_char(next_time,'DD-MON-YY:HH24:MI:SS') Time
from v$archived_log
where sequence# = (select max(sequence#) from v$archived_log);

select al.thrd "Thread", almax "Last Seq Received", lhmax "Last Seq Applied"
from (select thread# thrd, max(sequence#) almax
from v$archived_log
where resetlogs_change#=(select resetlogs_change# from v$database)
group by thread#) al,
(select thread# thrd, max(sequence#) lhmax
from v$log_history
where first_time=(select max(first_time) from v$log_history)
group by thread#) lh
where al.thrd = lh.thrd;

select thread#,max(sequence#) from v$archived_log where archived='YES' group by thread# order by 1; 

select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread# order by 1;