注册登录
提 问
English中文版
互联网服务TSMDb2

TSM db2数据库备份失败【已经解决】

版本信息  TSM 6.1 AIX 5.3   db2 数据库备份走的是脚本信息，脚本的输出结果如下 ：

这是FIS系统的日志  FIS65&FIS84的

下面是FIS65的日志  是2012-1-30号的


Log Contents /ap/fh/fhdba49/journ/log/fhdbbacktsm.fh497901.20120130 at l79fis65 - All Lines - Search
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: ==> Script-Start <==
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Used parameters:
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Database: FH497901
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: DB working directory: /ap/fh/fhdba49/fh4979ab/dbadm/ufhdba49/NODE0000/SQL00001
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: SQLOG compression without a backup: FALSE
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Additional backup: TSM
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Capture support: FALSE
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Logfile offset: 4
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Expected number of backup image files: 12
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: File compression: FALSE
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Compression program used: /usr/bin/gzip
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: ** => Start database backup of FH4979AB <= **
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Replication is not running: Capture logfiles will NOT be CHECKED
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Compressing of old backup files and moving to /ap/fh/fhdba49/fh4979ab/copy/archive
2012-01-30 04:30:05 l79fis65 fhdbbacktsm[1433706] ufhdba49: Start database backup to /ap/fh/fhdba49/fh4979ab/copy
BACKUP DATABASE FH4979AB ONLINE TO /ap/fh/fhdba49/fh4979ab/copy COMPRESS INCLUDE LOGS

Backup successful. The timestamp for this backup image is : 20120130043005


