论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2004-02-20 14:31 |只看该作者 |倒序浏览

数据库备份时生成pos.dmp,pos[1].dmp,pos[2].dmp三个备份文件。
恢复数据库命令：
load database pos from "/u/backup/pos.dmp" stripe on "/u/backup/pos[1].dmp" stripe on '/u/backup/pos[2].dmp"

提示错误信息如下：

00:04/02/20 11:21:52.56 kernel  Initializing virtual device 12, '/sybase/shopdata/shopdata_shop.dat'
00:04/02/20 11:21:52.56 kernel  Virtual device 12 started using standard unix i/o.
00:04/02/20 11:22:55.17 kernel  Initializing virtual device 13, '/sybase/shopdata/shopdata_shop1.dat'
00:04/02/20 11:22:55.17 kernel  Virtual device 13 started using standard unix i/o.
00:04/02/20 11:23:26.75 kernel  Initializing virtual device 14, '/sybase/shopdata/shopdata_shop2.dat'
00:04/02/20 11:23:26.75 kernel  Virtual device 14 started using standard unix i/o.
00:04/02/20 11:24:05.12 kernel  Initializing virtual device 15, '/sybase/shoplog/shoplog_shop.dat'
00:04/02/20 11:24:05.12 kernel  Virtual device 15 started using standard unix i/o.
00:04/02/20 11:34:28.91 server  Recovery dbid 6 ckpt (502109,2)
00:04/02/20 11:34:28.91 server  Recovery no active transactions before ckpt.
00:04/02/20 11:46:50.22 server  Recovery dbid 5 ckpt (1017703,6)
00:04/02/20 11:46:50.23 server  Recovery no active transactions before ckpt.
00:04/02/20 12:58:54.65 kernel  ksmask__rpacket: Invalid tdslength value 29709, kpid: 1376277

请各位高手赐教！

文库|博客

RS9000

腰缠万贯

论坛徽章:: 1

2楼 [报告]

发表于 2004-02-20 16:59 |只看该作者

sybase备份文件无法恢复

你提供的错误日志不对吧，这是SYBASE的启动日志呀。。

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

苍海游龙

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2004-02-23 10:13 |只看该作者

sybase备份文件无法恢复

错误日志如下：VOL1                                                                         3
HDR1shop033360D001 00010100010000000100 03336 03336 000000Sybase  0D001
HDR2F552960204801 shop                         00
Feb 23 09:56:12 2004: Backup Server: 1.14.2.2: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Feb 23 09:56:12 2004: Backup Server: 6.32.2.3: /sybase/backup/shop.dmp: volume not valid or not requested (server: , session id: 22.)
Feb 23 09:56:12 2004: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Feb 23 09:56:12 2004: Backup Server: 6.32.2.3: /sybase/backup/shop[1].dmp: volume not valid or not requested (server: , session id: 22.)
Feb 23 09:56:12 2004: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
Feb 23 09:56:12 2004: Backup Server: 6.32.2.3: /sybase/backup/shop[2].dmp: volume not valid or not requested (server: , session id: 22.)
Feb 23 09:56:12 2004: Backup Server: 1.14.2.4: Unrecoverable I/O or volume error.  This DUMP or LOAD session must exit.
望回复