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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- Bug 12725963 - New database connection fails with ORA-12541 after vip failoverDatabaseAI
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Database TimeoutDatabase
- Database OverallDatabase
- database no shardingDatabase
- Oracle 12.2 使用Database Link優化Standby Database WorkloadOracleDatabase優化
- ORACLE database vaultOracleDatabase
- Relationship Database DesignDatabase
- 3.4 Quiescing a DatabaseUIDatabase
- idea--DatabaseIdeaDatabase
- Oracle clone databaseOracleDatabase
- database的connectDatabase
- Password is required when adding a database to AG group if the database has a master keyUIDatabaseAST
- Oracle 19c透過recover standby database from service修復GAP案例OracleDatabase
- Guide to Database as a Service (DBaaS)GUIIDEDatabase
- Oracle Database Scheduler整理OracleDatabase
- 3.4.1 About Quiescing a DatabaseUIDatabase
- 3.3 Shutting Down a DatabaseDatabase
- 3.2.2 Opening a Closed DatabaseDatabase
- 3.2.1 Mounting a Database to an InstanceDatabase
- 4.5.1.2 srvctl add databaseDatabase
- Laravel workflow with database and roleLaravelDatabase
- Oracle Physical Database LimitsOracleDatabaseMIT
- SQL Database for Modern DevelopersSQLDatabaseDeveloper
- LIST INCARNATION OF DATABASE含義Database
- 1、 Getting Stared with Database AdministrationDatabase
- 【譯】Database Profiling with Visual StudioDatabase
- alter database disable thread 2Databasethread
- CSCI235 – Database SystemsDatabase
- database 空值問題Database
- 1.2 Physiacel Structure of Database ClusterStructDatabase