2012-01-30 06:20:13 l79fis65 fhdbbacktsm[1433706] ufhdba49: End of backup : Mon Jan 30 06:20:13 BEIST 2012
2012-01-30 06:20:13 l79fis65 fhdbbacktsm[1433706] ufhdba49: Backup database finished successfully
2012-01-30 06:20:13 l79fis65 fhdbbacktsm[1433706] ufhdba49: Configuration data will be saved
2012-01-30 06:20:14 l79fis65 fhdbbacktsm[1433706] ufhdba49: Saving backup to archive media
Saving Database Backup to TSM
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 6, Release 2, Level 1.0
Client date/time: 01/30/12 06:20:14
(c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved.

Node Name: L79FIS65
Session established with server TSMCC: AIX
Server Version 6, Release 2, Level 1.0
Server date/time: 01/30/12 06:20:14 Last access: 01/29/12 06:58:40

Archive function invoked.

Directory--> 4,096 /ap/fh/fhdba49/fh4979ab/copy/ [Sent]
Directory--> 256 /ap/fh/fhdba49/fh4979ab/copy/archive [Sent]
Directory--> 256 /ap/fh/fhdba49/fh4979ab/copy/offline [Sent]
Normal File--> 1,366 /ap/fh/fhdba49/fh4979ab/copy/dsmerror.log [Sent]
Normal File--> 116 /ap/fh/fhdba49/fh4979ab/copy/fh4979ab.backup [Sent]
Normal File--> 2,812 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.cfexp [Sent]
Normal File--> 7,200 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.fh4979ab.dbcfg.out [Sent]
Normal File--> 1,898 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.fh4979ab.tc [Sent]
Normal File--> 2,363 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.fh4979ab.ts [Sent]
ANS1114I Waiting for mount of offline media.
Retry # 1 Directory--> 4,096 /ap/fh/fhdba49/fh4979ab/copy/ [Sent]
Retry # 1 Directory--> 256 /ap/fh/fhdba49/fh4979ab/copy/archive [Sent]
Retry # 1 Directory--> 256 /ap/fh/fhdba49/fh4979ab/copy/offline [Sent]
Retry # 1 Normal File--> 1,366 /ap/fh/fhdba49/fh4979ab/copy/dsmerror.log [Sent]
Retry # 1 Normal File--> 116 /ap/fh/fhdba49/fh4979ab/copy/fh4979ab.backup [Sent]
Retry # 1 Normal File--> 2,812 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.cfexp [Sent]
Retry # 1 Normal File--> 7,200 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.fh4979ab.dbcfg.out [Sent]
Retry # 1 Normal File--> 1,898 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.fh4979ab.tc [Sent]
Retry # 1 Normal File--> 2,363 /ap/fh/fhdba49/fh4979ab/copy/p49f6579.fh4979ab.ts [Sent]
Normal File--> 71,886,393,344 /ap/fh/fhdba49/fh4979ab/copy/FH4979AB.0.ufhdba49.NODE0000.CATN0000.20120130043005.001 [Sent]
Normal File--> 71,854,661,632 /ap/fh/fhdba49/fh4979ab/copy/archive/FH4979AB.0.ufhdba49.NODE0000.CATN0000.20120129043006.001 ** Unsuccessful **
ANS1114I Waiting for mount of offline media.
Retry # 1 Normal File--> 71,854,661,632 /ap/fh/fhdba49/fh4979ab/copy/archive/FH4979AB.0.ufhdba49.NODE0000.CATN0000.20120129043006.001 Read Failure
Retry # 2 Normal File--> 0 /ap/fh/fhdba49/fh4979ab/copy/archive/FH4979AB.0.ufhdba49.NODE0000.CATN0000.20120129043006.001 ** Unsuccessful **
ANS1228E Sending of object '/ap/fh/fhdba49/fh4979ab/copy/archive/FH4979AB.0.ufhdba49.NODE0000.CATN0000.20120129043006.001' failed
ANS4005E Error processing '/ap/fh/fhdba49/fh4979ab/copy/archive/FH4979AB.0.ufhdba49.NODE0000.CATN0000.20120129043006.001': file not found
ANS1803E Archive processing of '/ap/fh/fhdba49/fh4979ab/copy/*' finished with failures.

Session established with server TSMCC: AIX
Server Version 6, Release 2, Level 1.0
Server date/time: 01/30/12 10:45:14 Last access: 01/30/12 10:45:14


Total number of objects inspected: 11
Total number of objects archived: 10
Total number of objects updated: 0
Total number of objects rebound: 0
Total number of objects deleted: 0
Total number of objects expired: 0
Total number of objects failed: 1
Total number of bytes inspected: 139.78 GB
Total number of bytes transferred: 139.78 GB
LanFree data bytes: 66.94 GB
Data transfer time: 15,224.11 sec
Network data transfer rate: 9,628.02 KB/sec
Aggregate data transfer rate: 9,219.22 KB/sec
Objects compressed by: 0%
Total data reduction ratio: 0.00%
Elapsed processing time: 04:24:59
ERROR Saving Database backup to TSM Server = Result Code VRC is 4
Check backup Manually
2012-01-30 10:45:15 l79fis65 fhdbbacktsm[1433706] ufhdba49: Backup image file(s) could not be saved (RC= 2)
2012-01-30 10:45:15 l79fis65 fhdbbacktsm[1433706] ufhdba49: SQLOG files will be saved to backup media
Saving Database Log Files To The TSM Server
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 6, Release 2, Level 1.0
Client date/time: 01/30/12 10:45:16
(c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved.

Node Name: L79FIS65
Session established with server TSMCC: AIX
Server Version 6, Release 2, Level 1.0
Server date/time: 01/30/12 10:45:16 Last access: 01/30/12 10:45:14

Archive function invoked.

Directory--> 8,192 /ap/fh/fhdba49/fh4979ab/sqlog/NODE0000 [Sent]
Normal File--> 16,392,192 /ap/fh/fhdba49/fh4979ab/sqlog/NODE0000/S0355679.LOG ** Unsuccessful **
ANS1114I Waiting for mount of offline media.
Retry # 1 Directory--> 8,192 /ap/fh/fhdba49/fh4979ab/sqlog/NODE0000 [Sent]
Retry # 1 Normal File--> 16,392,192 /ap/fh/fhdba49/fh4979ab/sqlog/NODE0000/S0355679.LOG [Sent]

Normal File--> 512 /ap/fh/fhdba49/fh4979ab/sqlog/NODE0000/SQLLPATH.TAG [Sent]
Normal File--> 0 /ap/fh/fhdba49/fh4979ab/sqlog/NODE0000/dsmerror.log [Sent]


Archive processing of '/ap/fh/fhdba49/fh4979ab/sqlog/NODE0000/*' finished without failure.


Total number of objects inspected: 143
Total number of objects archived: 143
Total number of objects updated: 0
Total number of objects rebound: 0
Total number of objects deleted: 0
Total number of objects expired: 0
Total number of objects failed: 0
Total number of bytes inspected: 2.08 GB
Total number of bytes transferred: 2.08 GB
LanFree data bytes: 2.08 GB
Data transfer time: 26.80 sec
Network data transfer rate: 81,559.05 KB/sec
Aggregate data transfer rate: 43,424.06 KB/sec
Objects compressed by: 0%
Total data reduction ratio: 0.00%
Elapsed processing time: 00:00:50
2012-01-30 10:46:08 l79fis65 fhdbbacktsm[1433706] ufhdba49: ** => End of log file backup : 20120130104608 @ @ @ @ @ <= **
2012-01-30 10:46:08 l79fis65 fhdbbacktsm[1433706] ufhdba49: 1st log file to keep: S0355710.LOG
2012-01-30 10:46:08 l79fis65 fhdbbacktsm[1433706] ufhdba49: Compressing of old backup files and moving to /ap/fh/fhdba49/fh4979ab/copy/archive
2012-01-30 10:46:08 l79fis65 fhdbbacktsm[1433706] ufhdba49: SQLOG files will be compressed
0000//S0355694.LOG.gz
00//S0355709.LOG.gz
2012-01-30 10:46:45 l79fis65 fhdbbacktsm[1433706] ufhdba49: Logfile information will be archived
rm: Removing /ap/fh/fhdba49/fh4979ab/copy/fh4979ab.backup.bck
rm: Removing /ap/fh/fhdba49/tmp/fhdbbacktsm.fh4979ab
2012-01-30 10:46:45 l79fis65 fhdbbacktsm[1433706] ufhdba49: ** => End of database-backup of FH4979AB <= **
2012-01-30 10:46:45 l79fis65 fhdbbacktsm[1433706] ufhdba49: ==> RC unequals 0 (2) <== Logfile /ap/fh/fhdba49/journ/log/fhdbbacktsm.fh497901.20120130
2012-01-30 10:46:45 l79fis65 fhdbbacktsm[1433706] ufhdba49: ==> Script-End <==






急，谢谢各位帮忙的人，如需其他信息请回复我，谢谢！

...
关注1
评论
参与9

8同行回答
|
按赞同排序
按时间排序

riridulumriridulum系统工程师神州数码
关了吧，一最近有快rmt3的 VTL内的磁盘告警，二 近期有网络断的现象。今天我查看了备份都是成功的‘谢谢几位版主的热心回事，  就写问题已经解决吧！谢谢你们！显示全部
关了吧，一最近有快rmt3的 VTL内的磁盘告警，二 近期有网络断的现象。今天我查看了备份都是成功的‘谢谢几位版主的热心回事，  就写问题已经解决吧！谢谢你们！收起
互联网服务 · 2012-02-01
浏览1312
评论
riridulumriridulum系统工程师神州数码
1，q path tsm: TSMCC>q path Source Name     Source Type     Destination     Destination     On-Line                 &...显示全部
1，q path
tsm: TSMCC>q path

Source Name     Source Type     Destination     Destination     On-Line
                                Name            Type            
-----------     -----------     -----------     -----------     -------
TSMCC           SERVER          I2000           LIBRARY         Yes   
TSMCC           SERVER          TSM_DRV01       DRIVE           Yes   
TSMCC           SERVER          TSM_DRV02       DRIVE           Yes   
TSMCC           SERVER          TSM_DRV03       DRIVE           Yes   
TSMCC           SERVER          TSM_DRV04       DRIVE           Yes   
L79FIS65_S-     SERVER          TSM_DRV01       DRIVE           Yes   
TA                                                                    
L79FIS65_S-     SERVER          TSM_DRV02       DRIVE           Yes   
TA                                                                    
L79FIS65_S-     SERVER          TSM_DRV03       DRIVE           Yes   
TA                                                                    
L79FIS65_S-     SERVER          TSM_DRV04       DRIVE           Yes   
TA                                                                    
L79FIS75_S-     SERVER          TSM_DRV01       DRIVE           Yes   
TA                                                                    
L79FIS75_S-     SERVER          TSM_DRV02       DRIVE           Yes   
TA                                                                    
L79FIS75_S-     SERVER          TSM_DRV03       DRIVE           Yes   
q

2.q drive
tsm: TSMCC>q drive

Library Name     Drive Name       Device Type     On-Line            
------------     ------------     -----------     -------------------
I2000            TSM_DRV01        LTO             Yes               
I2000            TSM_DRV02        LTO             Yes               
I2000            TSM_DRV03        LTO             Yes               
I2000            TSM_DRV04        LTO             Yes         
3,q actlog 请稍候我正在比对命令   输出很长收起
互联网服务 · 2012-01-31
浏览1333
评论
colinscolins联盟成员系统工程师金融行业
q actlog看看。q pathq drive这个只能说明问题是出在你的TSM而不是虚拟带库上。显示全部
q actlog看看。
q path
q drive
这个只能说明问题是出在你的TSM而不是虚拟带库上。收起
银行 · 2012-01-31
浏览1294
评论
riridulumriridulum系统工程师神州数码
在备份的过程中带库介质从online变成了offline，你检查一下备份设备好像在移动备份数据的时候出错了，检查一下备份设备 首先感谢两位版主的回答， 1，在备份的过程中带库介质从online变成了offline，你检查一下备份设备  请问我需要什么样子的命令可以查询到 带库介质的...显示全部
在备份的过程中带库介质从online变成了offline，你检查一下备份设备

好像在移动备份数据的时候出错了，检查一下备份设备


首先感谢两位版主的回答，
1，在备份的过程中带库介质从online变成了offline，你检查一下备份设备  
请问我需要什么样子的命令可以查询到 带库介质的状态，或者 应该从什么地方入手查找下去？
2，好像在移动备份数据的时候出错了，检查一下备份设备
不确定你说的check下设备是否是检查带库？ 刚才去找了VTL的管理员？  除了TSM外 其他的备份没有问题（HP的备份软件），备份都能正常运行。收起
互联网服务 · 2012-01-31
浏览1234
评论
yukay2010yukay2010系统工程师神州数码系统集成服务有限公司
ls两位大拿高人啊！显示全部
ls两位大拿高人啊！收起
系统集成 · 2012-01-31
浏览1239
评论
szhangkangszhangkang项目经理aaa
在备份的过程中带库介质从online变成了offline，你检查一下备份设备显示全部
在备份的过程中带库介质从online变成了offline，你检查一下备份设备收起
互联网服务 · 2012-01-31
浏览1258
评论
dbchipdbchip其他WORLD
好像在移动备份数据的时候出错了，检查一下备份设备显示全部
好像在移动备份数据的时候出错了，检查一下备份设备收起
政府机关 · 2012-01-31
浏览1277
评论
riridulumriridulum系统工程师神州数码
下面为FIS84的2012-1-31日备份日志Log Contents /ap/fh/fhdba04/journ/log/fhdbbacktsm.fh047901.20120131 at l79fis84 - All Lines - Search2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: ==> Script-Start Start database backup of FH0479AB End of...显示全部
下面为FIS84的2012-1-31日备份日志
Log Contents /ap/fh/fhdba04/journ/log/fhdbbacktsm.fh047901.20120131 at l79fis84 - All Lines - Search

2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: ==> Script-Start <==
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Used parameters:
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Database: FH047901
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: DB working directory: /ap/fh/fhdba04/fh0479ab/dbadm/ufhdba04/NODE0000/SQL00001
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: SQLOG compression without a backup: FALSE
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Additional backup: TSM
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Capture support: FALSE
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Logfile offset: 4
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Expected number of backup image files: 12
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: File compression: FALSE
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Compression program used: /usr/bin/gzip
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: ** => Start database backup of FH0479AB <= **
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Replication is not running: Capture logfiles will NOT be CHECKED
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Compressing of old backup files and moving to /ap/fh/fhdba04/fh0479ab/copy/archive
2012-01-31 03:30:05 l79fis84 fhdbbacktsm[774332] ufhdba04: Start database backup to /ap/fh/fhdba04/fh0479ab/copy
BACKUP DATABASE FH0479AB ONLINE TO /ap/fh/fhdba04/fh0479ab/copy COMPRESS INCLUDE LOGS

Backup successful. The timestamp for this backup image is : 20120131033005


2012-01-31 04:15:10 l79fis84 fhdbbacktsm[774332] ufhdba04: End of backup : Tue Jan 31 04:15:10 BEIST 2012
2012-01-31 04:15:10 l79fis84 fhdbbacktsm[774332] ufhdba04: Backup database finished successfully
2012-01-31 04:15:11 l79fis84 fhdbbacktsm[774332] ufhdba04: Configuration data will be saved
2012-01-31 04:15:11 l79fis84 fhdbbacktsm[774332] ufhdba04: Saving backup to archive media
Saving Database Backup to TSM
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
Client Version 6, Release 2, Level 1.0
Client date/time: 01/31/12 04:15:11
(c) Copyright by IBM Corporation and other(s) 1990, 2010. All Rights Reserved.

Node Name: L79FIS84
Session established with server TSMCC: AIX
Server Version 6, Release 2, Level 1.0
Server date/time: 01/31/12 04:15:11 Last access: 01/30/12 08:12:50

Archive function invoked.

ANS1898I ***** Processed 500 files *****


N
rm: Removing /ap/fh/fhdba04/fh0479ab/copy/fh0479ab.backup.bck
rm: Removing /ap/fh/fhdba04/tmp/fhdbbacktsm.fh0479ab
2012-01-31 08:09:40 l79fis84 fhdbbacktsm[774332] ufhdba04: ** => End of database-backup of FH0479AB <= **
2012-01-31 08:09:40 l79fis84 fhdbbacktsm[774332] ufhdba04: ==> RC unequals 0 (3) <== Logfile /ap/fh/fhdba04/journ/log/fhdbbacktsm.fh047901.20120131
2012-01-31 08:09:40 l79fis84 fhdbbacktsm[774332] ufhdba04: ==> Script-End <==收起
互联网服务 · 2012-01-31
浏览1272
评论

提问者

riridulum
riridulum003
系统工程师神州数码
擅长领域： 数据库，中间件，服务器
关注2
回答37
评论85

相关问题

  • aix小机上的大数据量DB2数据库备份方案选型？
  • 公司使用的是db2数据库，但目前外部环境使用的已经非常少。我到底要不要再深入学习DB2？
  • 公司目前想去db2数据库，正在选型数据库，各位同行有什么好推荐，要求对存储过程兼容比较好？
  • 将商业数据库Oracle、DB2、SQL Server上的应用，迁移到国产数据库，有哪些风险点？
  • 国产数据库对DB2的支持？

    • 相关资料

  • DB2 PureScale V10.5 on AIX 7.2 安装实施
  • TSM7.1.6部署工艺手册
  • tsm tdpo for erp6.3 安装配置记录
  • DB2数据库备份与恢复
  • tsm for aix 6.1安装指南

    • 相关文章

  • DB2 V11.5数据库及日志内置Power ZLIB硬件加速压缩与加密备份
  • 招聘DB2驻场运维人员
  • DB2 嵌入式 SQL(SQC) 编译问题分析

    • 问题状态

  • 发布时间：2012-01-31
  • 关注会员：1 人
  • 问题浏览：7111
  • 最近回答：2012-02-01

    • 关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们
    © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30

    X社区推广