ORA-16649: possible failover to another database prevents this database from being opened
SQL> startup;
ORACLE instance started.
Total System Global Area 577511424 bytes
Fixed Size 1338000 bytes
Variable Size 461374832 bytes
Database Buffers 109051904 bytes
Redo Buffers 5746688 bytes
Database mounted.
ORA-16649: possible failover to another database prevents this database from
being opened
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
SQL> alter system set dg_broker_start=false scope=both sid='*'; ---- do this
System altered.
SQL> alter database open;
Database altered.
2 comments:
It is a nice doc. thanks for it.
SQL> alter system set dg_broker_start=false scope=both;
alter system set dg_broker_start=false scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16654: fast-start failover is enabled
create pfile from spfile
*.dg_broker_start=false in init file
SQL> startup mount pfile='initvihaan.ora';
ORACLE instance started.
Total System Global Area 577511424 bytes
Fixed Size 1338000 bytes
Variable Size 469763440 bytes
Database Buffers 100663296 bytes
Redo Buffers 5746688 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
Post a Comment