We have two node
primary & standby RAC. It is in sync and i have to split the primary database
& standby database.
I have shutdown
the primary database and went to the standby database server.
I logged in as
DGMGRL and performed a fail over to the standby. Now the standby database become
a primary database. Once i complete the failover; i have disabled the DG
configuration using the DG broker.
When i try to
started the old primary which i have shutdown before performing a failover to
the standby. I got a error message saying “ORA-16649:
possible failover to another database prevents this database from being opened”
SQL> startup
force
ORA-32004:
obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance
started.
Total System
Global Area 7.2958E+10 bytes
Fixed Size 2235808 bytes
Variable Size 1.9059E+10 bytes
Database
Buffers 5.3687E+10 bytes
Redo
Buffers 209866752 bytes
Database
mounted.
ORA-16649: possible failover to another
database prevents this database from being opened
WHEN I CHECKED THE DB ROLE; it is primary
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
Then i managed
to find that database control file get the information from the DG broker
config file. So i have disable the config file on the primary database.
SQL> alter system set dg_broker_start=false scope=both
sid='*';
System altered.
-
After
disabling the DG broker; i can able to open the database without any issue.
SQL> alter database open;
Database
altered.
thank you so much .. it is really useful post
ReplyDelete