Re: Getting started with RMAN

  • From: Jeremiah Wilton <jwilton@xxxxxxxxxxxxx>
  • To: janine@xxxxxxxxxx
  • Date: Tue, 4 May 2010 14:56:53 -0700

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: