监控primary/standby数据库

1、表格

 

 

2、相应数据字典

  1、查看进程的活动状态

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

 

2、确认redo应用进度

SQL> select dest_name,archived_thread#,archived_seq#,applied_thread#,applied_seq#,db_unique_name from v$archive_dest_status where status='VALID';

 

3、检查归档文件路径及创建信息---v$archived_log

SQL> select name,creator,sequence#,applied,completion_time from v$archived_log;

 

4、查询归档历史---v$log_history

SQL> select first_time,first_change#,next_change#,sequence# from v$log_history;

 

5、查询当前数据的基本信息---v$database

SQL> select database_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status from v$database;

SQL> select fs_failover_status,fs_failover_current_target,fs_failover_threshold, fs_failover_observer_present from v$database;

 

6、检查应用模式(是否启用了实时应用)---v$archive_dest_status

SQL> select recovery_mode from v$archive_dest_status where dest_id=2;

 

7、Data guard 事件---v$dataguard_status

SQL> select message from v$dataguard_status;