How To Check Whether ARCHIVE Logs are transferred to Standby Database
Whether the ARCHIVE Logs are transferred to Standby can be seen from the ALERT LOGs as follows.
|
1 2 3 4 5 6 7 |
Thu Oct 03 16:18:27 2019 Thread 1 advanced to log sequence 105672 (LGWR switch)-->Log Switch operation performed. Current Redo Log Sequence number reported. Current log# 1 seq# 105672 mem# 0: +DATA/mhrs/onlinelog/group_1.261.922153509 Thu Oct 03 16:18:33 2019 Archived Log entry 291716 added for thread 1 sequence 105671 ID 0x59914531 dest 1:--><strong>Archived Redo Log information reported.</strong> Thu Oct 03 16:18:33 2019 ARC7: Standby redo logfile selected for thread 1 sequence 105671 for destination LOG_ARCHIVE_DEST_2 -->This line means that it has started writing to Standby Redo Log Files. |
After the
