DataGuard Weirdness

From: Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com>
Date: Thu, 9 Feb 2012 13:39:24 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F8292AB8F2_at_sunmsx01.Corp.Acxiom.net>

Guys,  

Just set up an 11gR2 DG config (one primary/one standby) on Linux and am seeing some strange errors in the standby alert log.....  

Every now and again, (its fairly random) the following is happening.  

RFS[278]: Selected log 5 for thread 1 sequence 29031 dbid 874073702 branch 764422822

Thu Feb 09 13:02:49 2012

RFS[278]: Selected log 5 for thread 1 sequence 29032 dbid 874073702 branch 764422822

Thu Feb 09 13:02:56 2012

Fetching gap sequence in thread 1, gap sequence 29030-29030

Thu Feb 09 13:03:49 2012

RFS[278]: Selected log 5 for thread 1 sequence 29033 dbid 874073702 branch 764422822

Thu Feb 09 13:04:48 2012

FAL[client]: Failed to request gap sequence

GAP - thread 1 sequence 29030-29030

DBID 874073702 branch 764422822

FAL[client]: All defined FAL servers have been attempted.

---

Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization

parameter is defined to a value that's sufficiently large

enough to maintain adequate log switch information to resolve

archivelog gaps.

---

 

I have googled until I am sick and also been on My Oracle Support . Everything points to a bug (which says has been fixed in 11g) as I have tried all the various select statements from the internal views that have been recommended on various web sites (and MOS) yet they all return no rows which supposedly means all is fine. Despite this we are still missing logs which have not been shipped onto the standby from the Primary.  

Any ideas ?  

Cheers

Lee

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank You.

---

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 09 2012 - 07:39:24 CST