6 Replies Latest reply: Feb 12, 2013 7:18 AM by 980096 RSS

    delete backups

    980096
      Hi,

      I have deleted old backups using command 'delete backupset backupset no' ,once deleted the backups, i have given command 'delete obsolete device type disk', it shows deleted backups and i tried to delete those backups once again but it given error no backupset available.

      The below are the steps which are followed.

      RMAN> list backup of archivelog all;


      List of Backup Sets
      ===================


      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      56 515.88M SBT_TAPE 00:00:07 04-FEB-13
      BP Key: 69 Status: AVAILABLE Compressed: NO Tag: TAG20130204T181330
      Handle: NNMMC-ARCH<NNMMC_56:806523210:1>.dbf Media: 60cac40a:50f0005f:3d44:000b

      List of Archived Logs in backup set 56
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 328 8498749 01-FEB-13 8521808 01-FEB-13
      1 329 8521808 01-FEB-13 8549678 02-FEB-13
      1 330 8549678 02-FEB-13 8554038 02-FEB-13
      1 331 8554038 02-FEB-13 8573158 02-FEB-13
      1 332 8573158 02-FEB-13 8601511 02-FEB-13
      1 333 8601511 02-FEB-13 8630322 03-FEB-13
      1 334 8630322 03-FEB-13 8644200 03-FEB-13
      1 335 8644200 03-FEB-13 8652788 03-FEB-13
      1 336 8652788 03-FEB-13 8680670 03-FEB-13
      1 337 8680670 03-FEB-13 8710187 03-FEB-13
      1 338 8710187 03-FEB-13 8736748 04-FEB-13
      1 339 8736748 04-FEB-13 8745980 04-FEB-13
      1 340 8745980 04-FEB-13 8778935 04-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      59 8.00K SBT_TAPE 00:00:00 04-FEB-13
      BP Key: 72 Status: AVAILABLE Compressed: NO Tag: TAG20130204T181404
      Handle: NNMMC-ARCH<NNMMC_59:806523244:1>.dbf Media: 60cac40a:50f0005f:3d44:000b

      List of Archived Logs in backup set 59
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 341 8778935 04-FEB-13 8778975 04-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      61 326.57M SBT_TAPE 00:00:03 06-FEB-13
      BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20130206T155826
      Handle: NNMMC-ARCH<NNMMC_61:806687906:1>.dbf Media: 60cac40a:50f0005f:3d44:000b

      List of Archived Logs in backup set 61
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 342 8778975 04-FEB-13 8796750 04-FEB-13
      1 343 8796750 04-FEB-13 8825222 05-FEB-13
      1 344 8825222 05-FEB-13 8829341 05-FEB-13
      1 345 8829341 05-FEB-13 8868334 05-FEB-13
      1 346 8868334 05-FEB-13 8885479 05-FEB-13
      1 347 8885479 05-FEB-13 8912728 06-FEB-13
      1 348 8912728 06-FEB-13 8916458 06-FEB-13
      1 349 8916458 06-FEB-13 8949495 06-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      64 10.00K SBT_TAPE 00:00:00 06-FEB-13
      BP Key: 77 Status: AVAILABLE Compressed: NO Tag: TAG20130206T155856
      Handle: NNMMC-ARCH<NNMMC_64:806687937:1>.dbf Media: 60cac40a:50f0005f:3d44:000b

      List of Archived Logs in backup set 64
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 350 8949495 06-FEB-13 8949538 06-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      68 82.00M SBT_TAPE 00:00:10 07-FEB-13
      BP Key: 68 Status: AVAILABLE Compressed: NO Tag: TAG20130207T160336
      Handle: NNMMC-ARCH<NNMMC_68:806774617:1>.dbf Media: 60cac40a:50f0005f:3d44:000b

      List of Archived Logs in backup set 68
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 351 8949538 06-FEB-13 8971496 06-FEB-13
      1 352 8971496 06-FEB-13 9003118 07-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      70 107.25M SBT_TAPE 00:00:11 07-FEB-13
      BP Key: 80 Status: AVAILABLE Compressed: NO Tag: TAG20130207T160951
      Handle: NNMMC-ARCH<NNMMC_70:806774991:1>.dbf Media: 60cac40a:50f0005f:3d44:000b

      List of Archived Logs in backup set 70
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 351 8949538 06-FEB-13 8971496 06-FEB-13
      1 352 8971496 06-FEB-13 9003118 07-FEB-13
      1 353 9003118 07-FEB-13 9031235 07-FEB-13
      1 354 9031235 07-FEB-13 9031243 07-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      73 6.14M SBT_TAPE 00:00:00 07-FEB-13
      BP Key: 96 Status: AVAILABLE Compressed: NO Tag: TAG20130207T180754
      Handle: TEST-NNMMC<NNMMC_73:806782074:1>.dbf Media: 60cac40a:50efffc4:3d44:000a

      List of Archived Logs in backup set 73
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 355 9031243 07-FEB-13 9037620 07-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      76 6.50K SBT_TAPE 00:00:00 07-FEB-13
      BP Key: 99 Status: AVAILABLE Compressed: NO Tag: TAG20130207T180800
      Handle: TEST-NNMMC<NNMMC_76:806782080:1>.dbf Media: 60cac40a:50efffc4:3d44:000a

      List of Archived Logs in backup set 76
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 356 9037620 07-FEB-13 9037648 07-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      78 207.13M SBT_TAPE 00:00:05 08-FEB-13
      BP Key: 101 Status: AVAILABLE Compressed: NO Tag: TAG20130208T172051
      Handle: TEST-NNMMC<NNMMC_78:806865652:1>.dbf Media: 60cac40a:50efffc4:3d44:000a

      List of Archived Logs in backup set 78
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 357 9037648 07-FEB-13 9056380 07-FEB-13
      1 358 9056380 07-FEB-13 9060982 07-FEB-13
      1 359 9060982 07-FEB-13 9064312 07-FEB-13
      1 360 9064312 07-FEB-13 9089221 08-FEB-13
      1 361 9089221 08-FEB-13 9128878 08-FEB-13
      1 362 9128878 08-FEB-13 9131507 08-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      81 106.00K SBT_TAPE 00:00:01 08-FEB-13
      BP Key: 104 Status: AVAILABLE Compressed: NO Tag: TAG20130208T172108
      Handle: TEST-NNMMC<NNMMC_81:806865668:1>.dbf Media: 60cac40a:50efffc4:3d44:000a

      List of Archived Logs in backup set 81
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 363 9131507 08-FEB-13 9131596 08-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      85 319.00M SBT_TAPE 00:03:47 10-FEB-13
      BP Key: 95 Status: AVAILABLE Compressed: NO Tag: TAG20130210T061228
      Handle: TEST-NNMMC<NNMMC_85:806998350:1>.dbf Media: 60cac40a:50efffc4:3d44:000a

      List of Archived Logs in backup set 85
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 364 9131596 08-FEB-13 9152488 08-FEB-13
      1 365 9152488 08-FEB-13 9158160 08-FEB-13
      1 366 9158160 08-FEB-13 9180836 09-FEB-13
      1 367 9180836 09-FEB-13 9194979 09-FEB-13
      1 368 9194979 09-FEB-13 9226435 09-FEB-13
      1 369 9226435 09-FEB-13 9254438 09-FEB-13
      1 370 9254438 09-FEB-13 9259929 09-FEB-13
      1 371 9259929 09-FEB-13 9273292 10-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      87 345.75M SBT_TAPE 00:00:13 10-FEB-13
      BP Key: 107 Status: AVAILABLE Compressed: NO Tag: TAG20130210T062228
      Handle: TEST-NNMMC<NNMMC_87:806998948:1>.dbf Media: 60cac40a:50efffc4:3d44:000a

      List of Archived Logs in backup set 87
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 364 9131596 08-FEB-13 9152488 08-FEB-13
      1 365 9152488 08-FEB-13 9158160 08-FEB-13
      1 366 9158160 08-FEB-13 9180836 09-FEB-13
      1 367 9180836 09-FEB-13 9194979 09-FEB-13
      1 368 9194979 09-FEB-13 9226435 09-FEB-13
      1 369 9226435 09-FEB-13 9254438 09-FEB-13
      1 370 9254438 09-FEB-13 9259929 09-FEB-13
      1 371 9259929 09-FEB-13 9273292 10-FEB-13
      1 372 9273292 10-FEB-13 9295490 10-FEB-13
      1 373 9295490 10-FEB-13 9295498 10-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      92 38.25M SBT_TAPE 00:00:10 10-FEB-13
      BP Key: 112 Status: AVAILABLE Compressed: NO Tag: TAG20130210T141151
      Handle: TEST-NNMMC<NNMMC_92:807027111:1>.dbf Media: 60cac40a:50f001fd:3d44:000d

      List of Archived Logs in backup set 92
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 374 9295498 10-FEB-13 9324633 10-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      94 38.50M SBT_TAPE 00:00:10 10-FEB-13
      BP Key: 114 Status: AVAILABLE Compressed: NO Tag: TAG20130210T141222
      Handle: TEST-NNMMC<NNMMC_94:807027142:1>.dbf Media: 60cac40a:50f001fd:3d44:000d

      List of Archived Logs in backup set 94
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 374 9295498 10-FEB-13 9324633 10-FEB-13
      1 375 9324633 10-FEB-13 9324959 10-FEB-13
      1 376 9324959 10-FEB-13 9324967 10-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      97 175.36M DISK 00:00:01 11-FEB-13
      BP Key: 117 Status: AVAILABLE Compressed: NO Tag: TAG20130211T164549
      Piece Name: /usr/ORACLE/NNMOM/NNMMC/backupset/2013_02_11/o1_mf_annnn_TAG20130211T164549_8kknq6b2_.bkp

      List of Archived Logs in backup set 97
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 377 9324967 10-FEB-13 9349331 10-FEB-13
      1 378 9349331 10-FEB-13 9358136 10-FEB-13
      1 379 9358136 10-FEB-13 9366358 10-FEB-13
      1 380 9366358 10-FEB-13 9406215 11-FEB-13
      1 381 9406215 11-FEB-13 9428339 11-FEB-13

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      100 17.00K DISK 00:00:00 11-FEB-13
      BP Key: 120 Status: AVAILABLE Compressed: NO Tag: TAG20130211T164630
      Piece Name: /usr/ORACLE/NNMOM/NNMMC/backupset/2013_02_11/o1_mf_annnn_TAG20130211T164630_8kknrgc9_.bkp

      List of Archived Logs in backup set 100
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 382 9428339 11-FEB-13 9428395 11-FEB-13


      RMAN > delete obsolete;

      RMAN retention policy will be applied to the command
      RMAN retention policy is set to redundancy 1
      using channel ORA_DISK_1
      Deleting the following obsolete backups and copies:
      Type Key Completion Time Filename/Handle
      -------------------- ------ ------------------ --------------------
      Backup Set 56 07-FEB-13
      Backup Piece 69 07-FEB-13 NNMMC-ARCH<NNMMC_56:806523210:1>.dbf
      Backup Set 57 07-FEB-13
      Backup Piece 70 07-FEB-13 NNMMC-ARCH<NNMMC_57:806523218:1>.dbf
      Backup Set 58 07-FEB-13
      Backup Piece 71 07-FEB-13 NNMMC-ARCH<NNMMC_58:806523219:1>.dbf
      Backup Set 59 07-FEB-13
      Backup Piece 72 07-FEB-13 NNMMC-ARCH<NNMMC_59:806523244:1>.dbf
      Backup Set 60 07-FEB-13
      Backup Piece 73 07-FEB-13 c-1374507108-20130204-00
      Backup Set 61 07-FEB-13
      Backup Piece 74 07-FEB-13 NNMMC-ARCH<NNMMC_61:806687906:1>.dbf
      Backup Set 62 07-FEB-13
      Backup Piece 75 07-FEB-13 NNMMC-ARCH<NNMMC_62:806687916:1>.dbf
      Backup Set 63 07-FEB-13
      Backup Piece 76 07-FEB-13 NNMMC-ARCH<NNMMC_63:806687919:1>.dbf
      Backup Set 64 07-FEB-13
      Backup Piece 77 07-FEB-13 NNMMC-ARCH<NNMMC_64:806687937:1>.dbf
      Backup Set 65 07-FEB-13
      Backup Piece 78 07-FEB-13 c-1374507108-20130206-00
      Backup Set 66 07-FEB-13
      Backup Piece 66 07-FEB-13 NNMMC-ARCH<NNMMC_66:806774315:1>.dbf
      Backup Set 67 07-FEB-13
      Backup Piece 67 07-FEB-13 NNMMC-ARCH<NNMMC_67:806774591:1>.dbf
      Backup Set 68 07-FEB-13
      Backup Piece 68 07-FEB-13 NNMMC-ARCH<NNMMC_68:806774617:1>.dbf
      Backup Set 69 07-FEB-13
      Backup Piece 79 07-FEB-13 c-1374507108-20130207-00
      Backup Set 70 07-FEB-13
      Backup Piece 80 07-FEB-13 NNMMC-ARCH<NNMMC_70:806774991:1>.dbf
      Backup Set 71 07-FEB-13
      Backup Piece 81 07-FEB-13 NNMMC-ARCH<NNMMC_71:806775007:1>.dbf
      Control File Copy 1 07-FEB-13 /var/opt/omni/tmp/ctrl_NNMMC_21797.dbf
      Backup Set 72 07-FEB-13
      Backup Piece 82 07-FEB-13 c-1374507108-20130207-01
      Backup Set 73 10-FEB-13
      Backup Piece 96 10-FEB-13 TEST-NNMMC<NNMMC_73:806782074:1>.dbf
      Backup Set 74 10-FEB-13
      Backup Piece 97 10-FEB-13 TEST-NNMMC<NNMMC_74:806782075:1>.dbf
      Backup Set 75 10-FEB-13
      Backup Piece 98 10-FEB-13 TEST-NNMMC<NNMMC_75:806782077:1>.dbf
      Backup Set 76 10-FEB-13
      Backup Piece 99 10-FEB-13 TEST-NNMMC<NNMMC_76:806782080:1>.dbf
      Backup Set 77 10-FEB-13
      Backup Piece 100 10-FEB-13 c-1374507108-20130207-02
      Backup Set 78 10-FEB-13
      Backup Piece 101 10-FEB-13 TEST-NNMMC<NNMMC_78:806865652:1>.dbf
      Backup Set 79 10-FEB-13
      Backup Piece 102 10-FEB-13 TEST-NNMMC<NNMMC_79:806865660:1>.dbf
      Backup Set 80 10-FEB-13
      Backup Piece 103 10-FEB-13 TEST-NNMMC<NNMMC_80:806865661:1>.dbf
      Backup Set 81 10-FEB-13
      Backup Piece 104 10-FEB-13 TEST-NNMMC<NNMMC_81:806865668:1>.dbf
      Backup Set 82 10-FEB-13
      Backup Piece 105 10-FEB-13 c-1374507108-20130208-00
      Backup Set 83 10-FEB-13
      Backup Piece 93 10-FEB-13 TEST-NNMMC<NNMMC_83:806997924:1>.dbf
      Backup Set 84 10-FEB-13
      Backup Piece 94 10-FEB-13 TEST-NNMMC<NNMMC_84:806998299:1>.dbf
      Backup Set 85 10-FEB-13
      Backup Piece 95 10-FEB-13 TEST-NNMMC<NNMMC_85:806998350:1>.dbf
      Backup Set 86 10-FEB-13
      Backup Piece 106 10-FEB-13 c-1374507108-20130210-00
      Backup Set 87 10-FEB-13
      Backup Piece 107 10-FEB-13 TEST-NNMMC<NNMMC_87:806998948:1>.dbf
      Backup Set 88 10-FEB-13
      Backup Piece 108 10-FEB-13 TEST-NNMMC<NNMMC_88:806998965:1>.dbf
      Control File Copy 2 10-FEB-13 /var/opt/omni/tmp/ctrl_NNMMC_1834.dbf
      Backup Set 89 10-FEB-13
      Backup Piece 109 10-FEB-13 c-1374507108-20130210-01
      Backup Set 90 10-FEB-13
      Backup Piece 110 10-FEB-13 TEST-NNMMC<NNMMC_90:807026720:1>.dbf
      Backup Set 91 10-FEB-13
      Backup Piece 111 10-FEB-13 TEST-NNMMC<NNMMC_91:807027096:1>.dbf
      Backup Set 92 10-FEB-13
      Backup Piece 112 10-FEB-13 TEST-NNMMC<NNMMC_92:807027111:1>.dbf
      Backup Set 93 10-FEB-13
      Backup Piece 113 10-FEB-13 c-1374507108-20130210-02
      Backup Set 94 10-FEB-13
      Backup Piece 114 10-FEB-13 TEST-NNMMC<NNMMC_94:807027142:1>.dbf
      Backup Set 95 10-FEB-13
      Backup Piece 115 10-FEB-13 TEST-NNMMC<NNMMC_95:807027158:1>.dbf
      Control File Copy 3 10-FEB-13 /var/opt/omni/tmp/ctrl_NNMMC_10184.dbf
      Backup Set 96 10-FEB-13
      Backup Piece 116 10-FEB-13 c-1374507108-20130210-03
      Backup Set 97 11-FEB-13
      Backup Piece 117 11-FEB-13 /usr/ORACLE/NNMOM/NNMMC/backupset/2013_02_11/o1_mf_annnn_TAG20130211T164549_8kknq6b2_.bkp
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of delete command at 02/11/2013 16:56:08
      RMAN-06091: no channel allocated for maintenance (of an appropriate type)


      RMAN> crosscheck backup of archivelog all;

      using channel ORA_DISK_1
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=/usr/ORACLE/NNMOM/NNMMC/backupset/2013_02_11/o1_mf_annnn_TAG20130211T164549_8kknq6b2_.bkp RECID=117 STAMP=807122750
      crosschecked backup piece: found to be 'AVAILABLE'
      backup piece handle=/usr/ORACLE/NNMOM/NNMMC/backupset/2013_02_11/o1_mf_annnn_TAG20130211T164630_8kknrgc9_.bkp RECID=120 STAMP=807122790
      Crosschecked 2 objects

      The above command shows only two archivelog backupsets are there in backup.
        • 1. Re: delete backups
          mseberg
          The error messages says that their isn't any maintenance channel allocated.
           allocate channel for maintenance type 'sbt_tape';
           run {
          delete force noprompt obsolete recovery window of ?? days;
          }
          Best Regards

          mseberg
          • 2. Re: delete backups
            980096
            Hi,

            When i have given command 'list backup', it shows below backups but those are not available in FRA and are available in /tmp path .

            Please let me know what backups are all these.

            ackup Set 56 07-FEB-13
            Backup Piece 69 07-FEB-13 NNMMC-ARCH<NNMMC_56:806523210:1>.dbf
            Backup Set 57 07-FEB-13
            Backup Piece 70 07-FEB-13 NNMMC-ARCH<NNMMC_57:806523218:1>.dbf
            Backup Set 58 07-FEB-13
            Backup Piece 71 07-FEB-13 NNMMC-ARCH<NNMMC_58:806523219:1>.dbf
            Backup Set 59 07-FEB-13
            Backup Piece 72 07-FEB-13 NNMMC-ARCH<NNMMC_59:806523244:1>.dbf
            Backup Set 60 07-FEB-13
            Backup Piece 73 07-FEB-13 c-1374507108-20130204-00
            Backup Set 61 07-FEB-13
            Backup Piece 74 07-FEB-13 NNMMC-ARCH<NNMMC_61:806687906:1>.dbf
            Backup Set 62 07-FEB-13
            Backup Piece 75 07-FEB-13 NNMMC-ARCH<NNMMC_62:806687916:1>.dbf
            Backup Set 63 07-FEB-13
            Backup Piece 76 07-FEB-13 NNMMC-ARCH<NNMMC_63:806687919:1>.dbf
            Backup Set 64 07-FEB-13
            Backup Piece 77 07-FEB-13 NNMMC-ARCH<NNMMC_64:806687937:1>.dbf
            Backup Set 65 07-FEB-13
            Backup Piece 78 07-FEB-13 c-1374507108-20130206-00
            Backup Set 66 07-FEB-13
            Backup Piece 66 07-FEB-13 NNMMC-ARCH<NNMMC_66:806774315:1>.dbf
            Backup Set 67 07-FEB-13
            Backup Piece 67 07-FEB-13 NNMMC-ARCH<NNMMC_67:806774591:1>.dbf
            Backup Set 68 07-FEB-13
            Backup Piece 68 07-FEB-13 NNMMC-ARCH<NNMMC_68:806774617:1>.dbf
            Backup Set 69 07-FEB-13
            Backup Piece 79 07-FEB-13 c-1374507108-20130207-00
            Backup Set 70 07-FEB-13
            Backup Piece 80 07-FEB-13 NNMMC-ARCH<NNMMC_70:806774991:1>.dbf
            Backup Set 71 07-FEB-13
            Backup Piece 81 07-FEB-13 NNMMC-ARCH<NNMMC_71:806775007:1>.dbf
            Control File Copy 1 07-FEB-13 /var/opt/omni/tmp/ctrl_NNMMC_21797.dbf
            Backup Set 72 07-FEB-13
            • 3. Re: delete backups
              980096
              Hi,

              I got error when given below command.

              RMAN> allocate channel for maintenance type 'sbt_tape';

              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_2 channel at 02/11/2013 19:32:47
              ORA-19554: error allocating device, device type: SBT_TAPE, device name:
              ORA-27211: Failed to load Media Management Library
              Additional information: 2
              • 4. Re: delete backups
                mseberg
                What Media Management software are you using?
                • 5. Re: delete backups
                  brunors
                  What media and S.O do you using?

                  Kind regards, Bruno Reis.
                  www.brunors.com
                  • 6. Re: delete backups
                    980096
                    Hi,

                    Its disk device media.

                    i got solution.

                    thanks.