There is no back up of database and it is in NOARCHIVELOG mode.
Please note that the database is still up and we are getting errors while querying some objects like V$LOGFILE as follows:
ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/bt/mts/home2/oradata2/mts/control03.ctl'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
To recover from the deleted control file, you need to do the following:
Shut down the database (not abort).
Copy one of the control files to the missing version OR remove it from the control file.
Start the database.
This may actually recreate the missing log file. If it does not, you can do this to recreate the missing file:
Shut down the database (not abort).
startup mount
alter database open resetlogs;
That should recreate the missing files.
No comments:
Post a Comment