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