Re: physical standby WAIT_FOR_GAP

I've seen this scenario occur quite a bit as well. I've seen creating a new standby controlfile from the primary can straighten things out.

jason.

--
http://jarneil.wordpress.com



2009/12/22 Li Li <litanli_at_gmail.com>:


> Greetings List,

>

> We have a physical standby running on a 4-node RAC. last night the

> apply instance (instance 1) had ora-04031 error and data guard broker

> changed the apply instance to be instance 2. Now apply instance

> (instance 2) shows "WAIT_FOR_GAP" for a log sequence 5xxx, which is a

> very old log, and has been applied a long time ago. Has any one seen

> this before? How do I trick the apply instance to skip the logs that

> have been applied already and start applying the logs that haven't

> been received but haven't applied.

>

> Oracle version 10.2.0.3 on RHEL AS 4.7

>

> Thanks and hope you all a merry christmas and happy new year!

> -Li

> --

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

>

>

>

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