DB Restore from a backup and offline redo log file

[pikakala_sebastian]

Hi Gurus,

I am in the process of restoring a DB backup from ABC to XYZ. The objective is to have a point in time recovery with the backup and the oraarchive logs.

1. I have a complete backup from 4th May on ABC

2. I have the all the redo logs generated since the backup till May 5th 16:00:00.

3. I started the restore of the backup in XYZ.

I want to know how can i restore the XYZ till May 5th 16:00:00

Regards,

Paul

[pikakala_sebastian · Accepted solution]

Hi, Here is what i am gonna do..

1. Once the restore is finished I will copy the oraarch's to the XYZ oraarch folder.

2. I will generate Control file.

3. RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL TIME'2016-05-05:16:00:00';

If someone has other views lemme know

Regards,

Paul