SYBASE 12.5 恢复时出错,谁知道如何解决啊!(昨天已经自动恢复正常了原因还未明)

wx896138

到20060606中午,备份已经可以在另一台服务器上恢复了,但原因目前还不清楚,正在查,
但sysobjects还是存在error 2583,
dbcc tablealloc(sysobjects,full,fix)可修复该错误
其他原因还在查
******************************************************************
同一个备份文件在另外两台服务器上恢复都出现了相同的问题,而且之前能正常恢复的备份现在在这两台服务器上还是可以恢复的

而且其中一台服务器上我已经重装了SYBASE 12.5,然后恢复,但问题依旧
数据库9G,将备份恢复到另一个服务器上,backup.log提示以下出错,该数据库不能被打开
Backup Server: 3.42.1.1: LOAD is complete (database aaa).
Caution: You have set up this database to include space on disk 3 for both data and the transaction log. This can make recovery impossible if that disk fails.
Uninitialized logical page '770' was read while accessing object '2' in database '4'. Please contact Sybase Technical Support.
Database 'aaa' cannot be opened because a system index descriptor cannot be installed.
The SQL Server is terminating this process.

ERROR日志中错误记录如下:

00:00000:00028:2006/05/31 11:04:21.85 kernel pc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE0BC, 0x77EB1F54, 0x77E621F0, 0xFFFFFFFF)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE0BC, 0x021DDE74, 0x0000270F, 0x00000002)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x00A589EA pcstkwalk+ 0x204 (0x005A005A, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x00A58674 ucstkgentrace+ 0x224 (0x005A005A, 0x00000001, 0x021DE2BC, 0x004653AB)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x00A1431B ucbacktrace+ 0xab (0x00000006, 0x0000005C, 0x00000014, 0x00000001)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x0052457F sysind_handler+ 0x24 (0x00000006, 0x0000005C, 0x00000014, 0x00000001)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x004653AB ex_raise+ 0x2b3 (0x3D8E3178, 0x2161DEB0, 0x00000001, 0x00000001)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x005D0B93 wrongpage+ 0x2ec (0x2161DEB0, 0x00000004, 0x00000000, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x005CEBA5 getpage_with_validation+ 0x1355 (0x2161DEB0, 0x0052687A, 0x021DE66C, 0x021DE66C)
00:00000:00028:2006/05/31 11:04:21.87 kernel pc: 0x005C1666 apl_getnext+ 0x1f42 (0x2161DEB0, 0x021DE774, 0x21340958, 0x021DE6BC)
00:00000:00028:2006/05/31 11:04:21.89 kernel pc: 0x005BF2FD getnext+ 0x1ad (0x21340948, 0x00000002, 0x00000000, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:21.89 kernel [Handler pc: 0x0052455B sysind_handler installed by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x00521EC8 ind_ides_init+ 0xb95 (0x2161D6B0, 0x2161DAB0, 0x3C0A9A33, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x004AADBE des__syssetup+ 0x2a1 (0x2138E31C, 0x021DF340, 0x008B3824, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x004AAA07 des_sysbuild+ 0x3a8 (0x2138E31C, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x004A9B89 des_refreshall+ 0x17 (0x22A24DB0, 0x2003BF63, 0x00DD6818, 0x021DF7D0)
00:00000:00028:2006/05/31 11:04:21.90 kernel [Handler pc: 0x008B71F2 lddb_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x008B3824 lddb_main+ 0xde4 (0x00440001, 0x00000000, 0x77E76461, 0x00000190)
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x006FC496 s_execute+ 0x4336 (0x22BA9800, 0x00448195, 0x2003BF63, 0x00DD681
00:00000:00028:2006/05/31 11:04:21.90 kernel [Handler pc: 0x0072DF86 s_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x0072AFF2 sequencer+ 0x1792 (0x2161CD00, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.90 kernel pc: 0x0044356A tdsrecv_language+ 0x540 (0x0000005B, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:21.90 kernel [Handler pc: 0x00465417 hdl_backout installed by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:21.92 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:21.92 kernel pc: 0x00411C47 conn_hdlr+ 0x339e (0x2232E7E4, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:22.03 kernel pc: 0x00A09ED7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.03 kernel pc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x021DF874, 0x00000001)
00:00000:00028:2006/05/31 11:04:22.03 kernel end of stack trace, spid 28, kpid 5898330, suid 1
00:00000:00028:2006/05/31 11:04:22.14 server Error: 692, Severity: 20, State: 1
00:00000:00028:2006/05/31 11:04:22.14 server Uninitialized logical page '770' was read while accessing object '2' in database '4'. Please contact Sybase Technical Support.
00:00000:00028:2006/05/31 11:04:22.21 server Error: 952, Severity: 20, State: 5
00:00000:00028:2006/05/31 11:04:22.21 server Database 'xgl' cannot be opened because a system index descriptor cannot be installed.
00:00000:00028:2006/05/31 11:04:22.26 kernel ************************************
00:00000:00028:2006/05/31 11:04:22.28 kernel SQL causing error : LOAD DATABASE xgl from 'd:\bak\DUMP20060531N.dmp' WITH NOUNLOAD
00:00000:00028:2006/05/31 11:04:22.28 kernel ************************************
00:00000:00028:2006/05/31 11:04:22.29 server SQL Text: LOAD DATABASE xgl from 'd:\bak\DUMP20060531N.dmp' WITH NOUNLOAD
00:00000:00028:2006/05/31 11:04:22.31 kernel curdb = 1 pstat = 0x1011000 lasterror = 952
00:00000:00028:2006/05/31 11:04:22.31 kernel preverror = 0 transtate = 1
00:00000:00028:2006/05/31 11:04:22.31 kernel curcmd = 316 program =
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE328, 0x77EB1F54, 0x77E621F0, 0xFFFFFFFF)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE328, 0x021DE0E0, 0x0000270F, 0x00000002)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x00A589EA pcstkwalk+ 0x204 (0x005A005A, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x00A58674 ucstkgentrace+ 0x224 (0x005A005A, 0x00000001, 0x021DF2F4, 0x00DD681
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x00A1431B ucbacktrace+ 0xab (0x00000000, 0xFFFFFFFF, 0x021DE678, 0x004657A7)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x00406D71 terminate_process+ 0xb8f (0x021DE760, 0x0072F1F8, 0x00000009, 0x00000034)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x004657C4 close_network+ 0xc (0x00000009, 0x00000034, 0x00000014, 0x00000005)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x004657A7 hdl_default+ 0x38 (0x00000009, 0x00000034, 0x00000014, 0x00000005)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x0072F1F8 s_handle+ 0x1272 (0x00000009, 0x00000034, 0x00000014, 0x00000005)
00:00000:00028:2006/05/31 11:04:22.32 kernel pc: 0x004653AB ex_raise+ 0x2b3 (0x2161D6B0, 0x2161DAB0, 0x3C0A9A33, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x004AADE4 des__syssetup+ 0x2c7 (0x2138E31C, 0x021DF340, 0x008B3824, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x004AAA07 des_sysbuild+ 0x3a8 (0x2138E31C, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x004A9B89 des_refreshall+ 0x17 (0x22A24DB0, 0x2003BF63, 0x00DD6818, 0x021DF7D0)
00:00000:00028:2006/05/31 11:04:22.34 kernel [Handler pc: 0x008B71F2 lddb_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x008B3824 lddb_main+ 0xde4 (0x00440001, 0x00000000, 0x77E76461, 0x00000190)
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x006FC496 s_execute+ 0x4336 (0x22BA9800, 0x00448195, 0x2003BF63, 0x00DD681
00:00000:00028:2006/05/31 11:04:22.34 kernel [Handler pc: 0x0072DF86 s_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x0072AFF2 sequencer+ 0x1792 (0x2161CD00, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x0044356A tdsrecv_language+ 0x540 (0x0000005B, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:22.34 kernel [Handler pc: 0x00465417 hdl_backout installed by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel [Handler pc: 0x00688040 ut_handle installed by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x00411C47 conn_hdlr+ 0x339e (0x2232E7E4, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:22.34 kernel pc: 0x00A09ED7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.35 kernel pc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x021DF874, 0x00000001)
00:00000:00028:2006/05/31 11:04:22.35 kernel end of stack trace, spid 28, kpid 5898330, suid 1

[ 本帖最后由 wx896138 于 2006-6-8 08:37 编辑 ]

1017of

oops,seems like one of system table has corrupted at least.

wx896138

原帖由 1017of 于 2006-6-1 14:02 发表
oops,seems like one of system table has corrupted at least.

大哥啊,知道怎么解决啊,对了,原数据库现在还在正常运行,但现在所做出来的备份在恢复时都有以上错误.

chuxu

dbcc 试试？

1017of

if possible,you would transfer user data out of your database ASAP by some useful tools,such as bcp.object 2 points to the system table sysindexes.it is hard to estimate how it deeply gone from normal state.good luck.

RS9000

怀疑你现在运行的数据库已经有问题了

wx896138

原帖由 RS9000 于 2006-6-1 14:35 发表
怀疑你现在运行的数据库已经有问题了

是啊,我也是这样认为的,但现在我不知道是什么原因造成的,所以着急要找出解决办法,

正在运行的数据库的sysobjects 和 sysindexes两个表里数据也能读出



而且以前每次正常恢复数据库时,最后在ERROR日志中,会有这样一串提示,但数据库使用正常,我也查了每一个都对应一个索引,但不知是何原因?不知是否和现在的问题有关?

00:00000:00017:2006/05/31 16:35:22.35 kernel Reenlistment of DTC Transactions Complete
00:00000:00017:2006/05/31 16:38:34.87 server Cache binding for database '4', object '815394024', index '1' is being marked invalid in Sysattributes.
00:00000:00017:2006/05/31 16:38:34.91 server Cache binding for database '4', object '847394138', index '1' is being marked invalid in Sysattributes.
00:00000:00017:2006/05/31 16:38:34.91 server Cache binding for database '4', object '1550680622', index '3' is being marked invalid in Sysattributes.
00:00000:00017:2006/05/31 16:38:34.92 server Cache binding for database '4', object '1678681078', index '3' is being marked invalid in Sysattributes.

RS9000

做个DBCC检查看看

wx896138

刚才将最后一次正常备份的恢复后sysobjects表中数据和现在正在运行的数据库sysobjects表中的数据比较后发现,两者相差了一条 TYPE 为 RI 的记录(最后备份中多一条),查出是一个用户表的外键,

因为该用户表当时有两个外键,名称不同,但对应的参考表相同,列也相同,所以当时就删掉了其中一个
不知是否和这个操作有关

[ 本帖最后由 wx896138 于 2006-6-1 17:33 编辑 ]

dyhlx

怀疑数据库的一致性、完整性收到破坏；