Re: Getting started with RMAN
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: jwilton@xxxxxxxxxxxxx, janine@xxxxxxxxxx
- Date: Tue, 4 May 2010 20:21:13 -0700 (PDT)
And a fine job you did on that chapter too Jeremiah!!
Robert
Robert G. Freeman
Master Principal Consultant, Oracle Corporation
Oracle ACE
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
________________________________
From: Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
To: janine@xxxxxxxxxx
Cc: oracle-l L <oracle-l@xxxxxxxxxxxxx>
Sent: Tue, May 4, 2010 3:56:53 PM
Subject: Re: Getting started with RMAN
On May 4, 2010, at 2:41 PM, Janine Sisk wrote:
> I just took a quick look at Oracle's Backup and Recovery doc to see what I
> would be getting myself into in using RMAN. Since this is an Amazon EC2
> instance, there's no tape drive and my only choice is to back up to "disk"
> (really an EBS volume created for this purpose).
Janine,
Is there a reason you don't want to use Oracle's OSB Cloud MML for RMAN to back
up to S3? That's pretty much the standard way to back up Oracle on EC2. If you
can't afford the license for that, I would go with hot backup mode plus EBS
snapshots to S3. Simply backing up to an EBS volume in the same availability
zone seems like too little protection for my taste.
On EC2, I use one EBS volume as a flash (fast??) recovery area (FRA) for RMAN
disk backups of the database and also as my local archivelog destination. I
then use RMAN's "backup recovery area" to S3 with backup optimization using the
OSB Cloud MML.
If the retention configuration is set correctly, you never have to write
archivelog management scripts or manually delete anything. When the FRA
reaches 100% full, as long as it satisfies retention parameters, Oracle removes
the oldest items in the FRA to make room for incoming archivelogs/backups. It
is very hands-off.
> So... what's your favorite book/website/other resource on configuring RMAN
> for the first time?
Oracle Press just came out with "Oracle RMAN 11g Backup and Recovery" (
http://amzn.to/cn8LyoI ). I guess I am supposed to steer you towards that since
I wrote the chapter on backing up to Amazon S3. OTOH, the Oracle documentation
is pretty decent too.
Regards,
Jeremiah Wilton
Blue Gecko, Inc.
http://www.bluegecko.net
--
//www.freelists.org/webpage/oracle-l
Other related posts:
