RE: Grid Start options in Data Guard Setup

Are you referring to changing the way in which Grid starts the instances?
If so, then yes, you will need to change the startup options in grid with the crsctl command.
Reply if you need details / example.

Lisa Koivu
DATABASE ADMINISTRATOR
STARWOOD VACATION OWNERSHIP
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stalin Sent: Wednesday, April 24, 2013 5:52 PM
To: oracle-l
Subject: Grid Start options in Data Guard Setup

All,
We have 2 node RAC cluster running 11.2.0.3 latest PSUs on RHEL Linux 6x, and a DG environment with similar setup. When we did the DG setup, we made the Grid Startup options to be mount for the database in Standby. So that even if the server(s) in DG environment gets rebooted or DB resources crashes, DB would be brought back to mount mode. Now the question is, If we were to switch the roles where DG environment becomes primary and primary (use to be) becomes Standby, should we manually change the Grid Startup options to open in Primary and Mount in Standby?

Wondering if there are ways to have Grid change it's option based on DB Role.

Note: We use DGMGRL for all our DG maintenance but don't use fast-start failover.

--

Thanks,

Stalin

--

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

This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 26 2013 - 13:41:30 CEST