tsm备份报错

环境:AIX 5.3
        tsm 6.2
        oracle11g
问题描述:
# ls
bkdb_bprod.log   bklog_bprod.log  expirebprod.log
# more bkdb*
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jun 14 23:00:00 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
connected to target database: BPROD (DBID=856828653)
connected to recovery catalog database
RMAN> run {
2> allocate channel ch1 type 'SBT_TAPE' parms  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_bprod.opt)';
3> allocate channel ch2 type 'SBT_TAPE' parms  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_bprod.opt)';
4> backup incremental level 0 format 'inc0_%d_%s_%p_%T' filesperset 20 database tag levelbackup0;
5> backup current controlfile format 'ctl_%d_%T_%s_%p';
6> sql 'alter system archive log current';
7> release channel ch1;
8> release channel ch2;
9> }
10>
11>
allocated channel: ch1
channel ch1: SID=255 device type=SBT_TAPE
channel ch1: Data Protection for Oracle: version 5.4.1.0
allocated channel: ch2
channel ch2: SID=319 device type=SBT_TAPE
channel ch2: Data Protection for Oracle: version 5.4.1.0
Starting backup at 14-JUN-11
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00005 name=/bi/app/oracle/oradata/bprod/BIEE.DBF
input datafile file number=00007 name=/bi/app/oracle/oradata/bprod/INFAREP.DBF
input datafile file number=00009 name=/bi/app/oracle/oradata/bprod/BIEE2.DBF
input datafile file number=00011 name=/bi/app/oracle/oradata/bprod/INFAREP1.DBF
input datafile file number=00004 name=/bi/app/oracle/oradata/bprod/users01.dbf
input datafile file number=00002 name=/bi/app/oracle/oradata/bprod/sysaux01.dbf
channel ch1: starting piece 1 at 14-JUN-11
channel ch2: starting incremental level 0 datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00006 name=/bi/app/oracle/oradata/bprod/INFADOMAIN.DBF
input datafile file number=00008 name=/bi/app/oracle/oradata/bprod/BIEE1.DBF
input datafile file number=00010 name=/bi/app/oracle/oradata/bprod/INFADOMAIN1.DBF
input datafile file number=00003 name=/bi/app/oracle/oradata/bprod/undotbs01.dbf
input datafile file number=00012 name=/bi/app/oracle/oradata/bprod/undotbs02.dbf
input datafile file number=00001 name=/bi/app/oracle/oradata/bprod/system01.dbf
channel ch2: starting piece 1 at 14-JUN-11
channel ch1: finished piece 1 at 14-JUN-11
piece handle=inc0_BPROD_3806_1_20110614 tag=LEVELBACKUP0 comment=API Version 2.0,MMS Version 5.4.1.0
channel ch1: backup set complete, elapsed time: 00:02:35
RMAN-03009: failure of backup command on ch2 channel at 06/14/2011 23:25:58
ORA-19502: write error on file "inc0_BPROD_3807_1_20110614", block number 1 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1312E (RC12)   Server media mount not possible
channel ch2 disabled, job failed on it will be run on another channel
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00006 name=/bi/app/oracle/oradata/bprod/INFADOMAIN.DBF
input datafile file number=00008 name=/bi/app/oracle/oradata/bprod/BIEE1.DBF
input datafile file number=00010 name=/bi/app/oracle/oradata/bprod/INFADOMAIN1.DBF
input datafile file number=00003 name=/bi/app/oracle/oradata/bprod/undotbs01.dbf
input datafile file number=00012 name=/bi/app/oracle/oradata/bprod/undotbs02.dbf
input datafile file number=00001 name=/bi/app/oracle/oradata/bprod/system01.dbf
channel ch1: starting piece 1 at 14-JUN-11
channel ch1: finished piece 1 at 14-JUN-11
piece handle=inc0_BPROD_3808_1_20110614 tag=LEVELBACKUP0 comment=API Version 2.0,MMS Version 5.4.1.0
channel ch1: backup set complete, elapsed time: 00:02:25
Finished backup at 14-JUN-11
Starting backup at 14-JUN-11
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current control file in backup set
channel ch1: starting piece 1 at 14-JUN-11
channel ch1: finished piece 1 at 14-JUN-11
piece handle=ctl_BPROD_20110614_3809_1 tag=TAG20110614T232827 comment=API Version 2.0,MMS Version 5.4.1.0
channel ch1: backup set complete, elapsed time: 00:00:03
Finished backup at 14-JUN-11
Starting Control File and SPFILE Autobackup at 14-JUN-11
piece handle=c-856828653-20110614-01 comment=API Version 2.0,MMS Version 5.4.1.0
Finished Control File and SPFILE Autobackup at 14-JUN-11
sql statement: alter system archive log current
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of release command at 06/14/2011 23:28:44
RMAN-06012: channel: ch2 not allocated
Recovery Manager complete.


