Monday, August 13, 2018

WARNING: Managed Standby Recovery started with REAL TIME APPLY. DELAY ... ignored


In the customer's alert.log:


WARNING: Managed Standby Recovery started with REAL TIME APPLY
  DELAY 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 2018
WARNING: Managed Standby Recovery started with REAL TIME APPLY
  DELAY 2 minutes specified at primary ignored
ARC1: Standby redo logfile selected for thread 1 sequence 187706 for destination LOG_ARCHIVE_DEST_2
Mon Aug 13 14:48:10 2018
Thread 1 advanced to log sequence 187708 (LGWR switch)
  Current log# 2 seq# 187708 mem# 0: +DATAC1/SPURSTB/ONLINELOG/group_2.redo
  Current log# 2 seq# 187708 mem# 1: +RECOC1/SPURSTB/ONLINELOG/group_2.redo



In standby:
Mon Aug 13 14:46:36 2018
WARNING: Managed Standby Recovery started with REAL TIME APPLY
  DELAY 2 minutes specified at primary ignored
RFS[1]: Selected log 5 for thread 1 sequence 187706 dbid 496990843 branch 945690334
Mon Aug 13 14:46:57 2018
Media Recovery Waiting for thread 1 sequence 187706 (in transit)
Mon Aug 13 14:47:15 2018
Archived Log entry 320928 added for thread 1 sequence 187706 ID 0x22d4655a dest 1:
Mon Aug 13 14:47:15 2018
ARC4: Archive log thread 1 sequence 187706 available in 1 minute(s)
Mon Aug 13 14:47:16 2018
Media Recovery Delayed for 1 minute(s) (thread 1 sequence 187706)
Mon Aug 13 14:48:16 2018
Media Recovery Log +RECOC1/SPUR/ARCHIVELOG/2018_08_13/thread_1_seq_187706.1487.984062811
Mon Aug 13 14:48:34 2018
WARNING: Managed Standby Recovery started with REAL TIME APPLY
  DELAY 2 minutes specified at primary ignored
RFS[1]: Selected log 5 for thread 1 sequence 187707 dbid 496990843 branch 945690334
Mon Aug 13 14:48:47 2018
Media Recovery Waiting for thread 1 sequence 187707 (in transit)
Mon Aug 13 14:49:11 2018
Archived Log entry 320929 added for thread 1 sequence 187707 ID 0x22d4655a dest 1:
Mon Aug 13 14:49:11 2018
ARC0: Archive log thread 1 sequence 187707 available in 1 minute(s)
Mon Aug 13 14:49:14 2018
Media 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.

How to disable/setup autostart parameters for specified instance ?

Q: We have a 4-node RAC. I need to disable autostart of the DB on one node only.    How to do it and how to see autostart parameters, confir...