DG健康检查sqlplus -S "/ as sysdba"< sysdate - 2;col value for a15col ctime for a20col NAME for a18col datum_time for a20ttitle 'standby: archive log lag info'select inst_id, to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') ctime, name, value, datum_time, (substr(value, 5, 2) * 3600 + substr(value, 8, 2) * 60 + substr(value, 11, 2)) lag_sec from gv\$dataguard_stats where 1 = 1 -- and name like '%lag';ttitle 'archive dest status'col dest_name format a20col error format a32col db_unique_name format a15col status for a8col process for a8col type for a8col valid_type for a12col valid_role for a12col compression for a10select inst_id, dest_id, dest_name, status, delay_mins, process, error, type, valid_type, valid_role, compression, db_unique_namefrom gv\$archive_destwhere status <> 'INACTIVE';col database_mode for a16col recovery_mode for a16col protection_mode for a20col synchronization_status for a24col gap_status for a12select inst_id, dest_id, dest_name, status, type, database_mode, recovery_mode, protection_mode, standby_logfile_count srl_cnt, standby_logfile_active srl_id#, -- archived_thread#, archived_seq#, -- applied_thread#, applied_seq#, error, db_unique_name, synchronization_status, -- synchronized, gap_status from gv\$archive_dest_status where status <> 'INACTIVE';ttitle 'apply logfile info'col name for a64select name, registrar, creator, thread#, sequence#, standby_dest, archived, applied, deleted, status, first_time, next_time from v\$archived_log;ttitle off;quit;EOF
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
