Re: rman configuration

Correct me if I'm wrong. I thought the snapshot controlfile was a temporary file/structure used for resyncing the controlfile from the catalog and is not used during the actual backup and not needed for restore/recovery.

On Fri, Jun 6, 2008 at 1:10 PM, Joe Smith <joe_dba_at_hotmail.com> wrote:

> Is it normal or best practice to snapshot the control file to disk even if
> the backup is going to tape?
>
> The rman closed backup runs to tape with no problem , but I noticed
> that the snapshot of the control file goes to disk. Is this because it
> could not read it from tape?
>
> Or should I reconfigure and state:
>
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'SBT_TAPE';
>
>
>
>
> RMAN configuration parameters are:
>
> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
> CONFIGURE BACKUP OPTIMIZATION OFF; # default
> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO
> 'control_%F';
> configuration for SBT_TAPE channel 3 is ignored
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; #
> default
> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
> CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; #
> default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
> CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS
> 'ENV=(TDPO_OPTFILE=/../tdpo.opt)' FORMAT 'bu.d%d.t%t.s%s.p%p' MAXPIECESIZE
> 2 G;
> CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS
> 'ENV=(TDPO_OPTFILE=/../tdpo.opt)' FORMAT 'bu.d%d.t%t.s%s.p%p' MAXPIECESIZE
> 2 G;
> CONFIGURE CHANNEL 3 DEVICE TYPE 'SBT_TAPE' PARMS
> 'ENV=(TDPO_OPTFILE=/../tdpo.opt)' FORMAT 'bu.d%d.t%t.s%s.p%p' MAXPIECESIZE
> 2 G;
> CONFIGURE MAXSETSIZE TO UNLIMITED; # default
> CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
> CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$ORACLE_HOME/dbs/snapcf_orcl.f'; #
> default
>
>
> ------------------------------
> Enjoy 5 GB of free, password-protected online storage. Get Windows Live
> SkyDrive.<http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008>
>

-- 
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
Last.fm: http://www.last.fm/user/piontekdd/

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