12c Broker 监控DataGuard

SQL> set lines 200SQL> select * from v$version where rownum=1;BANNER                                                                               CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production              0SQL> 

Monitorable (Read-Only) PropertiesDGMGRL> show database orcl 'LogXptStatus'  ##redo日志传输LOG TRANSPORT STATUSPRIMARY_INSTANCE_NAME   STANDBY_DATABASE_NAME    STATUS                           orcl               orcldg                                      orcl              orcldg2                      DGMGRL> DGMGRL> show database orcl 'InconsistentLogXptProps'   ##不一致的redo日志传输属性(primary)INCONSISTENT LOG TRANSPORT PROPERTIES   INSTANCE_NAME         STANDBY_NAME        PROPERTY_NAME         MEMORY_VALUE         BROKER_VALUE DGMGRL> show database orcl 'InconsistentProperties';  ##不一致的数据库属性INCONSISTENT PROPERTIES   INSTANCE_NAME        PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE DGMGRL> DGMGRL> show database orcl 'StatusReport';  ##报错STATUS REPORT       INSTANCE_NAME   SEVERITY ERROR_TEXTDGMGRL> DGMGRL> show database orcl TopWaitEvents  ##等待事件TOP SYSTEM WAIT EVENTS               Event            Wait Time    rdbms ipc message             16769701     class slave wait              2573282         PX Idle Wait              2507538 Space Manager: slave idle wait              1435970       DIAG idle wait              1260277