Skip to Main Content

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 incremental backup logic understanding

DLozitskiy.aspMay 18 2016 — edited May 23 2016

I was thinking about logic of RMAN when doing incremental backups and not quite sure if I understand it right.

1) When doing "backup incremental level 0 database plus archivelog delete all input", I understand that RMAN takes Level 0 backup of the database + all archive logs that were generated during the backup + all archive logs that were generated before backup.

2) If I do then "backup incremental level 1 database plus archivelog delete all input" after level 0 was done, RMAN will take all changes to data files since L0 + all archive logs that were generated during the backup + all archive logs that were generated before backup but after L0.

The question here is about efficiency of these two approaches, do RMAN really need to take and keep "all archive logs that were generated before backup" in 1) case and "all archive logs that were generated before backup but after last L0" in 2) case? In my understanding this changes were already be presented as part of data files backup.

Could someone shed a light on this please.

Thanks

This post has been answered by Hemant K Chitale on May 18 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2016
Added on May 18 2016
4 comments
1,303 views