Re: rman configuration
Date: Fri, 6 Jun 2008 14:04:19 -0700 (PDT)
Message-ID: <128645.14207.qm@web38904.mail.mud.yahoo.com>
You are correct. People often get confused about what the snapshot control file is for. I've never seen it created on tape... not even sure thats supported.
RF
Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
The LDS Church is looking for DBA's. You must be LDS to apply (please don't write to me and tell me I'm breaking the law. A church can choose to hire members of it's own faith. Look it up if you don't believe me).
- Original Message ---- From: Bradd Piontek <piontekdd_at_gmail.com> To: joe_dba_at_hotmail.com Cc: oracle-l_at_freelists.org Sent: Friday, June 6, 2008 12:25:19 PM Subject: 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.
--
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
Received on Fri Jun 06 2008 - 16:04:19 CDT