Rman Tivoli delete error

[oisaya]

I am deleting backups 30 days old with Tivoli TSM. However, I am getting this error. The error has nothing to do with RMAN but tivoli. Does anyone have idea how to correct this within Tivoli?


RMAN-08526: channel ORA_MAINT_SBT_TAPE_1: Tivoli Data Protection for Oracle: ver
sion 2.2.1.0

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at 07/28/2004 03:01:58
ORA-27191: sbtinfo2 returned error
Additional information: 2

[SANJAY_G]

Check 190902.1 on Metalink.

[oisaya]

Tivoli password on the machine is current. We can backup with it except delete old backup. I appreciate any help, I am running out of tape.

Oisaya

[Thomasps]

Make sure that you are pointing to the correct TDPO.OPT file. Please post both backup and delete scripts

[oisaya]

This is part of the script

Backup Sscript

run {
allocate channel t1 type 'sbt_tape' parms
"ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)" ;
allocate channel t2 type 'sbt_tape' parms
"ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)" ;
backup
format 'al_t%t_s%s_p%p'
(archivelog all);
release channel t1;
release channel t2;
}

Delete Script

allocate channel for delete type 'sbt_tape'
parms "ENV=(DSMI_DIR=/usr/tivoli/tsm/client/api/bin64,
DSMI_ORC_CONFIG=/usr/tivoli/tsm/client/ba/bin/dsm.opt.oracle,
DSMO_NODE=Kite01_oracle,
DSMO_AVG_SIZE=1000,
DSMI_LOG=/usr/tivoli/tsm/client/ba/bin)";
change backupset 28475 delete;
change backupset 28476 delete;

[sambavan]

Check to make sure the on the TSM server side, the following had been set to YES

Under the Kite01_oracle client node on the TSM check to see whether you have

Archive Delete Allowed? Yes
Backup Delete Allowed? Yes

If you don't have these set to Yes, then TSM will not allow you to manage the serverside backups. If you want RMAN to manage it, then you would have to set these two parameters to yes and then try, it would work.

Hope this would help you.

Sam

[Axr2]

What are the parms
verexists
verdeleted
retextra
retonly

set to?

They ought to be 1,0,0,0 respectively - if you've managing deleted from RMAN.