Controlfile has corrupted and not able to open up the database. Very urgent
880047Sep 13 2011 — edited Sep 13 2011Hi All,
I am working on 11gR1 database on linux environment and suddenly the DB went down. I look at the alert log and i am following that guidelines, but i am not able to put the database in mount state and it is thronging error message. Please suggest me in correct way. This is very high priority for me.
I have done below steps.
1.set the environment through . oraenv
2. export ORACLE_SID
3. SQL>startup nomount
ORACLE instance started.
Total System Global Area 4943876096 bytes
Fixed Size 2143944 bytes
Variable Size 2617248056 bytes
Database Buffers 2281701376 bytes
Redo Buffers 42782720 bytes
SQL>alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/u02/oradata/beacondp/control02.ctl' version 390158 inconsistent with file '/u01/oradata/beacondp/control01.ctl' version 390097
4. SQL>alter system set control_files='/u02/oradata/beacondp/control03.ctl' scope=spfile;
System altered.
SQL>startup restrict
ORA-01081: cannot start already-running ORACLE - shut it down first
5. SQL>alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00214: control file '/u02/oradata/beacondp/control02.ctl' version 390158 inconsistent with file '/u01/oradata/beacondp/control01.ctl' version 390097
alert log Information:
----------------------------
Thread 1 advanced to log sequence 9261
Current log# 3 seq# 9261 mem# 0: /u02/oradata/beacondp/redo03.log
Tue Sep 13 15:00:14 2011
********************* 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.
Please let me know, how i need to proceed. Major problem is i am not able to put the db in mount state. I have both spfile and pfile.
Thanks in advance.