ORA-16649: possible failover to another database prevents this database from bei

ORA-16649: possible failover to another database prevents this database from being opened

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

SYS@oradg11g > startup force ORACLE instance started. Total System Global Area  208769024 bytes Fixed Size                  2226936 bytes Variable Size             167773448 bytes Database Buffers           33554432 bytes Redo Buffers                5214208 bytes Database mounted. ORA-16649: possible failover to another database prevents this database from being opened SYS@oradg11g > col VALUE format a100 SYS@oradg11g > select database_role from v$database; DATABASE_ROLE ---------------- PRIMARY SYS@oradg11g > alter database open; alter database open * ERROR at line 1: ORA-16649: possible failover to another database prevents this database from being opened

 

解决：

1 2 3 4 5 6 7 8 9 10 11

[root@rhel6lhr ~]# oerr ora 16649 16649, 0000, "possible failover to another database prevents this database from being opened" // *Cause:  An attempt to open the primary database was made either after //          a failover occurred, or when it was likely to have occurred as //          the result of the primary being isolated from the fast-start //          failover target standby database and from the fast-start failover //          observer. // *Action: Check if a failover did occur. If fast-start failover is enabled,  //          and a failover did not occur, ensure that connectivity exists //          between the primary database and either the observer or the //          target standby database. Then, try opening the database again.

 

原因：原备库执行了failover操作了。

 

解决方法一： 在dgmgrl中执行reinstate将原主库置为新备库：

1	REINSTATE DATABASE  oradg11g;

 

解决方法二：修改dg_broker_start为false，这样重启数据库即可，此时原主库依然是主库的角色：

1	alter system set dg_broker_start=false;

 

示例：

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51

SYS@oradg11g > show parameter broke NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0                                                  /dbhome_1/dbs/dr1oradg11g.dat dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0                                                  /dbhome_1/dbs/dr2oradg11g.dat dg_broker_start                      boolean     TRUE SYS@oradg11g > alter system set dg_broker_start=false; System altered. SYS@oradg11g > set line 1000 SYS@oradg11g > col name format a25 SYS@oradg11g > col VALUE format a100 SYS@oradg11g > SELECT a.NAME,   2         a.VALUE   3  FROM   v$parameter a   4  WHERE  a.name in ('dg_broker_start','db_name','db_unique_name','log_archive_config','log_archive_dest_1','log_archive_dest_2','log_archive_dest_state_1','log_archive_dest_state_2','log_archive_max_processes','remote_login_passwordfile','db_file_name_convert','log_file_name_convert','standby_file_management','fal_server','fal_client'); NAME                      VALUE ------------------------- ---------------------------------------------------------------------------------------------------- db_file_name_convert      oradgphy, oradg11g log_file_name_convert     oradgphy, oradg11g log_archive_dest_1        LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES) log_archive_dest_2 log_archive_dest_state_1  ENABLE log_archive_dest_state_2  ENABLE fal_client                tns_oradg11g fal_server                tns_oradgphy log_archive_config        dg_config=(oradg11g,oradgphy) log_archive_max_processes 4 standby_file_management   AUTO remote_login_passwordfile EXCLUSIVE db_name                   oradg11g db_unique_name            oradg11g dg_broker_start           FALSE 15 rows selected. SYS@oradg11g >  SYS@oradg11g >  SYS@oradg11g > startup force ORACLE instance started. Total System Global Area  208769024 bytes Fixed Size                  2226936 bytes Variable Size             167773448 bytes Database Buffers           33554432 bytes Redo Buffers                5214208 bytes Database mounted. Database opened. SYS@oradg11g > select database_role from v$database; DATABASE_ROLE ---------------- PRIMARY SYS@oradg11g >

 

---

---

About Me

........................................................................................................................ ● 本文作者：小麦苗，部分内容整理自网络，若有侵权请联系小麦苗删除 ● 本文在itpub、博客园、CSDN和个人微 信公众号（ xiaomaimiaolhr ）上有同步更新 ● 本文itpub地址： http://blog.itpub.net/26736162 ● 本文博客园地址： http://www.cnblogs.com/lhrbest ● 本文CSDN地址： https://blog.csdn.net/lihuarongaini ● 本文pdf版、个人简介及小麦苗云盘地址： http://blog.itpub.net/26736162/viewspace-1624453/ ● 数据库笔试面试题库及解答： http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA宝典今日头条号地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826 ........................................................................................................................ ● QQ群号： 230161599 （满） 、618766405 ● 微 信群：可加我微 信，我拉大家进群，非诚勿扰 ● 联系我请加QQ好友 （ 646634621 ） ，注明添加缘由 ● 于 2019-07-01 06:00 ~ 2019-07-31 24:00 在西安完成 ● 最新修改时间：2019-07-01 06:00 ~ 2019-07-31 24:00 ● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解 ● 版权所有，欢迎分享本文，转载请保留出处 ........................................................................................................................ ● 小麦苗的微店 ： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ● 小麦苗出版的数据库类丛书 ： http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麦苗OCP、OCM、高可用网络班 ： http://blog.itpub.net/26736162/viewspace-2148098/ ● 小麦苗腾讯课堂主页 ： https://lhr.ke.qq.com/ ........................................................................................................................ 使用 微 信客户端 扫描下面的二维码来关注小麦苗的微 信公众号（ xiaomaimiaolhr ）及QQ群（DBA宝典）、添加小麦苗微 信， 学习最实用的数据库技术。 ........................................................................................................................