Re: rman backups using bcv

Look at a backup strategy from the standpoint of recovery scenarios.  How
many recovery scenarios can BCV/pair-splitting/mirror-splits/whatever
handle?

    1. Full database restore and recovery (be careful about restoring
       those control files!)
    2. um......

OK, so it's a little limited on recovery scenarios, unless you want to count
using OS copy commands to copy individual files back for restoral.

RMAN can still be used to backup those split-off BCVs:

    1. Put all tablespaces into BEGIN BACKUP mode
    2. Call pair-split command, create BCVs
    3. Perform END BACKUP on all tablespaces
    4. In RMAN, perform a CATALOG DATAFILECOPY command for each file in BCV
    5. In RMAN, perform BACKUP DATAFILECOPY for each file in BCV to tape

RMAN can then use whatever "copy" is nearest for restoral -- either the
on-disk BCV datafile copy or the backed-up file copy on tape.   You get a
catalog of backup actions (i.e. RMAN repository) from which you can report
and analyze, you get RMAN checking for corrupted blocks, you get all of the
automated functionality of RMAN like DUPLICATE TARGET DATABASE, RESTORE
STANDBY, etc...




on 12/22/04 12:21 PM, Mercadante, Thomas F at
thomas.mercadante@xxxxxxxxxxxxxxxxx wrote:

> I'm not sure what the purpose is for performing an Rman backup after the bcv
> split.  You can recreate this database in about a minute.  So why back it
> up?
> 
> I would be doing Rman backups of the source database and consider this (the
> reporting) database expendable.
> 
> -----Original Message-----
> From: ryan_gaffuri@xxxxxxxxxxx [mailto:ryan_gaffuri@xxxxxxxxxxx]
> Sent: Wednesday, December 22, 2004 2:05 PM
> To: shrekdba@xxxxxxxxx; fuadar@xxxxxxxxx
> Cc: Shrek; oracle-l@xxxxxxxxxxxxx
> Subject: Re: rman backups using bcv
> 
> how time consuming is it to resynch the bcvs? how out of synch do you allow
> them to get? I know this is vague...
> i would think the best way to be super anal dba would be to have your
> typical rman online backups plus use the bcv mirrors and offline those.
> 
> looking for comments, advice, etc...
> 
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
> 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: