Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Controlfile has corrupted and not able to open up the database. Very urgent

880047Sep 13 2011 — edited Sep 13 2011
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 13 2011
8 comments
2,919 views