alert日志应该所有的dba都很熟悉了,不过有多少人见过alert日志中报这个玩意的吗?

Completed checkpoint up to RBA [0×1e4ec.2.10], SCN: 0×0795.503eefc3
Tue Mar 11 01:28:29 2008
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…
WARNING! CONTROLFILE SEQUENCE NUMBER TOO OLD, RE-READING…

********************* 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 = 20705

反正是我第一次见到alert中报这个的,oracle还是很友好的,在alert中已经明确的告诉我们该怎么处理这种情况.



6 Comments to “alter日志见过,见过alert日志报下面的信息的吗?”

1. yumianfeilong — March 11, 2008 @ 11:22 am
   

   10g or 11g?

2. David.Guo — March 11, 2008 @ 11:33 am
   

   不好意思是9i,哈哈 ,看来见过这个的人还真的不多,呵呵

    

3. i love fish — March 11, 2008 @ 2:46 pm
   

   明显是百年一遇，出现的概率和艳照门差不多的！

4. alan — March 13, 2008 @ 12:51 am
   

   很荣幸啊，我是本次奇遇的第一发现人，哈哈哈哈，当时第一反应就是，TMD，这下搞大了

5. 在职研究生 — March 25, 2008 @ 1:00 am
   

   明显是百年一遇，出现的概率和艳照门差不多的！这句话经典，哈哈

6. 小荷 — April 1, 2008 @ 6:29 pm
   

   呵呵，原来三少也遇到了这个报错。。。。^_顺便问一下，你是在什么情况下遇到的？

Write a comment

You need tologin.