11g ADG 出現FAL[client,USER]:error 12154 connect to orcl for fetching gap
前幾天客戶反映ADG備庫出現報錯具體內容如下:
FAL[client,USER]:error 12154 connect to orcl for fetching gap sequence,
嘗試對備庫進行進行修復,重新應用日誌,還是無法恢復正常,
經查詢主庫 u01空間滿了導致資料庫無法連線
需要主庫進行以下查詢,並反饋查詢結果,進一步分析問題原因:
備庫查詢gap
主庫查詢已經被備份收走了。
rman> list archivelog sequence between 6243 and 6363 thread 1;
rman> list archivelog sequence between 9485 and 9592 thread 2;
rman> list archivelog sequence between 8487 and 8606 thread 3;
--查詢已經在備份收走
list backup of archivelog sequence between 6243 and 6363 thread 1;
--後續建議做下基於scn的增量備份,傳輸到備庫應用可以追平。
目前備庫的恢復scn為12858759049725
主庫操作如下:
BACKUP INCREMENTAL FROM SCN 12858759049725 DATABASE FORMAT '/data/sxeomsdb_scn_%U' tag 'For Standby Gap';
將備份複製備庫使用
RECOVER DATABASE NOREDO進行恢復。
恢復完成以後需要還原一下控制檔案,然後open,重新應用日誌。
詳細的步驟在部落格
http://blog.itpub.net/31547066/viewspace-2285677/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31547066/viewspace-2646756/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- FAL_CLIENT和FAL_SERVER引數詳解clientServer
- 解決 Jenkins 上 git 出現的 “ERROR: Error fetching remote repo 'origin'” 問題JenkinsGitErrorREM
- mysql can't connect error about privilege----not root userMySqlError
- PING[ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12154.AIError
- 關於RAC 的Data Guard中FAL_SERVER及FAL_CLIENT的設定Serverclient
- EF:Oracle.DataAccess.Client.OracleException: ORA-12154: TNS:could not resolve the connect identifier specifiedOracleclientExceptionIDE
- 11gR2 DG不再需要FAL_CLIENTclient
- 主備互相切換用到的引數VALID_FOR、fal_client、fal_serverclientServer
- database error 12154 at CONDatabaseError
- Oracle ADG Heartbeat failed to connect to standby故障案例OracleAI
- 9i Standby新引數:fal_server與fal_client,standby_file_management [final]Serverclient
- dataguard 主備庫出現gap
- Oracle DataGuard FAL[client, ARC2]: Error 16191 connecting to 問題處理過程記錄OracleclientError
- 11g ADG環境搭建
- dataguard備庫出現GAP修復
- Unable to Connect to Database with Oracle Client Software for WindowsDatabaseOracleclientWindows
- Dynamics CRM CRM Reporting Error: Error occurred while fetching the data extension的解決方法ErrorWhile
- Swoole 原始碼分析——Client模組之Connect原始碼client
- 批量處理物理備庫出現archive gapHive
- error:package mysql-client is not relocatableErrorPackageMySqlclient
- SWITCHOVER主庫出現LOG SWITCH GAP和RESOLVABLE GAP解決一例
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- ORA-12154: TNS:could not resolve the connect identifier specifiedIDE
- ORA-12154: TNS: could not resolve the connect identifier specifiedIDE
- Fatal NI connect error 12170Error
- 物理DG的FAL_CLIENT設定錯誤引起的主庫報錯client
- oracle 10g 出現gap的解決方法Oracle 10g
- oracle 10.2.0.3對USER收回CONNECT及RESOURCEOracle
- [重慶思莊每日技術分享]-alert頻繁出現12170. Fatal NI connect errorError
- Fatal NI connect error 12170.Error
- maridb Error 'Operation DROP USER failed forErrorAI
- Error accessing PRODUCT_USER_PROFILEError
- linux安裝MySQL出現ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)LinuxMySqlErrorlocalhost
- oracle 10g oem 報出RemoteOperationException: ERROR: Wrong password for userOracle 10gREMExceptionError
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Fatal NI connect error 12170 錯誤Error
- FAL[server, ARCN]: FAL archive failed ORA-16401ServerHiveAI
- Oracle案例09——ORA-12154: TNS:could not resolve the connect identifier specifiedOracleIDE