Dataguard 健康检查

Data Guard Physical Standby - Configuration Health Check (Doc ID 1581388.1)

pstdby_prm_diag_v3.txt

pstdby_stb_diag_v3.txt

基本上查不出什么毛病来

那就再加强一下

--主库

select sysdate,status,error from gv$archive_dest_status where type='PHYSICAL' and status!='VALID' or error is not null;

select file#, name, unrecoverable_change#, unrecoverable_time from v$datafile where unrecoverable_time > (sysdate - 1);

select sysdate,database_mode,recovery_mode, gap_status from v$archive_dest_status where type='PHYSICAL' and gap_status !='NO GAP';

select * from v$dataguard_status where severity in ('Error','Fatal') and timestamp > (sysdate -1);

select sysdate,protection_mode, synchronized, synchronization_status from v$archive_dest_status where type='PHYSICAL' and synchronization_status !='OK';

--备库
select name,value,time_computed,datum_time from v$dataguard_stats where name='transport lag' and value > '+00 00:01:00';

select name,value,time_computed,datum_time from v$dataguard_stats where name='apply lag' and value > '+00 00:01:00';

select * from v$datafile_header where status ='OFFLINE' or ERROR is not null;

select * from v$managed_standby where process like 'MRP%'; --唯一一个期望有结果的

select * from v$dataguard_status where severity in ('Error','Fatal') and timestamp > (sysdate -1);