Skip to Main Content
Forums

Oracle Database Discussions

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!

How often should I backup archivelogs with RMAN?

836962Apr 4 2011 — edited Apr 6 2011
I inherited a situation where "backup archivelog" is being run in RMAN every hour on our database. Right now, there are only 3 times a day when there are more than one archivelog per hour.

I can't decide if:

A. This is an easy way to ensure that the database can be recovered to within an hour without playing with the redo log sizes or checkpoints.

B. This is complete overkill and I should just backup the archivelogs with the nightly full database backups.

Any thoughts?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2011
Added on Apr 4 2011
#backup, #general-database-discussions, #rman
10 comments
3,668 views