|
-
well in case of emergency i wud have tried as follows:
Since i dont have an spfile.So first create one and give the path of controlfiles as controlfiles will be opend in the mount stage. Then wud have checked whether the datafiles have been restored to the correct location. iF i m going to restore them to a diff location, then wud have registered this change in the controlfile using rename command.
if clean shutdown is made, then no recovery is reqd.
but i wont be able to open the database as i dont have redologs that r registered in the controfile i.e log sequence number.
so, recover database until cancel n open using resetlogs.
do check tnsnames.ora and set oracle_sid.
may be there r other things to consider as well.
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
|