SYBASE 12.5 恢复时出错,谁知道如何解决啊!

显示全部楼层 · 2007-9-26 17:01:04

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.
数据库9G,将备份恢复到另一个服务器上,提示以上出错,该数据库不能被打开

千问 · 2007-9-26 17:01:04

不太清楚，看样子好像备份有问题。

千问 · 2007-9-26 17:01:04

接一楼,以下是恢复时ERROR日志中错误记录,
00:00000:00028:2006/05/31 11:04:21.85 kernelpc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE0BC, 0x77EB1F54, 0x77E621F0, 0xFFFFFFFF)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE0BC, 0x021DDE74, 0x0000270F, 0x00000002)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x00A589EA pcstkwalk+ 0x204 (0x005A005A, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x00A58674 ucstkgentrace+ 0x224 (0x005A005A, 0x00000001, 0x021DE2BC, 0x004653AB)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x00A1431B ucbacktrace+ 0xab (0x00000006, 0x0000005C, 0x00000014, 0x00000001)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x0052457F sysind_handler+ 0x24 (0x00000006, 0x0000005C, 0x00000014, 0x00000001)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x004653AB ex_raise+ 0x2b3 (0x3D8E3178, 0x2161DEB0, 0x00000001, 0x00000001)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x005D0B93 wrongpage+ 0x2ec (0x2161DEB0, 0x00000004, 0x00000000, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x005CEBA5 getpage_with_validation+ 0x1355 (0x2161DEB0, 0x0052687A, 0x021DE66C, 0x021DE66C)
00:00000:00028:2006/05/31 11:04:21.87 kernelpc: 0x005C1666 apl_getnext+ 0x1f42 (0x2161DEB0, 0x021DE774, 0x21340958, 0x021DE6BC)
00:00000:00028:2006/05/31 11:04:21.89 kernelpc: 0x005BF2FD getnext+ 0x1ad (0x21340948, 0x00000002, 0x00000000, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:21.89 kernel[Handler pc: 0x0052455B sysind_handlerinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x00521EC8 ind_ides_init+ 0xb95 (0x2161D6B0, 0x2161DAB0, 0x3C0A9A33, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x004AADBE des__syssetup+ 0x2a1 (0x2138E31C, 0x021DF340, 0x008B3824, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x004AAA07 des_sysbuild+ 0x3a8 (0x2138E31C, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x004A9B89 des_refreshall+ 0x17 (0x22A24DB0, 0x2003BF63, 0x00DD6818, 0x021DF7D0)
00:00000:00028:2006/05/31 11:04:21.90 kernel[Handler pc: 0x008B71F2 lddb_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x008B3824 lddb_main+ 0xde4 (0x00440001, 0x00000000, 0x77E76461, 0x00000190)
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x006FC496 s_execute+ 0x4336 (0x22BA9800, 0x00448195, 0x2003BF63, 0x00DD6818)
00:00000:00028:2006/05/31 11:04:21.90 kernel[Handler pc: 0x0072DF86 s_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x0072AFF2 sequencer+ 0x1792 (0x2161CD00, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:21.90 kernelpc: 0x0044356A tdsrecv_language+ 0x540 (0x0000005B, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:21.90 kernel[Handler pc: 0x00465417 hdl_backoutinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:21.90 kernel[Handler pc: 0x00688040 ut_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:21.92 kernel[Handler pc: 0x00688040 ut_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:21.92 kernelpc: 0x00411C47 conn_hdlr+ 0x339e (0x2232E7E4, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:22.03 kernelpc: 0x00A09ED7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.03 kernelpc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x021DF874, 0x00000001)
00:00000:00028:2006/05/31 11:04:22.03 kernelend of stack trace, spid 28, kpid 5898330, suid 1
00:00000:00028:2006/05/31 11:04:22.14 serverError: 692, Severity: 20, State: 1
00:00000:00028:2006/05/31 11:04:22.14 serverUninitialized 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 serverError: 952, Severity: 20, State: 5
00:00000:00028:2006/05/31 11:04:22.21 serverDatabase '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 kernelSQL causing error : LOAD DATABASE xgl from'd:\bak\DUMP20060531N.dmp'WITHNOUNLOAD
00:00000:00028:2006/05/31 11:04:22.28 kernel************************************
00:00000:00028:2006/05/31 11:04:22.29 serverSQL Text: LOAD DATABASE xgl from'd:\bak\DUMP20060531N.dmp'WITHNOUNLOAD
00:00000:00028:2006/05/31 11:04:22.31 kernelcurdb = 1 pstat = 0x1011000 lasterror = 952
00:00000:00028:2006/05/31 11:04:22.31 kernelpreverror = 0 transtate = 1
00:00000:00028:2006/05/31 11:04:22.31 kernelcurcmd = 316 program =

00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE328, 0x77EB1F54, 0x77E621F0, 0xFFFFFFFF)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x00A7D8BD os_get_cur_stk_desc+ 0x13a (0x021DE328, 0x021DE0E0, 0x0000270F, 0x00000002)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x00A589EA pcstkwalk+ 0x204 (0x005A005A, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x00A58674 ucstkgentrace+ 0x224 (0x005A005A, 0x00000001, 0x021DF2F4, 0x00DD6818)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x00A1431B ucbacktrace+ 0xab (0x00000000, 0xFFFFFFFF, 0x021DE678, 0x004657A7)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x00406D71 terminate_process+ 0xb8f (0x021DE760, 0x0072F1F8, 0x00000009, 0x00000034)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x004657C4 close_network+ 0xc (0x00000009, 0x00000034, 0x00000014, 0x00000005)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x004657A7 hdl_default+ 0x38 (0x00000009, 0x00000034, 0x00000014, 0x00000005)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x0072F1F8 s_handle+ 0x1272 (0x00000009, 0x00000034, 0x00000014, 0x00000005)
00:00000:00028:2006/05/31 11:04:22.32 kernelpc: 0x004653AB ex_raise+ 0x2b3 (0x2161D6B0, 0x2161DAB0, 0x3C0A9A33, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x004AADE4 des__syssetup+ 0x2c7 (0x2138E31C, 0x021DF340, 0x008B3824, 0x2138E31C)
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x004AAA07 des_sysbuild+ 0x3a8 (0x2138E31C, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x004A9B89 des_refreshall+ 0x17 (0x22A24DB0, 0x2003BF63, 0x00DD6818, 0x021DF7D0)
00:00000:00028:2006/05/31 11:04:22.34 kernel[Handler pc: 0x008B71F2 lddb_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x008B3824 lddb_main+ 0xde4 (0x00440001, 0x00000000, 0x77E76461, 0x00000190)
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x006FC496 s_execute+ 0x4336 (0x22BA9800, 0x00448195, 0x2003BF63, 0x00DD6818)
00:00000:00028:2006/05/31 11:04:22.34 kernel[Handler pc: 0x0072DF86 s_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x0072AFF2 sequencer+ 0x1792 (0x2161CD00, 0x2003BF63, 0x00DD6818, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x0044356A tdsrecv_language+ 0x540 (0x0000005B, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:22.34 kernel[Handler pc: 0x00465417 hdl_backoutinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel[Handler pc: 0x00688040 ut_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernel[Handler pc: 0x00688040 ut_handleinstalled by the following function:-]
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x00411C47 conn_hdlr+ 0x339e (0x2232E7E4, 0x2003BF63, 0x00DD6818, 0x2232E7E4)
00:00000:00028:2006/05/31 11:04:22.34 kernelpc: 0x00A09ED7 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00028:2006/05/31 11:04:22.35 kernelpc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x021DF874, 0x00000001)
00:00000:00028:2006/05/31 11:04:22.35 kernelend of stack trace, spid 28, kpid 5898330, suid 1

千问 · 2007-9-26 17:01:04

好像你的备份本身没有问题，问题在于你的备份装入后，
数据库（id是4）所在的磁盘有问题。（object id 2所对应
的表是sysindexes).
你可以试着重新在其他的磁盘上创建用于装入备份的
数据库，然后再load一把。
也有可能不是磁盘的问题，你可以试着重新boot一下
sybase，然后重新装入备份

千问 · 2007-9-26 17:01:04

我试了,同一个备份文件在另外两台服务器上恢复都出现了以上相同的问题,而且之前能正常恢复的备份现在在这两台服务器上还是可以恢复的
而且其中一台服务器上我已经重装了SYBASE 12.5,然后恢复,但问题依旧

说明一下,原数据库还在正常使用,但现在不敢重启,就是想尽快找到解决方法,否则原服务器有个三长两短,我就只能上吊了

千问 · 2007-9-26 17:01:04

以前每次正常恢复数据库时,最后在ERROR日志中,会有这样一串提示,但数据库使用正常,我也查了每一个都对应一个索引,但不知是何原因?
00:00000:00017:2006/05/31 16:35:22.35 kernelReenlistment of DTC Transactions Complete
00:00000:00017:2006/05/31 16:38:34.87 serverCache binding for database '4', object '815394024', index '1' is being marked invalid in Sysattributes.
00:00000:00017:2006/05/31 16:38:34.91 serverCache binding for database '4', object '847394138', index '1' is being marked invalid in Sysattributes.
00:00000:00017:2006/05/31 16:38:34.91 serverCache binding for database '4', object '1550680622', index '3' is being marked invalid in Sysattributes.
00:00000:00017:2006/05/31 16:38:34.92 serverCache binding for database '4', object '1678681078', index '3' is being marked invalid in Sysattributes.

千问 · 2007-9-26 17:01:04

感觉你的原数据库上的SYSINDEXES表出了点儿问题，你可以用：
dbcc checkstorage
dbcc checkdb
dbcc checkalloc
dbcc checktable
dbcc tablealloc