In the customer's alert.log:
WARNING: Managed Standby Recovery started with REAL TIME APPLYDELAY 2 minutes specified at primary ignored
This message is appeared in primary's and standby's alert logs.
In primary:
Mon Aug 13 14:46:36 2018WARNING: Managed Standby Recovery started with REAL TIME APPLYDELAY 2 minutes specified at primary ignoredARC1: Standby redo logfile selected for thread 1 sequence 187706 for destination LOG_ARCHIVE_DEST_2Mon Aug 13 14:48:10 2018Thread 1 advanced to log sequence 187708 (LGWR switch)Current log# 2 seq# 187708 mem# 0: +DATAC1/SPURSTB/ONLINELOG/group_2.redoCurrent log# 2 seq# 187708 mem# 1: +RECOC1/SPURSTB/ONLINELOG/group_2.redo
In standby:
Mon Aug 13 14:46:36 2018WARNING: Managed Standby Recovery started with REAL TIME APPLYDELAY 2 minutes specified at primary ignoredRFS[1]: Selected log 5 for thread 1 sequence 187706 dbid 496990843 branch 945690334Mon Aug 13 14:46:57 2018Media Recovery Waiting for thread 1 sequence 187706 (in transit)Mon Aug 13 14:47:15 2018Archived Log entry 320928 added for thread 1 sequence 187706 ID 0x22d4655a dest 1:Mon Aug 13 14:47:15 2018ARC4: Archive log thread 1 sequence 187706 available in 1 minute(s)Mon Aug 13 14:47:16 2018Media Recovery Delayed for 1 minute(s) (thread 1 sequence 187706)Mon Aug 13 14:48:16 2018Media Recovery Log +RECOC1/SPUR/ARCHIVELOG/2018_08_13/thread_1_seq_187706.1487.984062811Mon Aug 13 14:48:34 2018WARNING: Managed Standby Recovery started with REAL TIME APPLYDELAY 2 minutes specified at primary ignoredRFS[1]: Selected log 5 for thread 1 sequence 187707 dbid 496990843 branch 945690334Mon Aug 13 14:48:47 2018Media Recovery Waiting for thread 1 sequence 187707 (in transit)Mon Aug 13 14:49:11 2018Archived Log entry 320929 added for thread 1 sequence 187707 ID 0x22d4655a dest 1:Mon Aug 13 14:49:11 2018ARC0: Archive log thread 1 sequence 187707 available in 1 minute(s)Mon Aug 13 14:49:14 2018Media Recovery Delayed for 1 minute(s) (thread 1 sequence 187707)
Cause:
Starting from 12.1 physical standby run as 'Real Time Apply" by default.
If you need the DELAY X minutes then you should restart managed recovery with " USING ARCHIVED LOGFILE" clause:
ALTER
DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT USING ARCHIVED
LOGFILE
;
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.