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!

Archive Log vs Full Backup Concept

898250Nov 5 2011 — edited Nov 7 2011

Hi,

I just need some clarification on how backups and archive logs work. Lets say starting at 1PM I have archive logs 1,2,3,4,5 and then I perform a full backup at 6PM.

Then I resume generating archive logs at 6PM to get logs 6,7,8,9,10. I then stop at 11PM.

If my understanding is correct, the archive logs should allow me to restore oracle to a point in time anywhere between 1PM and 11PM. But if I only have the full backup then I can only restore to a single point, which is 6PM. Is my understanding correct?

Do the archive logs only get applied to the datafiles when the backup occurs or only when a restore occurs? It doesn't seem like the archive logs get applied on the fly.

Thanks in advance.

This post has been answered by Levi Pereira on Nov 6 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2011

Added on Nov 5 2011

#performance-availability, #recovery-manager-rman

4 comments

773 views