|
-
Check out the foll:-
1. You cannot create controlfiles at mount stage. Your DB has to be in nomount stage.
2. Before you attempt anything, backup all your files just in case something goes wrong. This is very important.
Now for the recovery part -
1. If multiple copies of controlfiles, you can simply copy your 2nd controlfile to your 1st controlfile directory and rename it. (do this while your db is shutdown.)
2. IF you have an old copy of your controlfile then
startup mount pfile ....
alter database recover using backup controlfile.
3. Another option will be to recreate it.
startup nomount pfile...
run your create controlfile sql here.
Check out your alert logs .
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|