-
Rman Tivoli delete error
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
-
Check 190902.1 on Metalink.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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
-
Make sure that you are pointing to the correct TDPO.OPT file. Please post both backup and delete scripts
-
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;
-
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
Thanx
Sam
Life is a journey, not a destination!
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|