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 Event	Monitors the Amount of Time Spent By . . .
ARCH wait on ATTACH	All ARCn processes to spawn an RFS connection.
ARCH wait on SENDREQ	All 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 DETACH	All ARCn processes to delete an RFS connection.

lgwr syn等待事件

Wait Event	Monitors the Amount of Time Spent By . . .
LGWR wait on LNS	The LGWR process waiting to receive messages from the LNSn process.
LNS wait on ATTACH	All network servers to spawn an RFS connection.
LNS wait on SENDREQ	All 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 DETACH	All network servers to delete an RFS connection.

lgwr async等待事件

Wait Event	Monitors the Amount of Time Spent By . . .
LNS wait on DETACH	All network servers to delete an RFS connection.
LNS wait on ATTACH	All network servers to spawn an RFS connection.
LNS wait on SENDREQ	All 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 Wait	The LNSn process to get hold of the control file transaction during its lifetime.
True ASYNC Wait for ARCH log	The 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 activation	The LNSn process waiting for an inactive destination to become active.
True ASYNC log-end-of-file wait	The LNSn process waiting for the next bit of redo after it has reached the logical end of file.