I am just posting the thing i have learned today while cloning the DB from Hotbackup
We had a Hotbackup which is a USER-MANAGED Backup from the production
The Database files were residing in E:drive and log files/Controlfile were placed D:Drive and E:Drive
We copied the Archived log generated after the backup was complted
I cloned in a different machine in E:Drive but i didnt had the D:Drive where the logfiles and controlfile members are.
3 log grouls
redo11.log(E:Drive)
redo12.log(E:Drive)
redo13.log(D:Drive)
control3.ctl(D:Drive)
The set is like this for all three groups
Now i started recovering from the hotbackup.
I started and mounted the Database
Since there is no D:Drive i had to drop the members in D:Drive
I dropped the Group1 memeber and Group 2 Member but when i tried to drop the group 3 memeber Oracle didnt allow to drop the group 3 memeber
So i decided to a recovery using abckup controlfile until cancel option
It was prompting the Archive log and i have successfully completed the Incomplete Media Recovery
now i try to open with Alter database open resetlogs
Since resetings the logs creating the redologs it tried to create the Group 3 member in D:Drive
I tried to clear the D:Drive log memeber but couldnt it
i treid clearing UNARCHINING option still of no use
Suddenly it thought of renaming the D:Drive log memeber to E:Drive and did successfuly
now i tried to open the resetlogs option
It opened.
Regards
Maran
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment