WARNING: Managed Standby Recovery Started With REAL TIME APPLY (Doc ID 2254108.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The following message is reported in the alert.log of a physical standby database:

WARNING: Managed Standby Recovery started with REAL TIME APPLY
DELAY <n> minutes specified at primary ignored

where the numeric value after the DELAY is the actual delay configured for the related LOG_ARCHIVE_DEST_n on primary.

This message is reported even after managed recovery is restarted with the USING ARCHIVED LOGFILE attribute due to changes in behavior introduced in 12.1 and up.

Changes

In 12.1, a physical standby will by default run with Real Time Apply enabled.  The USING CURRENT LOGFILE attributes are depreciated.  To support using a DELAY, managed recovery has to be restarted with USING ARCHIVED LOGFILE instead.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms