| controlfile [message #508322] |
Fri, 20 May 2011 04:47  |
venkatgargeyagmailcom
Messages: 20
Registered: October 2010
Location: hyderabad
|
Junior Member |
|
|
Hi all,
I have a question
i have 3 controlfile in those i lost 2 controlfiles as dba what we do?
is the following process is right?if not give the solution
shut the instance abnormally as shut abort
restore the backup
startup nomount
alter database recover automatic using backup controlfile until cancel;
recover cancel;
alter database open resetlogs;
and one more thing is that
what we need to resote?
the backup of controlfiles which are lost/all the controlfiles/all the database files
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
