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_at_labor.state.ny.us 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_at_comcast.net [mailto:ryan_gaffuri_at_comcast.net]
> Sent: Wednesday, December 22, 2004 2:05 PM
> To: shrekdba_at_gmail.com; fuadar_at_yahoo.com
> Cc: Shrek; oracle-l_at_freelists.org
> 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