6 Replies Latest reply: May 16, 2012 10:19 AM by 632013 RSS

    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
              • 4. Re: RMAN Delete Obsolete job fails due to Error Allocating Device
                415289
                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
                • 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!