ADSM-L

[ADSM-L] How do I get TDPO to send controlfiles to SBT_TAPE instead of DISK?

2008-04-10 15:27:12
Subject: [ADSM-L] How do I get TDPO to send controlfiles to SBT_TAPE instead of DISK?
From: Dan Foster <tronic183 AT EVILPHB DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 10 Apr 2008 15:26:05 -0400
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>