My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
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

To view full details, 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 a vibrant support community of peers and Oracle experts.