程序员人生 网站导航

DP备份报错 ORA-19554: error allocating device, device type: SBT_TAPE ORA-27211

栏目:数据库应用时间:2014-12-13 09:15:52

环境: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⑴9554: error allocating device, device type: SBT_TAPE, device name: 
ORA⑵7211: 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


2:对照原来可以正常备份的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]$ 


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

------分隔线----------------------------
------分隔线----------------------------

最新技术推荐