Home » RDBMS Server » Backup & Recovery » recovery from loss of control files (solaris 10 oracle 10.2.0.3)
recovery from loss of control files [message #330934] Tue, 01 July 2008 18:07 Go to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Experts,

i have a problem. one of our DBA renamed the control file of the database. it was happed at 2 hour ago. we are getting problem with our database.

how do i recover it. can any one provide some information.
we have hot backup and archives.

NOLOG:SYSTEM> alter database backup controlfile to trace;
alter database backup controlfile to trace
*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-00202: control file:
'/opt/mis2/oracle/data/BMVZWINT/db1/data/BMVZWINT/BMVZWINT_control01.dbf'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
Re: recovery from loss of control files [message #330936 is a reply to message #330934] Tue, 01 July 2008 18:18 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SQL> SHUTDOWN ABORT

then copy one of the remaining control files to /opt/mis2/oracle/data/BMVZWINT/db1/data/BMVZWINT/BMVZWINT_control01.dbf
Re: recovery from loss of control files [message #330937 is a reply to message #330936] Tue, 01 July 2008 18:35 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
thanks for reply,

he renamed all control files. what i am doing is

i am recreating the control file. is it works for me?
Re: recovery from loss of control files [message #330939 is a reply to message #330934] Tue, 01 July 2008 18:40 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>he renamed all control files. what i am doing is
Does he still have a job?
If the files were just renamed, then rename them back to original name.

>i am recreating the control file. is it works for me?
You will soon learn the answer to that question.
Re: recovery from loss of control files [message #330940 is a reply to message #330939] Tue, 01 July 2008 19:09 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
Thanks for reply.

what i am thinking is to go for recovery.
steps are:

restore backup and control file from most recent bakcup.
recover database using backup controlfile until cancel ;

so it will apply all the archives.

alter database open reset logs;

--- i am not clear on one question.
if i loss control file in my DB, is there any transaction will happened. is it possible to insert/select/update transaction will happen against the DB. i guess it won't happend.

in that case i will go for recreation of control file.
otherwise i will perform recovery.

is this way is correct. could you please tell am i thinking is wrong?

Re: recovery from loss of control files [message #330941 is a reply to message #330934] Tue, 01 July 2008 19:56 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>restore backup and control file from most recent bakcup.
How was this backup taken?

The first thing you should do is take a complete cold backup.

[Updated on: Tue, 01 July 2008 19:57] by Moderator

Report message to a moderator

Previous Topic: Disaster Recovery Site
Next Topic: how to recover the database from this errorsORA-00313 ORA-00312 ORA-27046 OSD-04012
Goto Forum:
  


Current Time: Sat Dec 10 00:59:46 CST 2016

Total time taken to generate the page: 0.07025 seconds