| recovery from loss of control files [message #330934] |
Tue, 01 July 2008 18:07  |
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 #330940 is a reply to message #330939] |
Tue, 01 July 2008 19:09  |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
