dataguar之监控日志传输

监控日志文件归档信息

1决定redo log的状态

SELECT THREAD#, SEQUENCE#, ARCHIVED, STATUS FROM V$LOG;

2在主库上执行下面的语句来看最近归档的线程和序列号

SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;

3查看目的地最近归档的日志文件

SELECT DESTINATION, STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#  FROM V$ARCHIVE_DEST_STATUS  WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';
最近写到目的地的日志应该和最近归档的一样。

4查看归档日子是否接受到了

查看下面的语句看是否有归档日志没有被特定的站点接收到。假设当前本地目的地是1，远程备库目的地是2，为了看远程目的地上缺失的日志文件，执行下面的语句

SELECT LOCAL.THREAD#, LOCAL.SEQUENCE# FROM  (SELECT THREAD#, SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=1)  LOCAL WHERE  LOCAL.SEQUENCE# NOT IN (SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND THREAD# = LOCAL.THREAD#);

监控日志传输服务的性能

arcn进程的等待事件

Wait EventMonitors the Amount of Time Spent By . . .ARCH wait on ATTACHAll ARCn processes to spawn an RFS connection.ARCH wait on SENDREQAll ARCn processes to write the received redo data to disk as well as open and close the remote archived redo log files.ARCH wait on DETACHAll ARCn processes to delete an RFS connection.

lgwr syn等待事件

Wait EventMonitors the Amount of Time Spent By . . .LGWR wait on LNSThe LGWR process waiting to receive messages from the LNSn process.LNS wait on ATTACHAll network servers to spawn an RFS connection.LNS wait on SENDREQAll network servers to write the received redo data to disk as well as open and close the remote archived redo log files.LNS wait on DETACHAll network servers to delete an RFS connection.

lgwr async等待事件

Wait EventMonitors the Amount of Time Spent By . . .LNS wait on DETACHAll network servers to delete an RFS connection.LNS wait on ATTACHAll network servers to spawn an RFS connection.LNS wait on SENDREQAll network servers to write the received redo data to disk as well as open and close the remote archived redo log files.True ASYNC Control FileTXN WaitThe LNSn process to get hold of the control file transaction during its lifetime.True ASYNC Wait for ARCH logThe LNSn process waiting to see the archived redo log (if the LNSn process is archiving a current log file and the log is switched out).Waiting for ASYNC dest activationThe LNSn process waiting for an inactive destination to become active.True ASYNC log-end-of-file waitThe LNSn process waiting for the next bit of redo after it has reached the logical end of file.