今天在配置dp时，dp中报错：
用手工测试也有类似的报错：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 |
RMAN> run{ 2> allocate channel t1 type 'sbt_tape' ; 3> allocate channel t2 type 'sbt_tape' ; 4> backup datafile 3 5> format 'test_bk_%u_%p_%s.RMN' 6> include current controlfile; 7> } RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of allocate command on t1 channel at 09/01/2007 04:25:21 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 RMAN> ################################ ###### 但是备份到disk却没有问题 ################################ RMAN> RMAN> RMAN> RMAN> run{ 2> allocate channel t1 type disk ; 3> allocate channel t2 type disk ; 4> backup datafile 2 5> format '/iarch/test_bk_%u_%p_%s.RMN' 6> include current controlfile; 7> } allocated channel: t1 channel t1: sid=58 devtype=DISK allocated channel: t2 channel t2: sid=70 devtype=DISK Starting backup at 01-SEP-07 channel t1: starting full datafile backupset channel t1: specifying datafile(s) in backupset including current controlfile in backupset channel t1: starting piece 1 at 01-SEP-07 channel t2: starting full datafile backupset channel t2: specifying datafile(s) in backupset input datafile fno=00002 name=/dev/vg_iora01/rdata_1g_001 channel t2: starting piece 1 at 01-SEP-07 channel t1: finished piece 1 at 01-SEP-07 piece handle=/iarch/test_bk_01iqqmc8_1_1.RMN comment=NONE channel t1: backup set complete, elapsed time: 00:00:04 channel t2: finished piece 1 at 01-SEP-07 piece handle=/iarch/test_bk_02iqqmca_1_2.RMN comment=NONE channel t2: backup set complete, elapsed time: 00:00:37 Finished backup at 01-SEP-07 released channel: t1 released channel: t2 RMAN> |
检查了lib库中的link也是已经建立了：
|
1 2 |
gd_idb02:[/oracle/app/oracle/product/9.2.0/lib$]ll libobk.sl lrwxrwxrwx 1 oracle dba 36 Sep 3 10:01 libobk.sl -> /opt/omni/lib/libob2oracle8ale_64bit.sl |
后来查了相关的文档，才发现那个link的微妙差别，原来在64位的oracle9i下，建立的link应该是
|
1 |
libobk.sl -> /opt/omni/lib/libob2oracle8_64bit.sl |
而不是/opt/omni/lib/libob2oracle8ale_64bit.sl
-_-!!
rm 这个link后，重新建立link：
ln -s /opt/omni/lib/libob2oracle8_64bit.sl libobk.sl
手工备份到磁带，这下成功：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
gd_idb02:[/oracle$]rman target sys/change_on_install@gdimall2 nocatalog Recovery Manager: Release 9.2.0.6.0 - 64bit Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: GDIMALL2 (DBID=411161493) using target database controlfile instead of recovery catalog RMAN> RMAN> RMAN> RMAN> run { 2> allocate channel 'dev_0' type 'sbt_tape' 3> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=gdimall,OB2BARLIST=oracle_arch)'; 4> allocate channel 'dev_1' type 'sbt_tape' 5> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=gdimall,OB2BARLIST=oracle_arch)'; 6> allocate channel 'dev_2' type 'sbt_tape' 7> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=gdimall,OB2BARLIST=oracle_arch)'; 8> allocate channel 'dev_3' type 'sbt_tape' 9> parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=gdimall,OB2BARLIST=oracle_arch)'; 10> sql 'alter system archive log current'; 11> backup datafile 3 12> format 'gdimall_%s:%t:%p.dbf'; 13> } allocated channel: dev_0 channel dev_0: sid=17 devtype=SBT_TAPE channel dev_0: Data Protector A.06.00/331 allocated channel: dev_1 channel dev_1: sid=28 devtype=SBT_TAPE channel dev_1: Data Protector A.06.00/331 allocated channel: dev_2 channel dev_2: sid=19 devtype=SBT_TAPE channel dev_2: Data Protector A.06.00/331 allocated channel: dev_3 channel dev_3: sid=64 devtype=SBT_TAPE channel dev_3: Data Protector A.06.00/331 sql statement: alter system archive log current Starting backup at 03-SEP-07 channel dev_0: starting full datafile backupset channel dev_0: specifying datafile(s) in backupset input datafile fno=00003 name=/dev/vg_iora01/rdata_1g_009 channel dev_0: starting piece 1 at 03-SEP-07 channel dev_0: finished piece 1 at 03-SEP-07 piece handle=gdimall_24:632324733:1.dbf comment=API Version 2.0,MMS Version 65.6.0.75 channel dev_0: backup set complete, elapsed time: 00:02:18 Finished backup at 03-SEP-07 released channel: dev_1 released channel: dev_2 released channel: dev_3 released channel: dev_0 RMAN> |
用dp软件在界面上备份，也是备份成功的。
|
1 2 3 4 5 6 7 8 9 10 |
gd_idb02:[/#]omnidb -session -last 7 SessionID Type Status User.Group@Host =============================================================================== 2007/09/03-2 Backup Failed oracle.dba@gd_idb02 2007/09/03-3 Backup Failed oracle.dba@gd_idb02 2007/09/03-4 Backup Failed oracle.dba@gd_idb02 2007/09/03-5 Backup Failed oracle.dba@gd_idb02 2007/09/03-6 Backup Aborted oracle.dba@gd_idb02 2007/09/03-7 Backup Completed oracle.dba@gd_idb02 2007/09/03-8 Backup Completed oracle.dba@gd_idb02 |
附：《HP OpenView Storage Data Protector Integration Guide for Oracle SAP》
.
一条评论
帮我帮我一大忙了，现在rman可以连上磁带机了，谢谢