[Oracle工程师手记] Data Guard 环境中,查找最近发生的与 Data Guard 相关的错误的方法


在主库和备库中,都可以通过如下的查询,获得关于是否发生了与 Data Guard 相关的结果:

column message format a80
SELECT ins.thread#, timestamp, message FROM gv$dataguard_status sts, gv$instance ins WHERE sts.inst_id = ins.inst_id
 AND severity in ('Error','Fatal') ORDER BY timestamp, thread#; 

 
结果的例子:

主库:

SQL> column message format a80
SQL>
SQL> SELECT ins.thread#, timestamp, message FROM gv$dataguard_status sts, gv$instance ins WHERE sts.inst_id = ins.inst_id
     AND severity in ('Error','Fatal') ORDER BY timestamp, thread#;


TIMESTAMP         THREAD#  MESSAGE
--------                ------   --------
15-2月 -2020 02:52:36     2      Error 12514 received logging on to the standby
15-2月 -2020 02:52:36     2      TT02: Error 12514 attaching to RFS for reconnect
15-2月 -2020 02:52:36     2      Error 3135 for archive log file 7 to 'cod_s'
15-2月 -2020 02:52:37     1      Error 12514 received logging on to the standby
15-2月 -2020 02:52:37     1      TT02: Error 12514 attaching to RFS for reconnect
15-2月 -2020 02:52:37     1      Error 3135 for archive log file 4 to 'cod_s'
15-2月 -2020 02:57:48     1      Error 12514 received logging on to the standby
15-2月 -2020 02:58:09     2      Error 12514 received logging on to the standby

 
备库:

SQL> column message format a80
SQL> SELECT ins.thread#, timestamp, message FROM gv$dataguard_status sts, gv$instance ins WHERE sts.inst_id = ins.inst_id
     AND severity in ('Error','Fatal') ORDER BY timestamp, thread#;


TIMESTAMP         THREAD#     MESSAGE
---------               -------         -------
15-2月 -2020 03:04:04     1         Error 12154 received logging on to the standby
15-2月 -2020 03:04:04     1         FAL[client, ARC1]: Error 12154 connecting to cod_p01,cod_p02 for fetchin g gap sequence

 

posted @ 2021-04-10 21:20  健哥的数据花园  阅读(72)  评论(0编辑  收藏  举报