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 - backing up to FRA and some other location

591357Jun 4 2009 — edited Jun 10 2009
Hello everyone,

I would like to configure RMAN so it would create two copies of backupset...
One into Flash Recovery Area (keeping the nice FRA directory structure, i.e. F:\ora_fra\db_name\backupset\<filename>) and one to some custom area (lets say I:\ora_bck\<filename>).

I tried following:
RMAN> backup copies 2 database format 'F:\ora_flash\%U', 'I:\ora_bck\%U';
But this resulted into creating a file directly in F:\ora_flash (not following the FRA directory structure, therefore I'm not really sure whether this file is or is not included in FRA)

If I do the following:
RMAN> backup database;
RMAN> run {
2> set backup copies = 2;
3> backup backupset completed between 'sysdate-1' and 'sysdate' format 'I:\ora_bck\%U';
4> }
It does what I expect from it (one copy nicely in FRA, second on I:), but even I can smell this is a terrible solution.

Any ideas? (The requirement is to perform full DB backup once in a while time to 2 locations - FRA and disk I:)

Thanks.
Adam
This post has been answered by ebrian on Jun 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2009
Added on Jun 4 2009
14 comments
2,438 views