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!

Lost control file, how to recover them

600544Apr 25 2011 — edited Apr 25 2011
Hi All,

I have Oracle 11G running on RHEL 5.2 server and unexpectedly I can't start database after a server reboot. I have executed the following commands,

sqlplus /as sysdba
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/inittestdb.ora'
SQL>

and then


SQL> startup pfile='/u01/app/oracle/admin/testdb/pfile/init.ora.1024201018143'
ORACLE instance started.

Total System Global Area 1269366784 bytes
Fixed Size 2212976 bytes
Variable Size 754977680 bytes
Database Buffers 503316480 bytes
Redo Buffers 8859648 bytes
ORA-00205: error in identifying control file, check alert log for more info

Here are the alert log messages,

ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/testdb/control02.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/testdb/control01.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE MOUNT...


[oracle@trace]$ ls -l /u01/app/oracle/oradata/testdb
total 0

There are are no control files in the directory and I couldn't find them on the disk. Unfortunately, I do not have backups for dbs (this is a staging server). Is there any way we can recover those files or fix the problem ?

Could someone please help us on this?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2011
Added on Apr 25 2011
10 comments
2,086 views