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);
-