RMAN - backing up to FRA and some other location
591357Jun 4 2009 — edited Jun 10 2009Hello 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