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 Merge Incremental Backup using ASM FRA?

user59655Oct 28 2008 — edited Nov 4 2008
Hello -

I have a Flash Recovery Area (FRA) that contains Merged incremantal Image copies of my database. I have my online redo logs mirrored on my DATA diskgroup, and also in the FRA? My question is as follows:

Is it a best practice to have the archive log files stored on the DATA diskgroup, or in the FRA? All changes from the arch logs get applied on a nightly basis to the image file copies (from the incremental level 1 merge copy). Therefore, in the event of a failure, I'll only need the arch logs that have accumulated since the last nightly incremental backup. All image copies are written out to tape on a nighly basis. I don't want the arch logs to start taking up two much space, so would only like to have two days worth on disk. What RMAN command would I run to automatically delete the arch logs that are older than 2 days old?

Thanks in advance!
Mike
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2008
Added on Oct 28 2008
4 comments
2,843 views