环境: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]$
重新启动备份 可以正常备份