Rman Tivoli delete error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Rman Tivoli delete error

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    42

    Question 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

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  3. #3
    Join Date
    Oct 2000
    Posts
    42
    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

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Make sure that you are pointing to the correct TDPO.OPT file. Please post both backup and delete scripts
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Oct 2000
    Posts
    42
    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;

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  7. #7
    Join Date
    Oct 2002
    Posts
    807
    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
  •  


Click Here to Expand Forum to Full Width