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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle10 data guard(dg)__主庫添刪表空間及資料檔案相關測試Oracle
- 【DG】Data Guard主備庫Switchover切換
- rman執行與控制檔案損壞_loss_小測試
- oracle10g data guard(dg)__主庫重新命名資料檔案_在備庫上同步重新命名資料檔案Oracle
- 【DG】Data Guard主備庫Failove切換AI
- Oracle Data Guard 主庫歸檔檔案刪除策略Oracle
- Oracle Data Guard 主庫 歸檔檔案 刪除策略Oracle
- Oracle Data Guard 主庫 歸檔檔案 刪除策略--續Oracle
- 【轉載】Oracle Data Guard 主庫 歸檔檔案 刪除策略Oracle
- DATA GUARD主庫丟失資料檔案的恢復(2)
- DATA GUARD主庫丟失資料檔案的恢復(3)
- DATA GUARD主庫丟失資料檔案的恢復(1)
- Data Guard主備庫切換
- 關於資料庫丟失控制檔案的測試資料庫
- oracle10g data guard(dg)__flashback_physical databaseOracleDatabase
- 使用DG庫資料檔案建開發測試庫步驟
- oracle10g data guard 主備資料庫配置引數說明Oracle資料庫
- Oracle Data Guard主庫備庫角色切換(Switchovers)Oracle
- 與oracle10g data guard(dg)緊密關聯的相關檢視Oracle
- Data Guard 主庫建立表空間,備庫MRP無法啟動
- dg主庫建立檔案備庫未同步解決方法
- DG 主庫丟失歸檔
- 邏輯Data Guard主備庫的轉換
- 10g Data Guard physical standby的主備庫角色轉換測試(switchover & failover)AI
- Data Guard交換控制檔案實現主備切換實現步驟
- 重建控制檔案,並且不乾淨的關閉資料庫測試資料庫
- oracle9204(9i)_dg(data guard)_重新命名主庫資料檔案_指南_轉摘官檔Oracle
- 玩轉Data Guard的switchover後切不回主庫
- 【轉載】Oracle Data Guard 備庫 歸檔檔案 刪除指令碼Oracle指令碼
- oracle10g data guard(dg)__歸檔日誌備份刪除相關策略_rman_configureOracle
- 【DG】Data Guard搭建(physical standby)
- oracle10g data guard建立物理standby資料庫的例子Oracle資料庫
- DG備庫手動管理 新增資料檔案
- 【DG】Oracle Data Guard官方直譯Oracle
- [Data Guard]Oracle10g Data Guard學習筆記(一)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(二)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(三)Oracle筆記
- dg中備庫歸檔目錄滿了,導致不能接收主庫歸檔檔案