Dataguard 健康检查

1420阅读 0评论2021-07-27 brjl
分类:Oracle

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

pstdby_prm_diag_v3.txt

pstdby_stb_diag_v3.txt

基本上查不出什么毛病来

那就再加强一下

  1. --主库

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

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

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

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

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

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

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

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

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

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


上一篇:v$archive_gap查不出东西来怎么办
下一篇:检测和修复crs文件权限 permission.pl