Saturday, 19 May 2012


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.



at

2 comments:

  1. Unknown11 October 2012 at 20:25

    It is a nice doc. thanks for it.

    ReplyDelete
  2. Anuj Singh7 June 2013 at 21:03


    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.

    ReplyDelete