Re: Automatic startup after FSFO

set for both databases "Y" and also for both databases set hidden parameter "_query_on_physical" = FALSE - this parameter prevent to open standby database.

another solution is to use Oracle Restart, which manage startup of db after reboot/crash
DG Broker should change start option for databases after failover/switchover, but there were several bugs (1 year ago) more informations in

Bug: 15986647 WRONG START OPTIONS VALUES FOR DATABASE CONFIG AFTER DG SWITCHOVER
Bug 12596559 - CRS NEEDS TO HAVE DATABASE ROLE BASED START_OPTIONS Bug 20162008 : CRS START_OPTIONS DO NOT FOLLOW DATAGUARD STANDBY STATE EVEN WITH PSU4 according to my comunication with oracle support "Both bugs 15986647 and 12596559 are fixed in 12.1 not in 11.2.0.4"

Marian

From: John Jones <john.jones_at_duke.edu> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>, Date: 26. 05. 2015 20:19

Subject:        Automatic startup after FSFO
Sent by:        oracle-l-bounce_at_freelists.org

I have setup FSFO using an Observer server and everything seems to be working fairly well. The one point that we are struggling with is what happens to out start up scripts once a switch over has occurred.  

So say we have production on server1 and standby on server2 and our observer is running on server3. We have modified/created database startup scripts to use the /etc/oratab and use the flag at the end to start the databases. If it has “Y” it starts as a normal database. If it has “S” it starts as a standby database, and “N” does not start it at all.  

So after a failover to the standby, the /etc/oratab on server2 would have an “S” and it would not be the primary and need to be started normal. Server1 would be the standby with an “Y’. but need to be started in Standby mode.  

I know I can change them if I know there was failover, but what if something happens before I can change the values.  

John

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