问题出在什么地方?如何解决?
参与16

15同行回答

colinscolins系统工程师金融行业
先管着是TSM的故障,你先瞧瞧你的ORACLE 吧,以为TSM本身只是调用RMAN这个工具的。倘若你单独在ORACLE的RMAN命令行下,都不能备份的话,那你只有先解决了再说。显示全部
先管着是TSM的故障,你先瞧瞧你的ORACLE 吧,以为TSM本身只是调用RMAN这个工具的。
倘若你单独在ORACLE的RMAN命令行下,都不能备份的话,那你只有先解决了再说。收起
银行 · 2011-06-19
浏览1543
GloryLewGloryLew项目经理河北东软软件有限公司
在分配通道2 CH2时,不能正常分配通道,问题应该在其中的一个驱动器上RMAN-03009: failure of backup command on ch2 channel at 06/14/2011 23:25:58开始使用通道1 CH1继续进行备份任务,应该最后备份是成功的,只是其中在分配通道CH2脚本时报错,可以只使用CH1来备份任务,只能不...显示全部
在分配通道2 CH2时,不能正常分配通道,问题应该在其中的一个驱动器上
RMAN-03009: failure of backup command on ch2 channel at 06/14/2011 23:25:58

开始使用通道1 CH1继续进行备份任务,应该最后备份是成功的,只是其中在分配通道CH2脚本时报错,

可以只使用CH1来备份任务,只能不能同时进行备份,时间会久些

可通过RMAN的命令查询备份集的时间点,是否是计划的时间点,查看是否备份成功

rman>list backup of database;
rman>list backup of archivelog all;
rman>list backup of controlfile;
rman>list backup of spfile;收起
系统集成 · 2011-06-18
浏览1447
疯狂石头疯狂石头IT顾问江苏巨鸿
估计是6.2的bug吧 看样子 没啥问题显示全部
估计是6.2的bug吧 看样子 没啥问题收起
IT咨询服务 · 2011-06-18
浏览1520
xgq1030xgq1030系统管理员山东世纪阳光
学习中我们用的TSM,我现在也在学习中,看不大懂呀显示全部
学习中
我们用的TSM,我现在也在学习中,看不大懂呀收起
机械装备 · 2011-06-18
浏览1502
kw002007kw002007存储架构师X公司
官方文档上面没有这些错误解释么?显示全部
官方文档上面没有这些错误解释么?收起
互联网服务 · 2011-06-17
浏览1514
anyportanyport技术经理金欧利
又不行了显示全部
又不行了收起
互联网服务 · 2011-06-17
浏览2016
tuzi8351tuzi8351软件开发工程师天津
啥也看不出问题来,没玩过这个啊显示全部
啥也看不出问题来,没玩过这个啊收起
政府机关 · 2011-06-15
浏览1991
myguangzhoumyguangzhou技术经理Uniwise
没用过TSM只能路过了显示全部
没用过TSM
只能路过了收起
互联网服务 · 2011-06-15
浏览1956
风影子风影子数据库管理员深圳
好了就行。显示全部
好了就行。收起
互联网服务 · 2011-06-15
浏览2019
anyportanyport技术经理金欧利
暂时解决,期待明天其他备份不会因为修改产生问题。修改ts3200driver的control path dirve,其中一个状态为NO,修改为Yes。Drive Identity  1 (LUN)  Vendor ID  IBM  Product ID  ULT3580-TD4  Serial Number&n...显示全部
暂时解决,期待明天其他备份不会因为修改产生问题。
修改ts3200driver的control path dirve,其中一个状态为NO,修改为Yes。
Drive Identity  1 (LUN)  
Vendor ID  IBM  
Product ID  ULT3580-TD4  
Serial Number  1310*****
Firmware Revision  A239  
Element Address  256  
Control Path Drive  Yes  
Data Compression  Yes  
Interface Type  Fibre Channel  
Node Name  2001000E11141CF2  
Port A  Enabled  
   Port Name  2002000E11141CF2  
   Topology  LN-Port  
   FC-AL Loop ID  04  
   Speed  Automatic  
Port B  Disabled  

Drive Identity  2 (LUN)  
Vendor ID  IBM  
Product ID  ULT3580-TD4  
Serial Number  1310*****
Firmware Revision  A239  
Element Address  257  
Control Path Drive  Yes  
Data Compression  Yes  
Interface Type  Fibre Channel  
Node Name  2007000E11141CF2  
Port A  Enabled  
   Port Name  2008000E11141CF2  
   Topology  LN-Port  
   FC-AL Loop ID  05  
   Speed  Automatic  
Port B  Disabled收起
互联网服务 · 2011-06-15
浏览2039

提问者

anyport
技术经理金欧利

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2011-06-15
  • 关注会员:1 人
  • 问题浏览:11912
  • 最近回答:2011-06-19
  • X社区推广