rman configuration
Date: Fri, 6 Jun 2008 13:10:11 -0500
Message-ID: <BLU108-W5400D9DB60E17C4C9163BA97B70@phx.gbl>
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; # defaultCONFIGURE 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 ignoredCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE 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; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '$ORACLE_HOME/dbs/snapcf_orcl.f'; # default
Enjoy 5 GB of free, password-protected online storage. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_062008
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 06 2008 - 13:10:11 CDT