6 Replies Latest reply on May 16, 2012 3:19 PM by 632013

    RMAN Delete Obsolete job fails due to Error Allocating Device

    632013
      Experts, I need help, please.

      This is 10.2.0.1 on Windows

      RMAN> DELETE NOPROMPT OBSOLETE;

      RMAN retention policy will be applied to the command
      RMAN retention policy is set to recovery window of 3 days
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=130 devtype=DISK
      released channel: ORA_DISK_1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of delete command at 05/15/2012 14:10:17
      ORA-19554: error allocating device, device type: SBT_TAPE, device name:
      ORA-27211: Failed to load Media Management Library


      I ran RMAN> configure device type 'SBT_TAPE' clear;
      but I still get the same error.

      I backup to Disk, not tape

      Notice the reference to SBT_TAPE:

      RMAN configuration parameters are:
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
      CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

      What do I need to do to be able to run DELETE OBSOLETE; ?

      Thanks, John
        • 1. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
          mseberg
          Hello;

          You can try :

          CONFIGURE DEVICE TYPE 'SBT_TAPE' clear; ( this is different how ?? ) 103 (61 unresolved)

          And then run the DELETE command again.

          You may also find this error if your third party libraries for the tape are mismatched.

          Best Regards

          mseberg
          • 2. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
            632013
            Thanks for your reply.

            This is the 3rd time i have ran CONFIGURE DEVICE TYPE 'SBT_TAPE' clear;


            Then I ran:

            RMAN> delete obsolete;

            using target database control file instead of recovery catalog
            RMAN retention policy will be applied to the command
            RMAN retention policy is set to recovery window of 3 days
            allocated channel: ORA_DISK_1
            channel ORA_DISK_1: sid=132 devtype=DISK
            RMAN-06908: WARNING: operation will not run in parallel on the allocated channel
            s
            RMAN-06909: WARNING: parallelism require Enterprise Edition
            released channel: ORA_DISK_1
            RMAN-00571: ===========================================================
            RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
            RMAN-00571: ===========================================================
            RMAN-03002: failure of delete command at 05/15/2012 22:00:29
            ORA-19554: error allocating device, device type: SBT_TAPE, device name:
            ORA-27211: Failed to load Media Management Library

            So there has been no change. Please help; I am unable to delete obsolete backups.
            Thanks, John
            • 3. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
              anand prakash - oracle
              Hi,

              Can you try --
              CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear; 
              
              show all 
              
              delete obsolete noprompt;
              Anand
              1 person found this helpful
              • 4. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
                kuljeet singh -
                as anand mention ,you've to reset this parameter to default value.
                and clear cmd with configure will remove it from configuration parameter
                see below
                RMAN> show all;
                
                RMAN configuration parameters are:
                CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
                CONFIGURE BACKUP OPTIMIZATION OFF; # default
                CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
                *CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;*
                CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10/db/dbs/snapcf_GG1.f'; # default
                
                RMAN> delete obsolete;
                
                RMAN retention policy will be applied to the command
                RMAN retention policy is set to redundancy 1
                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03002: failure of delete command at 05/16/2012 12:04:34
                ORA-19554: error allocating device, device type: SBT_TAPE, device name:
                ORA-27211: Failed to load Media Management Library
                Additional information: 2
                
                
                RMAN>  CONFIGURE DEVICE TYPE 'SBT_TAPE' clear;
                
                old RMAN configuration parameters:
                CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
                RMAN configuration parameters are successfully reset to default value
                
                RMAN> show all;
                
                RMAN configuration parameters are:
                CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
                CONFIGURE BACKUP OPTIMIZATION OFF; # default
                CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
                CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10/db/dbs/snapcf_GG1.f'; # default
                
                RMAN> delete obsolete;
                
                RMAN retention policy will be applied to the command
                RMAN retention policy is set to redundancy 1
                allocated channel: ORA_DISK_1
                channel ORA_DISK_1: sid=1591 instance=GG1 devtype=DISK
                allocated channel: ORA_DISK_2
                channel ORA_DISK_2: sid=1627 instance=GG1 devtype=DISK
                no obsolete backups found
                1 person found this helpful
                • 5. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
                  viconstg
                  Try to use CROSSCHECK BACKUP first, and then repeat DELETE OBSOLETE
                  • 6. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
                    632013
                    Thanks Anand, Kuljeet and Viconstq.

                    I ran:

                    RMAN> CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' clear;

                    old RMAN configuration parameters:
                    CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 35 G;
                    old RMAN configuration parameters are successfully deleted

                    RMAN> show all;

                    RMAN configuration parameters are:
                    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
                    CONFIGURE BACKUP OPTIMIZATION OFF; # default
                    CONFIGURE DEFAULT DEVICE TYPE TO DISK;
                    CONFIGURE CONTROLFILE AUTOBACKUP ON;
                    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\Oracle\produ
                    ct\10.2.0\flash_recovery_area\FS9ENFP1\AUTOBACKUP\%F';
                    CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
                    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                    CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 35 G;
                    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                    CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
                    NCFFS9ENFP1.ORA'; # default


                    .. but I think it was RMAN> CROSSCHECK BACKUP; that reset something.

                    Because after RMAN> CROSSCHECK BACKUP; the DELETE OBSOLETE; actually removed many files successfully.

                    Thanks for your help!