oracle10g data guard(dg)_主庫控制檔案受損或loss_自動關庫測試

wisdomone1發表於2010-01-30
********************* 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,供後記

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-626459/,如需轉載,請註明出處,否則將追究法律責任。

相關文章