Support Singapore

Support Singapore YOG 2010

Friday, April 4, 2008

Recovering from Hotbackup

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

No comments: