RE: Use RMAN to backup the FRA?

Thanks,
So you recommend a separate backup schedule to come along and scoop up the FRA? I can manually setup a job to do this in OEM although I'm disappointed the option is not directly found there. Seems like it should be a common thing for anyone backing up to the FRA.

Can I setup a retention policy on the "backup recovery area" directive? How would I manage these backups?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: November 12, 2016 12:09 AM
To: oracle-l_at_freelists.org
Subject: 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-recove
> ry-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


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