ORA-16649: possible failover to another database prevents this database from being opened
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
解决：
[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将原主库置为新备库：
REINSTATE DATABASE oradg11g;
解决方法二：修改dg_broker_start为false，这样重启数据库即可，此时原主库依然是主库的角色：
alter system set dg_broker_start=false;
示例：
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宝典）、添加小麦苗微 信， 学习最实用的数据库技术。
........................................................................................................................
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26736162/viewspace-2651937/，如需转载，请注明出处，否则将追究法律责任。
