记一次tsm问题

正常情况下的rman日志：

-bash-3.2$ cat full.log

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 24 01:00:01 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1333756509)

RMAN> run{
2> allocate channel t1 type 'sbt_tape' connect *parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> backup
4> format 'ctl_t%t_s%s_p%p'
5> tag cf
6> (current controlfile);
7> backup
8> full
9> filesperset 8
10> format 'db_t%t_s%s_p%p'
11> tag fulldb
12> (database);
13> release channel t1;
14> }
15>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=1308 instance=orcl1 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

Starting backup at 24-AUG-13
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
including current control file in backup set
channel t1: starting piece 1 at 24-AUG-13
channel t1: finished piece 1 at 24-AUG-13
piece handle=ctl_t824259605_s4226_p1 tag=CF comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:03
Finished backup at 24-AUG-13

Starting backup at 24-AUG-13
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00004 name=+DATABASE/orcl/datafile/ts_jlora.266.805975795
input datafile file number=00001 name=+DATABASE/orcl/datafile/system.262.805975779
input datafile file number=00003 name=+DATABASE/orcl/datafile/undotbs1.264.805975785
input datafile file number=00006 name=+DATABASE/orcl/datafile/users.268.805975823
channel t1: starting piece 1 at 24-AUG-13
channel t1: finished piece 1 at 24-AUG-13
piece handle=db_t824259610_s4227_p1 tag=FULLDB comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:30:35
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00012 name=+DATABASE/orcl/datafile/ts_jlora_test.635.815672781
input datafile file number=00008 name=+DATABASE/orcl/datafile/ndmain.409.809885731
input datafile file number=00002 name=+DATABASE/orcl/datafile/sysaux.263.805975783
input datafile file number=00005 name=+DATABASE/orcl/datafile/undotbs2.267.805975821
input datafile file number=00007 name=+DATABASE/orcl/datafile/jilin.408.809885727
input datafile file number=00009 name=+DATABASE/orcl/datafile/gpo.410.809885733
input datafile file number=00010 name=+DATABASE/orcl/datafile/jlzb.411.809885737
input datafile file number=00011 name=+DATABASE/orcl/datafile/jlrep.412.809885739
channel t1: starting piece 1 at 24-AUG-13
channel t1: finished piece 1 at 24-AUG-13
piece handle=db_t824261445_s4229_p1 tag=FULLDB comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:05:45
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel t1: starting piece 1 at 24-AUG-13
channel t1: finished piece 1 at 24-AUG-13
piece handle=db_t824261791_s4230_p1 tag=FULLDB comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-AUG-13

released channel: t1

Recovery Manager complete.
**********************************************************************************************************

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jul 19 21:30:00 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1333756509)

RMAN> run{
2> allocate channel t1 type 'sbt_tape' connect *parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/
bin64/tdpo.opt)';
3> sql 'alter system archive log current';
4> backup
5> format 'ctl_t%t_s%s_p%p'
6> tag cf
7> (current controlfile);
8> backup archivelog all format 'date+%Y%m%d_archivelog_%d_%s_%p_%u.bak' delete all input;
9> crosscheck backup;
10> delete noprompt expired backup;
11> delete noprompt obsolete;
12> release channel t1;
13> }
14>
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=525 instance=orcl1 device type=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.4.1.0

sql statement: alter system archive log current

Starting backup at 19-JUL-13
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
including current control file in backup set
channel t1: starting piece 1 at 19-JUL-13
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 07/19/2013 21:36:41
ORA-19506: failed to create sequential file, name="ctl_t821223015_s3279_p1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1017E (RC-50)  Session rejected: TCP/IP connection failure

Recovery Manager complete.
Fri Jul 19 21:36:41 GMT+08:00 2013
Fri Jul 19 22:30:00 GMT+08:00 2013

 

在报错后，通过dsmadmc连接TSM，TSM无法正常连接。最后在高级工程师的排查下知道了是因为TSM连接的DB2的日志太大了，空间不够，导致无法正常工作。