Re: Use RMAN to backup the FRA?

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 12 Nov 2016 00:08:33 -0500

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?
--
//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

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2016