增量恢复

donniejeck

ＯＳ：2003
ＤＢ：Ase12.53
增量恢复出错信息如下：
1> load tran WDZX from 'E:\dump\WDZX_log.dmp'
2> go
Backup Server session id is:  16.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'WDZX0831513C68   ' section number 1
mounted on disk file 'E:\dump\WDZX_log.dmp'
Msg 4305, Level 16, State 1:
Server 'CQ', Line 1:
Specified file 'dump device' is out of sequence. Current time stamp is Nov  8
2008 10:30:00:060PM while dump was from Nov  9 2008 10:30:00:483PM.
1>

load database的日志输出

Nov 14 09:23:54 2008: Backup Server/12.5.2/EBF 11798/P/NT (IX86)/OS 4.0/ase1252/2266/32-bit/OPT/Fri Mar 26 19:36:19 2004
Nov 14 09:23:54 2008: Confidential property of Sybase, Inc.
Copyright 1987, 2004
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'd:\CQ\CQ_BS.log'

Nov 14 09:23:54 2008: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 14 09:23:54 2008: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 14 09:23:54 2008: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 14 10:21:30 2008: Backup Server/12.5.3/EBF 13331 ESD#7/P/NT (IX86)/OS 4.0/ase1253/2344/32-bit/OPT/Thu Mar 23 21:42:16 2006
Nov 14 10:21:30 2008: Confidential property of Sybase, Inc.
Copyright 1987, 2006
Sybase, Inc.  All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc.   Use,  duplication or disclosure of the software and documentation by
the  U.S.  Government  is  subject  to  restrictions set forth in a license
agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
agreement  specifying  the  Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
Logging Backup Server messages in file 'd:\CQ\CQ_BS.log'

Nov 14 10:21:30 2008: Backup Server: 1.70.1.1: Configuring the maximum shared memory usage to 48 MB.
Nov 14 10:21:30 2008: Backup Server: 1.69.1.2: Configuring the number of service threads to 48.
Nov 14 10:21:30 2008: Backup Server: 1.70.1.3: Configuring the shared memory per stripe to 1048576 bytes.
Nov 14 10:22:42 2008: Backup Server: 6.28.1.1: Dumpfile name 'WDZX0831400348   ' section number 1 mounted on disk file 'E:\dump\WDZX.dmp'
Nov 14 10:28:21 2008: Backup Server: 6.28.1.1: Dumpfile name 'WDZX0831400348   ' section number 1 mounted on disk file 'E:\dump\WDZX.dmp'
Nov 14 10:29:58 2008: Backup Server: 6.28.1.1: Dumpfile name 'WDZX0831400348   ' section number 1 mounted on disk file 'E:\dump\WDZX.dmp'
Nov 14 10:30:11 2008: Backup Server: 4.58.1.1: Database WDZX: 464280 kilobytes LOADed.
Nov 14 10:30:28 2008: Backup Server: 4.58.1.1: Database WDZX: 928570 kilobytes LOADed.
Nov 14 10:30:45 2008: Backup Server: 4.58.1.1: Database WDZX: 1398142 kilobytes LOADed.
Nov 14 10:31:01 2008: Backup Server: 4.58.1.1: Database WDZX: 1853630 kilobytes LOADed.
Nov 14 10:31:20 2008: Backup Server: 4.58.1.1: Database WDZX: 2323086 kilobytes LOADed.
Nov 14 10:31:41 2008: Backup Server: 4.58.1.1: Database WDZX: 2777442 kilobytes LOADed.
Nov 14 10:31:57 2008: Backup Server: 4.58.1.1: Database WDZX: 3240102 kilobytes LOADed.
Nov 14 10:32:06 2008: Backup Server: 4.58.1.1: Database WDZX: 3716050 kilobytes LOADed.
Nov 14 10:32:14 2008: Backup Server: 4.58.1.1: Database WDZX: 4170556 kilobytes LOADed.
Nov 14 10:32:23 2008: Backup Server: 4.58.1.1: Database WDZX: 4646186 kilobytes LOADed.
Nov 14 10:32:31 2008: Backup Server: 4.58.1.1: Database WDZX: 5100370 kilobytes LOADed.
Nov 14 10:32:39 2008: Backup Server: 4.58.1.1: Database WDZX: 5554876 kilobytes LOADed.
Nov 14 10:32:48 2008: Backup Server: 4.58.1.1: Database WDZX: 6030952 kilobytes LOADed.
。。。。。。。。。。。。。。。。。。。。。。。。
Nov 14 10:45:52 2008: Backup Server: 4.58.1.1: Database WDZX: 39799430 kilobytes LOADed.
Nov 14 10:46:12 2008: Backup Server: 4.58.1.1: Database WDZX: 40264604 kilobytes LOADed.
Nov 14 10:46:32 2008: Backup Server: 4.58.1.1: Database WDZX: 40730290 kilobytes LOADed.
Nov 14 10:46:52 2008: Backup Server: 4.58.1.1: Database WDZX: 41195464 kilobytes LOADed.
Nov 14 10:47:12 2008: Backup Server: 4.58.1.1: Database WDZX: 41649820 kilobytes LOADed.
Nov 14 10:47:32 2008: Backup Server: 4.58.1.1: Database WDZX: 42114994 kilobytes LOADed.
Nov 14 10:47:52 2008: Backup Server: 4.58.1.1: Database WDZX: 42580168 kilobytes LOADed.
Nov 14 10:48:12 2008: Backup Server: 4.58.1.1: Database WDZX: 43045342 kilobytes LOADed.
Nov 14 10:48:32 2008: Backup Server: 4.58.1.1: Database WDZX: 43510516 kilobytes LOADed.
Nov 14 10:48:52 2008: Backup Server: 4.58.1.1: Database WDZX: 43965256 kilobytes LOADed.
Nov 14 10:49:04 2008: Backup Server: 4.58.1.1: Database WDZX: 44441842 kilobytes LOADed.
Nov 14 10:49:05 2008: Backup Server: 4.58.1.1: Database WDZX: 44533516 kilobytes LOADed.
Nov 14 10:49:05 2008: Backup Server: 3.42.1.1: LOAD is complete (database WDZX).
Nov 14 11:19:10 2008: Backup Server: 6.28.1.1: Dumpfile name 'WDZX0831513C68   ' section number 1 mounted on disk file 'E:\dump\WDZX_log.dmp'

donniejeck

select getdate()
Nov   14    2008    12:02PM

chuxu

Specified file 'dump device' is out of sequence. Current time stamp is Nov  8
2008 10:30:00:060PM while dump was from Nov  9 2008 10:30:00:483PM.

是否在这个dump之前还有一个增量的dump？

donniejeck

原帖由 chuxu 于 2008-11-14 12:29 发表
Specified file 'dump device' is out of sequence. Current time stamp is Nov  8
2008 10:30:00:060PM while dump was from Nov  9 2008 10:30:00:483PM.

是否在这个dump之前还有一个增量的dump？

不能呀，因为我的备份策略是这样的，一个礼拜的礼拜天做一次数据的全备，其它礼拜一到礼拜六都做增量。这周二的时候，系统出现了问题。恢复的时候先恢复礼拜天的全备，再恢复礼拜一的增量，发现增量恢复昌无效的。所以丢了两天的数据，现在在新安装的服务器上做增量恢复测试，依然恢复不了，所以发个帖子，想请大家指正一下。

tyrone.dev

有可能是你在星期天备份数据库后面，被人截断了日志吧