HP-UX TDP 报错：ANE4994S ANU0599 ANU2602E，急！
各位好，
近日在帮客户安装TSM并部署TDPO后，执行RMAN脚本时出现报错：
环境：
两台HP-UX 版本11.3
Oracle 10g并部署了RAC
TSM服务器设置：
已为两台HP-UX创建node，分别为db1及db2，参照IBM官方文档，为Oracle RAC部署TDP时还需要创建agent node，因此创建节点db_asnode，并关联db1与db2
db1与db2及db_asnode都已配置为backdel=yes archdel=yes
两台HP-UX的sbttest均能通过
在DB1上运行脚本如下：
{
allocate channel t1 device type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
set limit channel t1 kbytes 1900000;
backup database;
backup archivelog all delete input;
}
RMAN报错信息如下：
piece handle=93p4ifou_156_1 tag=TAG20140331T141806 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: starting piece 157 at 31-MAR-14
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 03/31/2014 21:44:42
ORA-19502: write error on file "93p4ifou_157_1", blockno 777473 (blocksize=1024)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1017E (RC-50) Session rejected: TCP/IP connection failure
登录TSM Server后q actlog如下：
……前面略去
3/31/14 20:35:12 ANR0406I Session 887 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(54410)). (SESSION: 887)
03/31/14 20:35:12 ANR0397I Session 887 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 887)
03/31/14 20:35:12 ANR0511I Session 887 opened output volume 543ACKL5.(SESSION: 887)
03/31/14 20:40:29 ANE4991I (Session: 887, Node: TYDB_ASNODE) TDP Oracle HP
ANU0599 TDP for Oracle: (20382): =>(tydb1)
ANU2535I File /orc10_db//93p4ifou_156_1 = 1945632768 bytes sent (SESSION: 887)
03/31/14 20:40:29 ANE4991I (Session: 887, Node: TYDB_ASNODE) TDP Oracle HP
ANU0599 TDP for Oracle: (20382): =>(tydb1)
ANU2526I Backup details for backup piece /orc10_db//93p4ifou_156_1 (database "ams").
Total bytes sent: 1945632768. Total processing time: 00:05:23.
Throughput rate: 5882.45Kb/Sec. Compressed: No . Encryption: None.LAN-Free: No. (SESSION: 887)
03/31/14 20:40:29 ANR0514I Session 887 closed volume 543ACKL5. (SESSION:887)
03/31/14 20:40:29 ANR0399I Session 887 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 887)
03/31/14 20:40:29 ANR0403I Session 887 ended for node TYDB1 (TDP Oracle HP). (SESSION: 887)
03/31/14 20:40:34 ANR0406I Session 888 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(54619)). (SESSION: 888)
03/31/14 20:40:34 ANR0397I Session 888 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 888)
03/31/14 20:40:34 ANR0399I Session 888 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 888)
03/31/14 20:40:34 ANR0403I Session 888 ended for node TYDB1 (TDP Oracle HP).(SESSION: 888)
03/31/14 20:40:47 ANR0406I Session 889 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(54630)). (SESSION: 889)
03/31/14 20:40:47 ANR0397I Session 889 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 889)
03/31/14 20:40:47 ANR0511I Session 889 opened output volume 543ACKL5. (SESSION: 889)
03/31/14 20:43:23 ANR2121W ATTENTION: More than 74 MB of the database has changed and the last database backup was more than
24 hours ago. Use the BACKUP DB command to provide for database recovery.
03/31/14 20:44:32 ANR0514I Session 889 closed volume 543ACKL5. (SESSION:889)
03/31/14 20:44:32 ANR0399I Session 889 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 889)
03/31/14 20:44:32 ANR0480W Session 889 for node TYDB1 (TDP Oracle HP) terminated - connection with client severed. (SESSION:889)
03/31/14 21:32:30 ANR0406I Session 890 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(56427)). (SESSION: 890)
03/31/14 21:32:30 ANR0397I Session 890 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 890)
03/31/14 21:32:30 ANR0406I Session 890 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(56427)). (SESSION: 890)
03/31/14 21:32:30 ANR0397I Session 890 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 890)
03/31/14 21:32:30 ANE4994S (Session: 890, Node: TYDB_ASNODE) TDP Oracle HP
ANU0599 TDP for Oracle: (20382): =>(tydb1)
ANU2602E The object /orc10_db//93p4ifou_157_1 was not found on the TSM Server (SESSION: 890)
03/31/14 21:32:30 ANR0399I Session 890 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 890)
03/31/14 21:32:30 ANR0403I Session 890 ended for node TYDB1 (TDP Oracle HP).(SESSION: 890)
03/31/14 21:32:35 ANR0406I Session 891 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(56428)). (SESSION: 891)
03/31/14 21:32:35 ANR0397I Session 891 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 891)
03/31/14 21:32:35 ANR0399I Session 891 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 891)
……后面一直在重复开始及结束会话
在db1本机上cat tdpoerror.log如下：
03/31/14 21:32:47 sessSendVerb: Error sending Verb, rc: -50
03/31/14 21:32:47 ANS1017E Session rejected: TCP/IP connection failure
03/31/14 21:32:47 ANS1017E Session rejected: TCP/IP connection failure
03/31/14 21:32:47 sessSendVerb: Error sending Verb, rc: -50
03/31/14 21:32:52 ANS4994S TDP Oracle HP ANU0599 TDP for Oracle: (20382): =>(tydb1) ANU2602E The object /orc10_db//93p4ifou_157_1 was not found on the TSM Server
主机DB2目前关机，没有执行脚本，因此未知运行情况。
请问我应该如何处理？在线等高手回答！谢谢了！
近日在帮客户安装TSM并部署TDPO后，执行RMAN脚本时出现报错：
环境：
两台HP-UX 版本11.3
Oracle 10g并部署了RAC
TSM服务器设置：
已为两台HP-UX创建node，分别为db1及db2，参照IBM官方文档，为Oracle RAC部署TDP时还需要创建agent node，因此创建节点db_asnode，并关联db1与db2
db1与db2及db_asnode都已配置为backdel=yes archdel=yes
两台HP-UX的sbttest均能通过
在DB1上运行脚本如下：
{
allocate channel t1 device type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
set limit channel t1 kbytes 1900000;
backup database;
backup archivelog all delete input;
}
RMAN报错信息如下：
piece handle=93p4ifou_156_1 tag=TAG20140331T141806 comment=API Version 2.0,MMS Version 5.5.1.0
channel t1: starting piece 157 at 31-MAR-14
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 03/31/2014 21:44:42
ORA-19502: write error on file "93p4ifou_157_1", blockno 777473 (blocksize=1024)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1017E (RC-50) Session rejected: TCP/IP connection failure
登录TSM Server后q actlog如下：
……前面略去
3/31/14 20:35:12 ANR0406I Session 887 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(54410)). (SESSION: 887)
03/31/14 20:35:12 ANR0397I Session 887 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 887)
03/31/14 20:35:12 ANR0511I Session 887 opened output volume 543ACKL5.(SESSION: 887)
03/31/14 20:40:29 ANE4991I (Session: 887, Node: TYDB_ASNODE) TDP Oracle HP
ANU0599 TDP for Oracle: (20382): =>(tydb1)
ANU2535I File /orc10_db//93p4ifou_156_1 = 1945632768 bytes sent (SESSION: 887)
03/31/14 20:40:29 ANE4991I (Session: 887, Node: TYDB_ASNODE) TDP Oracle HP
ANU0599 TDP for Oracle: (20382): =>(tydb1)
ANU2526I Backup details for backup piece /orc10_db//93p4ifou_156_1 (database "ams").
Total bytes sent: 1945632768. Total processing time: 00:05:23.
Throughput rate: 5882.45Kb/Sec. Compressed: No . Encryption: None.LAN-Free: No. (SESSION: 887)
03/31/14 20:40:29 ANR0514I Session 887 closed volume 543ACKL5. (SESSION:887)
03/31/14 20:40:29 ANR0399I Session 887 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 887)
03/31/14 20:40:29 ANR0403I Session 887 ended for node TYDB1 (TDP Oracle HP). (SESSION: 887)
03/31/14 20:40:34 ANR0406I Session 888 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(54619)). (SESSION: 888)
03/31/14 20:40:34 ANR0397I Session 888 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 888)
03/31/14 20:40:34 ANR0399I Session 888 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 888)
03/31/14 20:40:34 ANR0403I Session 888 ended for node TYDB1 (TDP Oracle HP).(SESSION: 888)
03/31/14 20:40:47 ANR0406I Session 889 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(54630)). (SESSION: 889)
03/31/14 20:40:47 ANR0397I Session 889 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 889)
03/31/14 20:40:47 ANR0511I Session 889 opened output volume 543ACKL5. (SESSION: 889)
03/31/14 20:43:23 ANR2121W ATTENTION: More than 74 MB of the database has changed and the last database backup was more than
24 hours ago. Use the BACKUP DB command to provide for database recovery.
03/31/14 20:44:32 ANR0514I Session 889 closed volume 543ACKL5. (SESSION:889)
03/31/14 20:44:32 ANR0399I Session 889 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 889)
03/31/14 20:44:32 ANR0480W Session 889 for node TYDB1 (TDP Oracle HP) terminated - connection with client severed. (SESSION:889)
03/31/14 21:32:30 ANR0406I Session 890 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(56427)). (SESSION: 890)
03/31/14 21:32:30 ANR0397I Session 890 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 890)
03/31/14 21:32:30 ANR0406I Session 890 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(56427)). (SESSION: 890)
03/31/14 21:32:30 ANR0397I Session 890 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 890)
03/31/14 21:32:30 ANE4994S (Session: 890, Node: TYDB_ASNODE) TDP Oracle HP
ANU0599 TDP for Oracle: (20382): =>(tydb1)
ANU2602E The object /orc10_db//93p4ifou_157_1 was not found on the TSM Server (SESSION: 890)
03/31/14 21:32:30 ANR0399I Session 890 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 890)
03/31/14 21:32:30 ANR0403I Session 890 ended for node TYDB1 (TDP Oracle HP).(SESSION: 890)
03/31/14 21:32:35 ANR0406I Session 891 started for node TYDB1 (TDP Oracle HP) (Tcp/Ip 172.16.23.75(56428)). (SESSION: 891)
03/31/14 21:32:35 ANR0397I Session 891 for node TYDB1 has begun a proxy session for node TYDB_ASNODE. (SESSION: 891)
03/31/14 21:32:35 ANR0399I Session 891 for node TYDB1 has ended a proxy session for node TYDB_ASNODE. (SESSION: 891)
……后面一直在重复开始及结束会话
在db1本机上cat tdpoerror.log如下：
03/31/14 21:32:47 sessSendVerb: Error sending Verb, rc: -50
03/31/14 21:32:47 ANS1017E Session rejected: TCP/IP connection failure
03/31/14 21:32:47 ANS1017E Session rejected: TCP/IP connection failure
03/31/14 21:32:47 sessSendVerb: Error sending Verb, rc: -50
03/31/14 21:32:52 ANS4994S TDP Oracle HP ANU0599 TDP for Oracle: (20382): =>(tydb1) ANU2602E The object /orc10_db//93p4ifou_157_1 was not found on the TSM Server
主机DB2目前关机，没有执行脚本，因此未知运行情况。
请问我应该如何处理？在线等高手回答！谢谢了！
9 同行回答
后来开了PMR，IBM的800说，应该是tsm5.5版本的TDPO有bug，建议安装新版本的TSM SERVER与TDPO。感谢各位大大帮忙！ 收起
关注中！有没有什么进展！ 收起
归档日志备份
run{
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/oracle@eamdb1 ;
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG like '/archive/arch1/%' DELETE INPUT;
backup format 'D%T_cf_%t_%s_%p' current controlfile;
release channel ch00;
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/oracle@eamdb2 ;
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG like '/archive/arch2/%' DELETE INPUT;
backup format 'D%T_cf_%t_%s_%p' current controlfile;
release channel ch00;
｝ 收起
run{
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/oracle@eamdb1 ;
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG like '/archive/arch1/%' DELETE INPUT;
backup format 'D%T_cf_%t_%s_%p' current controlfile;
release channel ch00;
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' connect sys/oracle@eamdb2 ;
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG like '/archive/arch2/%' DELETE INPUT;
backup format 'D%T_cf_%t_%s_%p' current controlfile;
release channel ch00;
｝ 收起
verexists=1 verdeleted=0 retextra=0 retonly=0
最好是这样，保留版本用oracle的rman去控制 收起
最好是这样，保留版本用oracle的rman去控制 收起
这个你的备份不知道你那个copygroup组怎么定义，还有就数据的备份保留版，是按天，还是按冗余去算的，在就 ...wxswxs_8029 发表于 2014-4-1 17:10
copygroup是按standard定义的，后面加了retver=0 retinit=event retmin=0我会让DBA再按实际情况修改一下你的脚本，谢谢你！...
看看你TSM server 的dsmserv.opt文件里面要添加
COMMTIMEOUT 30000
IDLETIMEOUT 60
有没有，在就是有没有lanfree要是有，也需要在dsmsta.opt里面添加 收起
COMMTIMEOUT 30000
IDLETIMEOUT 60
有没有，在就是有没有lanfree要是有，也需要在dsmsta.opt里面添加 收起
这个你的备份不知道你那个copygroup组怎么定义，还有就数据的备份保留版，是按天，还是按冗余去算的，在就是备份的时候，一定要备份控制文件，还你开启了控制文件自动备份，在就是你的归档日志是放两边的，需要开启两个通道去备份归档日志run{
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system archive log current';
BACKUP
incremental level 0
format 'db_%s_%p_%t_%d'
DATABASE;
release channel ch00;
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
backup format 'D%T_cf_%t_%s_%p' current controlfile;
release channel ch00;
} 收起
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system archive log current';
BACKUP
incremental level 0
format 'db_%s_%p_%t_%d'
DATABASE;
release channel ch00;
allocate channel ch00 type sbt_tape parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
backup format 'D%T_cf_%t_%s_%p' current controlfile;
release channel ch00;
} 收起