3 Replies Latest reply: Dec 5, 2012 1:34 PM by mseberg RSS

    "RMAN-20000: abnormal termination of job step" on delete obsolete operation

    685605
      Hi all,

      I'm having problems to delete obsoletes backups in a target 9.2.0.8.
      I get error only when i execute a delete obsolete using a device type sbt_tape (I use TSM as media manager). If i execute a delete obsolete through a device type disk, it work fine.

      Below, rman error:

      RMAN> allocate channel for maintenance device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_pira.opt)';

      allocated channel: ORA_MAINT_SBT_TAPE_1
      channel ORA_MAINT_SBT_TAPE_1: sid=72 devtype=SBT_TAPE
      channel ORA_MAINT_SBT_TAPE_1: Data Protection for Oracle: version 5.5.1.0

      RMAN> delete obsolete device type 'sbt_tape';

      RMAN retention policy will be applied to the command
      RMAN retention policy is set to redundancy 2
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of delete command at 12/05/2012 15:07:26

      Using device type disk:

      RMAN> delete obsolete device type disk;

      RMAN retention policy will be applied to the command
      RMAN retention policy is set to redundancy 2
      no obsolete backups found

      I enabled debug and got this stack trace:

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of delete command at 12/05/2012 15:38:05
      RMAN-06004: ORACLE error from recovery catalog database: RMAN-20000: abnormal termination of job step
      RMAN-06097: text of failing SQL statement: declare allCopies boolean ; begin if ( :allCopies > 0 ) then allCopies := TRUE ; else allCopies := FALSE ; end if ; :rc := dbms_rcvman . computeRecoveryActions ( fno => :fno , crescn => :crescn , df_rlgscn => :rlgscn:rlgscn_i , df_rlgtime => :rlgtime:rlgtime_i , df_ckpscn => :ckpscn:ckpscn_i , offlscn => :offlscn , onlscn => :onlscn , onltime => :onltime , cleanscn => :cleanscn , clean2scn => :clean2scn , clean2time => :clean2time , allowfuzzy => FALSE , partial_rcv => FALSE , cf_scn => :cfscn:cfscn_i , cf_c
      RMAN-06099: error occurred in source file: krmk.pc, line: 24880

      Catalog version: 11.2.0.2.0
      Target version: 9.2.0.8.0
      OS: AIX 5.3.0.0

      Thanks
        • 1. Re: "RMAN-20000: abnormal termination of job step" on delete obsolete operation
          mseberg
          Hello;

          I think you need both channels

          This

          allocate channel for maintenance type disk;

          and what you have already.

          RMAN-06099 is a generic error. I'm think the channel is not it, some sort of version conflict between the RMAN packages and the target database is more likely.

          Best Regards

          mseberg
          • 2. Re: "RMAN-20000: abnormal termination of job step" on delete obsolete operation
            685605
            Hi mseberg,

            I did, but i got same error:

            RMAN> allocate channel for maintenance type disk;

            allocated channel: ORA_MAINT_DISK_1
            channel ORA_MAINT_DISK_1: sid=53 devtype=DISK

            RMAN> allocate channel for maintenance device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_pira.opt)';

            allocated channel: ORA_MAINT_SBT_TAPE_2
            channel ORA_MAINT_SBT_TAPE_2: sid=143 devtype=SBT_TAPE
            channel ORA_MAINT_SBT_TAPE_2: Data Protection for Oracle: version 5.5.1.0

            RMAN> delete noprompt obsolete;

            RMAN retention policy will be applied to the command
            RMAN retention policy is set to redundancy 2
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of delete command at 12/05/2012 17:22:44
            • 3. Re: "RMAN-20000: abnormal termination of job step" on delete obsolete operation
              mseberg
              Hello again;

              I'm think the channel is not it, some sort of version conflict between the RMAN packages and the target database is more likely.

              I would probably ask Oracle support for help resolving.

              Best Regards

              mseberg