Re: Why I don't like RMAN repositories

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Wed, 11 Dec 2013 20:20:19 +1100
Message-ID: <52A82E53.7040906_at_iinet.net.au>



On 11/12/2013 7:25 AM, Rich Jesse wrote:

> I was just thinking the same thing. My RMAN backups are to the FRA
> on disk, which are then picked up by "tape" (Tivoli) nightly. For
> the new production box, Tivoli will be picking up the FRA additions
> (arch logs) a few times during the day as well.

Same here. Arch logs into fra every 2nd hour for large change volume dbs. otherwise twice a day.
And no catalog anywhere.

>
> RMAN is configured with a recovery window of 1 day. Our Tivoli tapes
> get shipped offsite daily, leaving the disk cache for short-term
> recovery.

Again, same. Except for a db where I use the SAN-based asynch replication of the FRA to get it quickly into our DR site, where I can mount a snapshot of it in development and do refreshes of a 4TB DW acceptance environment in less than 4 hours.

> "The Plan" has been to manually restore from Tivoli back to the FRA
on disk,
> catalog the restored files, then restore/recover from RMAN. Perhaps a
> little more manual work, but it works well for us.

For us restoring the backups of controlfiles is all that's needed in most cases.
Only every once in a while do I need additional re-cataloging.

-- 
Cheers
Nuno Souto
dbvision_at_iinet.net.au


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 11 2013 - 10:20:19 CET

Original text of this message