Re: physical standby WAIT_FOR_GAP

  • From: jason arneil <jason.arneil@xxxxxxxxx>
  • To: litanli@xxxxxxxxx
  • Date: Tue, 22 Dec 2009 19:46:08 +0000


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.



2009/12/22 Li Li <litanli@xxxxxxxxx>:
> 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 on RHEL AS 4.7
> Thanks and hope you all a merry christmas and happy new year!
> -Li
> --

Other related posts: