Re: Use RMAN to backup the FRA?

On 11/11/2016 06:13 PM, William Beldman wrote:
> I've currently setup the Oracle-Suggested Backup job in OEM 12c to backup my database to the fast recovery area.
>
> My ultimate goal is to run backups to the FRA and sweep those backups off to NFS for longer-term storage and for DR protection. I'd also like to stay as vanilla as possible to arrange this.
>
> I see that since 11g, rman now supports backing up the FRA to disk:
> http://gavinsoorma.com/2012/08/rman-11g-new-feature-backup-fast-recovery-area-fra-to-disk/
>
> My question is is it possible to modify the canned rman script provided by OEM such that after the backup to FRA, I can tack on a line like:
> backup recovery area to destination '/nfs-backups/';
>
> If not, how can I best arrange a second pass after the backup to FRA through OEM to do this? If I run a backup of the FRA, how can I manage retention on the NFS side?
> --
> http://www.freelists.org/webpage/oracle-l
>
>

Hi!

Backup of FRA is, essentially, a backup of database or backup of archive logs. This makes sense when FRA is used to maintain a copy of the database, from which it can be recovered really quickly. I blogged about it some time ago:

https://dbwhisperer.wordpress.com/tag/missing-utility/

And the way to do what you want to do is the following:

run {

allocate channel c1 device type disk format '/nfs-backup/fra%U.bak';

backup recovery area;

}

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l