Veritas-bu

[Veritas-bu] Incremental RMAN backups on split BCV's

2003-01-21 17:38:08
Subject: [Veritas-bu] Incremental RMAN backups on split BCV's
From: ddunham AT taos DOT com (Darren Dunham)
Date: Tue, 21 Jan 2003 14:38:08 -0800 (PST)
> 
> The problem is that anticipated growth will make this difficult in the
> future - we won't be able to move enough data in the necessary
> timespan.

Can I ask what the bottleneck will be?  I would think that the
BCV/filesystem backup would have higher throughput than an RMAN backup.

> Therefore, we're looking at using Oracle RMAN to perform database
> incrementals.  However, I'm still wanting to perform the backup off-host so
> the idea is to use RMAN to backup BCV's mounted on my media server.
> 
> The idea is this, and I'm looking for proponents or detractors to this idea:
> 
> 1. split & import as above to our media server
> 2. Open the database on the media server
> 3. perform the RMAN full and/or incremental as necessary
> 4. shutdown the Oracle instance
> 5. incrementally re-establish.
> 6. rinse & repeat the next night
> 
> The thought is that since the instance on the media server is opened &
> closed normally and since the BCV should be a blockwise identical copy of
> the original database, then RMAN doesn't know from run-to-run that this is a
> "new" copy of the DB.  As far as RMAN is concerned, the only DB involved
> lives exclusively on the media server - it doesn't have to know about the
> original mounted on the main server.

Sounds workable to me, but I'd want to test the restore.  Do you have to
have the other machine involved, or could you restore directly to the
main server?

-- 
Darren Dunham                                           ddunham AT taos DOT com
Unix System Administrator                    Taos - The SysAdmin Company
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >