首頁  >  文章  >  資料庫  >  DP备份报错ORA-19554:errorallocatingdevice,devicetype:SBT_TAP

DP备份报错ORA-19554:errorallocatingdevice,devicetype:SBT_TAP

WBOY
WBOY原創
2016-06-07 16:11:092600瀏覽

环境:solaris 10,oracle 11.2.0.4 2nodes rac 症状:rman备份报错如下 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===============

环境: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]$

重新启动备份 可以正常备份

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn