新手用ASE-15.0恢复数据库故障

zm852

在建库FOXHIS（2G）后，恢复数据时报空间小了，NEED 3000MB。。但是data.dat文件才280M，这是为什么哦？不得已，扩库到4G后，再load database 结果又报这个错，大家看看，帮忙一起解决这个问题。。谢
___________________________________________________________
Backup Server: 3.42.1.1: LOAD is complete (database foxhis).
Caution:  You have set up this database to include space on disk 58 for both
data and the transaction log.  This can make recovery impossible if that disk
fails.
All dumped pages have been loaded. ASE is now clearing pages above page 1536000,
which were not present in the database just loaded.
ASE has finished clearing database pages.
Msg 3484, Level 16, State 1:
Server 'SYBASE', Line 1:
Recovery encountered an error in acquiring locks for reinstantiated
transactions. Please consult the Adaptive Server errorlog for further
information as to the cause.
))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))以上是Load完成时的样子，然后我想打开数据库，结果又出现了以下的Error!!
1> use foxhis
2> go
Msg 930, Level 14, State 1:
Server 'SYBASE', Line 1:
Database 'foxhis' cannot be opened because either an earlier system termination
left LOAD DATABASE incomplete or the database is created with 'for load' option.
Load the database or contact a user with System Administrator (SA) role.
？？？
不明白了。。。

zm852

高手们,帮帮忙啊`~

action929

load没有成功
看下你的日志里面有没有抱什么错

zm852

00:00000:00014:2006/11/23 02:08:12.20 kernel  SQL causing error : load database wolf from '/home/safe/foxdump.dat'

00:00000:00014:2006/11/23 02:08:12.20 kernel  ************************************
00:00000:00014:2006/11/23 02:08:12.20 server  SQL Text: load database wolf from '/home/safe/foxdump.dat'
00:00000:00014:2006/11/23 02:08:12.20 kernel  curdb = 1 tempdb = 2 pstat = 0x1010000
00:00000:00014:2006/11/23 02:08:12.20 kernel  lasterror = 8241 preverror = 930 transtate = 1
00:00000:00014:2006/11/23 02:08:12.20 kernel  curcmd = 316 program = isql                          
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08be3207 pcstkwalk+0x24b(0x0xb4dbcaf4, 0x0xb4dbc8a4, 0x0x0000270f, 0x0x00000002, 0x0xb4dbc8a4)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08be2e66 ucstkgentrace+0x13a(0x0x00110011, 0x0x00000002, 0x0x0000270f, 0x(nil), 0x(nil))
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08b9440d ucbacktrace+0x5d(0x(nil), 0x0x00000001, 0x0x000003a2, 0x0x00000001, 0x0x20202020)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x082c76c8 terminate_process+0x924(0x(nil), 0x0xffffffff, 0x0xb4dbd1ec, 0x0x08316f16, 0x0x00002031)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08316f4b close_network+0xf(0x(nil), 0x0xb5a99048, 0x0xb4dbd2dc, 0x0x08645d82, 0x0x00000052)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08316f2d hdl_default+0x45(0x0x00000052, 0x0x00000029, 0x0x00000015, 0x0x00000001, 0x0xb4dbd314)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08645d82 s_handle+0x53a(0x0x00000052, 0x0x00000029, 0x0x00000015, 0x0x00000001, 0x0xb4dbd314)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x083167eb ex_raise+0x15f(0x0x00000052, 0x0x00000029, 0x0x00000015, 0x0x00000001, 0x0x00000004)
00:00000:00014:2006/11/23 02:08:12.32 kernel  pc: 0x0x08387e47 des_refreshall+0x47(0x0xb5861600, 0x0xb5861600, 0x(nil), 0x0x00176fff, 0x0xb624d000)
00:00000:00014:2006/11/23 02:08:12.35 kernel  [Handler pc: 0x0x08a147c4 lddb_handle installed by the following function:-]
00:00000:00014:2006/11/23 02:08:12.35 kernel  pc: 0x0x08a11727 lddb_main+0x75b(0x0xb62645d8, 0x0xb4dbdf60, 0x0xb4dbdf64, 0x(nil), 0x(nil))
00:00000:00014:2006/11/23 02:08:12.35 kernel  pc: 0x0x08627d8b s_execute+0x41f7(0x(nil), 0x(nil), 0x0x00000001, 0x0xb5a99048, 0x(nil))
00:00000:00014:2006/11/23 02:08:12.35 kernel  [Handler pc: 0x0x08645848 s_handle installed by the following function:-]
00:00000:00014:2006/11/23 02:08:12.35 kernel  pc: 0x0x08641b92 sequencer+0x1ba(0x0xb6264800, 0x0xb5a99048, 0x0xb4dbe43c, 0x0x08351c0f, 0x0xb5fe2f40)
00:00000:00014:2006/11/23 02:08:12.35 kernel  pc: 0x0x082ef84f tdsrecv_language+0xab(0x(nil), 0x0x00000001, 0x0xb4dbea5c, 0x0x082fcff3, 0x(nil))
00:00000:00014:2006/11/23 02:08:12.37 kernel  [Handler pc: 0x0x085a4df0 ut_handle installed by the following function:-]
00:00000:00014:2006/11/23 02:08:12.37 kernel  pc: 0x0x082fd22c conn_hdlr+0x948(0x0x00000005, 0x0xb4dbea70, 0x0x895eed31, 0x(nil), 0x(nil))
00:00000:00014:2006/11/23 02:08:12.37 kernel  pc: 0x0x08bd63bc kpexit(0x(nil), 0x(nil), 0x(nil), 0x0xb4c9e900, 0x0x00000012)
00:00000:00014:2006/11/23 02:08:12.37 kernel  end of stack trace, spid 14, kpid 1114129, suid 1
00:00000:00017:2006/11/23 02:12:21.38 kernel  Deactivating virtual device 52, '/home/data/foxhis.dat'.
00:00000:00017:2006/11/23 02:13:37.01 kernel  Initializing virtual device 58, '/home/data/foxhis.dat' with dsync 'on'.
00:00000:00017:2006/11/23 02:13:37.01 kernel  Virtual device 58 started using asynchronous i/o.
00:00000:00017:2006/11/23 02:13:37.02 kernel  Initializing device /home/data/foxhis.dat from offset 0 with zeros.
00:00000:00017:2006/11/23 02:14:02.01 kernel  Finished initialization.
_____________
HELP~~~~

Blackrose

两个建议：
1. 使用DBCC检查一下原备份的数据库，有问题解决问题。如果没有问题重新dump一次，load试试
2. 安装数据库最新的补丁

zm852

我原来的数据库文件是在Sybase 11.03下的,现在数据库服务器版本是SYBASE ASE 15.0了,不知道是不是有影响?
按道理应该是高版本的向下兼容吧...

2BeSybPro

Sybase 11.03下的数据库不能直接 load to SYBASE ASE 15.0

zm852

哦.这样子哦..