|
-
well I havent tried it but I think in order to recreate a control file we have to shutdown the database with abort option. Then startup nomount and recreate the controlfile, the controlfile at this state doesnt contain stop SCN and any checkpoint information so if we startup straight away the files will need recovery since Oracle does two checks:
1. Oracle compares last checkpoint in both datafile header and control file.
2. Oracle compares the STOP SCN in control file and datafile header.
In the first step Oracle will give us straight away an error message, something like the controlfile is too old or similar and requiere recovery, if we could pass the first step Oracle would do instance recovery but unfortunately I dont think we cant even pass the first check :o
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
|