oracle10g data guard(dg)_主庫控制檔案受損或loss_自動關庫測試
********************* ATTENTION: ********************
The controlfile header block returned by the OS
has a sequence number that is too old.
The controlfile might be corrupted.
PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE
without following the steps below.
RE-STARTING THE INSTANCE CAN CAUSE SERIOUS DAMAGE
TO THE DATABASE, if the controlfile is truly corrupted.
In order to re-start the instance safely,
please do the following:
(1) Save all copies of the controlfile for later
analysis and contact your OS vendor and Oracle support.
(2) Mount the instance and issue:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
(3) Unmount the instance.
(4) Use the script. in the trace file to
RE-CREATE THE CONTROLFILE and open the database.
*****************************************************
Instance terminated by ARC0, pid = 2080
1,看了10g data guard官方文件,講述只要主庫控制檔案損壞或者找不到,主庫會自動down庫,我在rhel上面,mv了所有控制檔案,主庫仍舊執行如初
2,我繼續堅持,不死心,不斷mv控制檔案,主庫看來發火了,主動down庫,上為摘錄一節alert,供後記
The controlfile header block returned by the OS
has a sequence number that is too old.
The controlfile might be corrupted.
PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE
without following the steps below.
RE-STARTING THE INSTANCE CAN CAUSE SERIOUS DAMAGE
TO THE DATABASE, if the controlfile is truly corrupted.
In order to re-start the instance safely,
please do the following:
(1) Save all copies of the controlfile for later
analysis and contact your OS vendor and Oracle support.
(2) Mount the instance and issue:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
(3) Unmount the instance.
(4) Use the script. in the trace file to
RE-CREATE THE CONTROLFILE and open the database.
*****************************************************
Instance terminated by ARC0, pid = 2080
1,看了10g data guard官方文件,講述只要主庫控制檔案損壞或者找不到,主庫會自動down庫,我在rhel上面,mv了所有控制檔案,主庫仍舊執行如初
2,我繼續堅持,不死心,不斷mv控制檔案,主庫看來發火了,主動down庫,上為摘錄一節alert,供後記
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-626459/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【DG】Data Guard主備庫Failove切換AI
- 【DG】Data Guard主備庫Switchover切換
- DATA GUARD主庫丟失資料檔案的恢復(3)
- DATA GUARD主庫丟失資料檔案的恢復(1)
- DATA GUARD主庫丟失資料檔案的恢復(2)
- dg主庫建立檔案備庫未同步解決方法
- [20190225]測試如何使用dg快速主庫.txt
- 【DG】Data Guard搭建(physical standby)
- DG備庫手動管理 新增資料檔案
- Oracle DG備庫手動管理新增資料檔案Oracle
- 使用Data Guard Broker進行Data Guard物理備用庫配置(Oracle 19c)Oracle
- 【ASK_ORACLE】Oracle Data Guard(一)DG架構Oracle架構
- oracle dg庫資料檔案空間不足Oracle
- 織夢資料庫配置檔案資料庫損壞:嘗試修復資料庫資料庫
- 主備庫記憶體不一致的Data Guard環境搭建記憶體
- [20180718]拷貝資料檔案從dg庫.txt
- 1 關於 Oracle Data GuardOracle
- oracle dg庫資料檔案建立失敗ORA-01111Oracle
- 控制檔案損壞處理
- 12c DG新特性 - Active Data Guard Far Sync (Doc ID 2179719.1)
- G008-ORACLE-DG ORACLE 19C Active Data Guard DML RedirectionOracle
- 挽救DG中主庫的nologging操作的塊
- 自動化測試 RobotFramework自定義靜態測試類庫總結Framework
- 19 Oracle Data Guard 相關檢視Oracle
- oracle控制檔案的損壞或完全丟失的恢復辦法Oracle
- 【自動化測試】Python 讀取 .ini 格式檔案Python
- 案例:DG主庫未設定force logging導致備庫壞塊
- InterBase資料庫檔案損壞的修復方法資料庫
- Oracle-DG最大保護模式下,dg備庫出現問題對主庫有什麼影響?Oracle模式
- 【ASK_ORACLE】Oracle Data Guard(四)快照備庫的概念和優勢Oracle
- 【ASK_ORACLE】Oracle Data Guard(二)物理備庫的概念和優勢Oracle
- Oracle 控制檔案損壞解決方案Oracle
- oracle 控制檔案及引數檔案何時自動備份Oracle
- Python自動化測試之獲取配置檔案資訊Python
- Oracle 12c的DG自動同步密碼檔案--ASM 新特性:共享密碼檔案Oracle密碼ASM
- 【ASK_ORACLE】Oracle Data Guard(三)邏輯備庫的概念和優勢Oracle
- Python科研武器庫 - 檔案/路徑操作 - 判斷檔案或資料夾Python
- 4.2.13 主備庫實現自動故障轉移
- 教你自動恢復MySQL資料庫的日誌檔案(binlog)MySql資料庫