Grid Start options in Data Guard Setup
From: Stalin <stalinsk_at_gmail.com>
Date: Wed, 24 Apr 2013 14:51:42 -0700
Message-ID: <CA+FfP7hLj57L-Y6bzPDiOr9tEBV1rwaJ2KDe8EFSeESd-kqriw_at_mail.gmail.com>
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?
Date: Wed, 24 Apr 2013 14:51:42 -0700
Message-ID: <CA+FfP7hLj57L-Y6bzPDiOr9tEBV1rwaJ2KDe8EFSeESd-kqriw_at_mail.gmail.com>
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-lReceived on Wed Apr 24 2013 - 23:51:42 CEST