场景:备库只能接收归档日志,不能实时应用redo log,如果主端日志不切换,备端一直会有adg延迟
后台日志:
RFS[1]: Assigned to RFS process 5351
RFS[1]: No standby redo logfiles available for thread 1
RFS[2]: Assigned to RFS process 5353
RFS[2]: No standby redo logfiles available for thread 1
RFS[1]: Opened log for thread 1 sequence 102 dbid 1485808053 branch 960908345
RFS[2]: Opened log for thread 1 sequence 103 dbid 1485808053 branch 960908345
Archived Log entry 175 added for thread 1 sequence 102 rlc 960908345 ID 0x579951e6 dest 3:
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2017_12_27/o1_mf_1_102_f46gw1t4_.arc
Media Recovery Waiting for thread 1 sequence 103 (in transit)
Completed: ALTER DATABASE RECOVER MANA