Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore from Level 0/Level 1 backups.

DBA112Mar 19 2017 — edited Mar 19 2017

Dear Friends,

DB version - 11.2.0.4.

Question on how to restore these backups :

I have taken a Hot Level 0 Incremental backup at 5 pm, backup finished at 6 pm. At 8 PM a level 1 INCR backup was taken that finished at 8:15PM.

Control file was backed up with both Level 0 and Level 1. So, there are 2 control file backups.

Now, I want to restore my Database until 8:15PM. Now, which control file do I need to restore that will identify both Level 0 and Level 1 backups to be restored properly.

This is Disk based backup and no archive log backups were run b/w Level 0 and Level 1.

Thanks.

Message was edited by: DBA112

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2017

Added on Mar 19 2017

#performance-availability, #recovery-manager-rman

8 comments

2,607 views