Oracle檢視歸檔是否被備庫應用

首先是查詢v$archived_log檢視，然後分析applied欄位資訊，官方說明如下：

Indicates whether an archived redo log file has been applied to the corresponding physical standby database. The value is always NO for local destinations. This column is meaningful on a physical standby database for rows where REGISTRAR = RFS: ■ If REGISTRAR = RFS and APPLIED = NO, then the log file has been received but has not yet been applied. ■ If REGISTRAR = RFS and APPLIED = IN-MEMORY, then the log file has been applied in memory, but the datafiles have not yet been updated. ■ If REGISTRAR = RFS and APPLIED = YES, then the log file has been applied and the datafiles have been updated. This column can be used to identify log files that can be backed up and deleted. When used for this purpose, the value IN-MEMORY should be treated as if it were NO.