Veritas-bu

[Veritas-bu] Backing up Oracle RAC

2006-10-11 08:40:28
Subject: [Veritas-bu] Backing up Oracle RAC
From: jlightner at water.com (Jeff Lightner)
Date: Wed, 11 Oct 2006 08:40:28 -0400
We use RMAN for a backup of a smaller (<300 GB) DB.  It doesn't require
stopping the database.

For a large (>2 TB) Oracle DB we do the BCV thing outlined below.   You
don't have to run Oracle on the media server because you do a standard
rather than an oracle backup.  (E.G. do not use RMAN - just backup the
filesystems or raw devices as if they were any other.)  We also use this
backup to do refreshes of our TEST/DEV/TRAINING environments.

-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of smpt
Sent: Wednesday, October 11, 2006 4:00 AM
To: ida3248b at post.cybercity.dk; 'Nardello, John';
veritas-bu at mailman.eng.auburn.edu
Cc: veritas-bu-bounces at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] Backing up Oracle RAC

You can use more RMAN streams and buffers (10 streams with 256k buffers)

-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of
ida3248b at post.cybercity.dk
Sent: Wednesday, October 11, 2006 10:10 AM
To: Nardello, John; veritas-bu at mailman.eng.auburn.edu
Cc: veritas-bu-bounces at mailman.eng.auburn.edu
Subject: Re: [Veritas-bu] Backing up Oracle RAC

You could do something like this

Put the database in backup mode
split a BCV of
Take the database out of backup mode
Mount the BCV on media server
Run a file backup of the mounted BCV
dismount BCV

Of cause every backup will be a full backup

I assume you have looked into incremental with RMAN

Regards
Michael

On Tue, 10 Oct 2006 14:38:38 -0700, Nardello, John wrote
> Does anyone have some suggestions for backing up larger Oracle RAC
> instances, where across-the-wire backups will not be fast enough to
> complete a backup within the window ? 
> We are _really_ trying to avoid deploying a Media Server with Oracle
> running on it just to mount up BCVs of these databases, but we're not
> sure what other options we actually have.
> 
> Any thoughts ? 
> - John Nardello
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


--
Cybercity Webhosting (http://www.cybercity.dk)

_______________________________________________
Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu



_______________________________________________
Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


<Prev in Thread] Current Thread [Next in Thread>