首页 > 代码库 > DP备份报错 ORA-19554: error allocating device, device type: SBT_TAPE ORA-27211
DP备份报错 ORA-19554: error allocating device, device type: SBT_TAPE ORA-27211
环境:solaris 10,oracle 11.2.0.4 2nodes rac
症状:rman备份报错如下
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.尝试使用如下方法配置rman参数 无法解决
使用CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE‘ CLEAR;
CONFIGURE DEVICE TYPE SBT_TAPE CLEAR; 命令;
如下:
RMAN> CONFIGURE CHANNEL DEVICE TYPE ‘SBT_TAPE‘ CLEAR;
old RMAN configuration parameters are 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 are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN>CONFIGURE DEVICE TYPE SBT_TAPE CLEAR;
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;
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
二:对比原来可以正常备份的AIX
发现$ORACLE_HOME/lib/下有 libobk文件
sfc3rac1:/apps/oracle/product/10.2.0/lib$ ls -lrt |grep bobk
lrwxrwxrwx 1 oracle oinstall 35 Jul 02 2010 libobk.a -> /usr/omni/lib/libob2oracle8_64bit.a
sfc3rac1:/apps/oracle/product/10.2.0/lib$
但是坚持当前solaris 下oracle home中没有此软连接文件
DP安装路径下是有次文件
[root@nsfc3rac2:/opt/omni/lib]#ls -lrt
total 16200
-r-xr-xr-x 1 root sys 9240 May 24 2013 libde_64bit.so
-r-xr-xr-x 1 root sys 6508 May 24 2013 libde.so
-r-xr-xr-x 1 root sys 19216 May 24 2013 libdc_64bit.so
-r-xr-xr-x 1 root sys 14944 May 24 2013 libdc.so
-r-xr-xr-x 1 root sys 590704 May 24 2013 libae_64bit.so
-r-xr-xr-x 1 root sys 471768 May 24 2013 libae.so
-r-xr-xr-x 1 root sys 22984 May 24 2013 libBrandChg_64bit.so
-r-xr-xr-x 1 root sys 15452 May 24 2013 libBrandChg.so
-r-xr-xr-x 1 root sys 41064 May 24 2013 libgcc_s.so.1
-r-xr-xr-x 1 root sys 1314792 May 24 2013 libstdc++.so.6.0.3
-r-xr-xr-x 1 root sys 334632 May 24 2013 libssl.so.0.9.8
-r-xr-xr-x 1 root sys 1664880 May 24 2013 libob2oracle8_64bit.so
-r-xr-xr-x 1 root sys 1460060 May 24 2013 libob2oracle8.so
-r-xr-xr-x 1 root sys 622436 May 24 2013 libcurl.so
-r-xr-xr-x 1 root sys 1596784 May 24 2013 libcrypto.so.0.9.8
drwxr-xr-x 2 root sys 512 Oct 30 15:01 build
drwxr-xr-x 9 root sys 512 Oct 30 15:01 nls
lrwxrwxrwx 1 root root 13 Oct 30 15:01 libgcc_s.so -> libgcc_s.so.1
lrwxrwxrwx 1 root root 18 Oct 30 15:01 libstdc++.so -> libstdc++.so.6.0.3
lrwxrwxrwx 1 root root 18 Oct 30 15:01 libstdc++.so.6 -> libstdc++.so.6.0.3
drwxr-xr-x 50 root sys 3584 Dec 3 14:49 perl
[root@nsfc3rac2:/opt/omni/lib]#
手动建立软连接
ln -s /opt/omni/lib/libob2oracle8_64bit.so /u01/app/oracle/product/11.2.0/dbhome_1/lib/libobk.so
oracle-home下已经有此文件
[oracle@nsfc3rac2:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$ ls -lrt |grep bob
lrwxrwxrwx 1 oracle oinstall 36 Dec 5 10:43 libobk.so -> /opt/omni/lib/libob2oracle8_64bit.so
[oracle@nsfc3rac2:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$
重新启动备份 可以正常备份
DP备份报错 ORA-19554: error allocating device, device type: SBT_TAPE ORA-27211