Missing Some Archive Logs On Standby Database that are not applied (Doc ID 1665814.1)

Last updated on APRIL 30, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

11.2.0.3 non-RAC primary and standby databases.

Some of the archive logs are not available on the standby database node. These missing archive logs are transferred to other LOG_ARCHIVE_DEST 's from primary without any issue. Alert logs on both primary and standby doesn't show any errors either. This happens intermitantly several times a week.  The archive log is silently missing at the standby database and was not applied. They then need to be copied to the standby and registered so they will apply and MRP can continue.

Changes

 No changes. The problem existed in the original configuration.

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