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
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;
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='*';
- After disabling the DG broker; i can able to open the database without any issue.
SQL> alter database open;