[ADSM-L] How do I get TDPO to send controlfiles to SBT_TAPE instead of DISK?
2008-04-10 15:27:12
My DBAs and I are completely baffled. How do I get TDPO to send
controlfiles to SBT_TAPE instead of DISK?
My setup:
TSM server (Enterprise) 5.5 on AIX 5.2.
TDPO 5.4.1 on Solaris 10/SPARC and Oracle 10gR2.
RMAN settings:
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; #
default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 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 DEVICE TYPE 'SBT_TAPE' PARMS '';
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
'/opt/oracle10/product/10.2.0/db_1/dbs/snapcf_mydb.f'; # default
How we backup -- RMAN commands:
allocate channel t1 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel t2 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel t3 type 'SBT_TAPE' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system archive log current';
backup incremental level = ${LEVEL}
filesperset 5
format "df_%d_%s_%p_%t.lv${LEVEL}"
(database include current controlfile);
backup
filesperset 20
format "ar_%d_%s_%p_%t.lv${LEVEL}"
(archivelog all delete all input);
release channel t1;
release channel t2;
release channel t3;
tdpo.conf for the restore on a test box:
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /var/log/tsm
TDPO_FS prod-oracle
TDPO_MGMT_CLASS_2 tsmoracle-mgmt2
TDPO_MGMT_CLASS_3 tsmoracle-mgmt3
TDPO_MGMT_CLASS_4 tsmoracle-mgmt4
Not a fancy setup; pretty much 'stock' (standard). Thoughts/ideas?
-Dan
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] How do I get TDPO to send controlfiles to SBT_TAPE instead of DISK?,
Dan Foster <=
|
|
|