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

php中文网

发布时间：2016-06-07 16:11:09

2959人浏览过

来源于php中文网

原创

环境：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文件

Picsart

Picsart是全球最大的数字创作平台。

下载

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]$

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

mysql数据库误删怎么从备份恢复_mysql数据库误删后如何利用备份恢复数据

mysql去重操作有什么风险_mysql去重操作潜在风险分析

mysql备份恢复失败怎么解决_mysql备份恢复失败后如何排查并恢复数据

mysql表结构丢失怎么恢复_mysql表结构丢失后如何恢复并重建数据

mysql启动命令如何配置多实例_mysql启动命令多实例启动配置教程

本站声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

上一篇：SymmetricDS安装记录下一篇：数据库完整性

热门AI工具