ORACLE Instance

RAC & Data Guard – FAL issues after role change

Today I had to convert a physical standby to snapshot standby using the DG Broker. The steps to perform this are very simple and completed with no errors. However, while performing a health check of the databases I noticed a slight issue.

Messages in the Primary DB alert log were showing this:

<pre>Tue Jul 15 10:25:56 2014
FAL[server, ARC5]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance PPMOBB1 - Archival Error. Archiver continuing.
Tue Jul 15 10:25:56 2014
FAL[server, ARCj]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance PPMOBB1 - Archival Error. Archiver continuing.

And messages in the Standby DB alert log were showing this:

<pre>Tue Jul 15 09:24:23 2014
Creating archive destination file : +FRA (248306 blocks)
Tue Jul 15 09:24:23 2014
Creating archive destination file : +FRA (157408 blocks)

In order to fix this and allow the Primary DB to send the archivelogs to the snapshot standby, I had to set the max_connections property from 4 to 1 within the DG Broker config:

<pre>dgmgrl /
DGMGRL> edit database 'RPMOBB' set property max_connections=1;

After setting this, the snapshot standby started to receive the missing archivelogs and then stayed in sync thereafter.
The solution was found in this MOS Doc. However, it is supposedly fixed in 11.2 and I am running 11.2.0.3 so appears not be the case.

Archive logs Shipping Skipped Intermittently, Standby Fails to Resolve Gap Automatically (Doc ID 1366234.1)

Advertisements