Missing or Corrupt Controlfile

Ever receive the following message when starting an Oracle database?

ORA-00205: error in identifying control file, check alert log for more info

Review the alert log will show which controlfile can’t be accesses.

ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u02/app/oracle/oradata/control01.ctl'
ORA-27048: skgfifi: file header information is invalid
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Mon Apr 26 10:11:23 2010
Checker run found 1 new persistent data failures

ORA-205 signalled during: ALTER DATABASE   MOUNT..

After starting the database check the parameter for a list of the controlfiles

SQL> show parameter control_files

Once you have a list of the controlfiles, copy one of the existing one’s to the missing or corrupt.

SQL > host

[oracle@host ~]$ cp /u02/app/oracle/oradata/control02.ctl /u01/app/oracle/oradata/control01.ctl

[oracle@host ~]$ exit

SQL> alter database  mount;

Database altered.

SQL> alter database open;

Database altered.

Advertisements

Tagged:

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: