RE: Oracle restart and Physical Data Guard
Date: Wed, 17 Oct 2012 17:46:29 +0000
Message-ID: <1184E7EFAB1D1C47A5038D06F64BE9260205A565_at_XM-MBX-02-PROD.ad.uchicago.edu>
Hello,
In the configurations that allow FSFO, when the old primary starts back up it will do a check with the Observer and it's standby pair (when mounted) to make sure if it is still the primary database. If it cannot confirm, it will not open and will stay in mounted mode. In your example, during that check it should determine that it is no longer the primary database in that configuration and will not start up. If configured correctly, the observer should then also tell it to reinstate itself as the standby
That is at least my understanding of the process. We are running FSFO, but not with Oracle restart.
Thanks,
Mike
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mek S
Sent: Wednesday, October 17, 2012 10:52 AM
To: ORACLE-L
Subject: Oracle restart and Physical Data Guard
Hello,
I wonder if there are any issues in using Oracle 11gR2 restart and DG FSFO Observer together. Oracle restart is used for automatic restart of resources (database instance, listeners, etc..) after server reboot for example, if the Observer failover to the physical standby and open it and at the same time , oracle restart open the primary then split brain. Any experience ?
Thank you
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 17 2012 - 19:46:29 CEST