DP Backup error Ora-19554:error allocating device, device Type:sbt_tape ORA-27211

Source: Internet
Author: User

Environment: Solaris 10,oracle 11.2.0.4 2nodes RAC

Symptoms: Rman backup error is as follows

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE, STACK follows ===============
RMAN-00571: ===========================================================
Rman-03009:failure of allocate command on DEV_0 channel at 12/05/2014 10:25:25
Ora-19554:error allocating device, device Type:sbt_tape, device name:
ora-27211:failed to load Media Management Library
Additional information:3986

1. Attempt to configure Rman parameters as follows cannot be resolved

Use configure CHANNEL DEVICE TYPE ' Sbt_tape ' CLEAR;
CONFIGURE DEVICE TYPE Sbt_tape CLEAR; Command
As follows:
rman> CONFIGURE CHANNEL DEVICE TYPE ' Sbt_tape ' CLEAR;
Old RMAN configuration parameters is successfully deleted

rman>Show All;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY to redundancy 1;
CONFIGURE BACKUP optimization OFF; # default
CONFIGURE DEFAULT DEVICE TYPE to ' sbt_tape ';
CONFIGURE controlfile autobackup on;
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; # default
CONFIGURE DEVICE type DISK PARALLELISM 1 BACKUP type to BACKUPSET; # default
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 '/opt/oracle/product/10.2.0/dbs/snapcf_ge02.f '; # default

RMAN> configure DEFAULT DEVICE TYPE to Disk;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE to ' sbt_tape ';
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE to DISK;
new RMAN configuration parameters is successfully stored
starting full resync of recovery catalog
full Resync complete

rman> CONFIGURE DEVICE TYPE sbt_tape CLEAR;
RMAN configuration parameters is 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;
CONFIGURE controlfile autobackup on;
CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to '%F '; # default
CONFIGURE DEVICE type DISK PARALLELISM 1 BACKUP type to BACKUPSET; # default
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 '/opt/oracle/product/10.2.0/dbs/snapcf_ge02.f '; # default


Two: Compare the original AIX that can be backed up normally

LIBOBK file found under $oracle_home/lib/

sfc3rac1:/apps/oracle/product/10.2.0/lib$ LS-LRT |grep BOBK
lrwxrwxrwx 1 Oracle Oinstall LIBOBK.A-/USR/OMNI/LIB/LIBOB2ORACLE8_64BIT.A
sfc3rac1:/apps/oracle/product/10.2.0/lib$

But insisted that the current Solaris does not have this soft connection file in Oracle Home

There is a secondary file under the DP installation path

[email protected]:/opt/omni/lib] #ls-LRT
Total 16200
-r-xr-xr-x 1 root sys 9240 MAY libde_64bit.so
-r-xr-xr-x 1 root sys 6508 MAY libde.so
-r-xr-xr-x 1 root sys 19216 MAY libdc_64bit.so
-r-xr-xr-x 1 root sys 14944 MAY libdc.so
-r-xr-xr-x 1 root sys 590704 MAY libae_64bit.so
-r-xr-xr-x 1 root sys 471768 MAY libae.so
-r-xr-xr-x 1 root sys 22984 MAY libbrandchg_64bit.so
-r-xr-xr-x 1 root sys 15452 MAY libbrandchg.so
-r-xr-xr-x 1 root sys 41064 MAY libgcc_s.so.1
-r-xr-xr-x 1 root sys 1314792 MAY libstdc++.so.6.0.3
-r-xr-xr-x 1 root sys 334632 MAY libssl.so.0.9.8
-r-xr-xr-x 1 root sys 1664880 MAY libob2oracle8_64bit.so
-r-xr-xr-x 1 root sys 1460060 MAY libob2oracle8.so
-r-xr-xr-x 1 root sys 622436 MAY libcurl.so
-r-xr-xr-x 1 root sys 1596784 MAY libcrypto.so.0.9.8
drwxr-xr-x 2 root sys Oct 15:01 build
drwxr-xr-x 9 Root sys Oct 15:01 nls
lrwxrwxrwx 1 root root the Oct 15:01 libgcc_s.so-libgcc_s.so.1
lrwxrwxrwx 1 root root (Oct) 15:01 libstdc++.so-libstdc++.so.6.0.3
lrwxrwxrwx 1 root root (Oct) 15:01 libstdc++.so.6-libstdc++.so.6.0.3
drwxr-xr-x Root sys 3584 DEC 3 14:49 perl
[[Email protected]:/opt/omni/lib]#

To manually establish a soft connection

Ln-s/opt/omni/lib/libob2oracle8_64bit.so/u01/app/oracle/product/11.2.0/dbhome_1/lib/libobk.so

This file is already available under Oracle-home

[Email protected]:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$ ls-lrt |grep Bob
lrwxrwxrwx 1 Oracle Oinstall 5 10:43 libobk.so/opt/omni/lib/libob2oracle8_64bit.so
[[Email protected]:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$


Restart backup can be backed up normally

DP Backup error Ora-19554:error allocating device, device Type:sbt_tape ORA-27211

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.