免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2019 | 回复: 1
打印 上一主题 下一主题

user table全部丢失,请大家指教 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2007-01-18 01:58 |只看该作者 |倒序浏览
数据库运行期间发生错误,日志如下
00:00000:00001:2007/01/17 00:02:00.46 server  End diagnostics for read failure:
00:00000:00001:2007/01/17 00:02:00.46 server  Run the DBCC command 'dbcc tablealloc' for both the objects 832005995, 2126630619
00:00000:00001:2007/01/17 00:02:00.46 server  Error: 605, Severity: 21, State: 7
00:00000:00001:2007/01/17 00:02:00.46 server  An attempt was made to fetch logical page '8492712' in database 'ZD_JXC' from cache 'default data cache'. Page belongs to object with id '2126630619', not to object 'GZSP'.
00:00000:00001:2007/01/17 00:02:00.46 kernel  ************************************
00:00000:00001:2007/01/17 00:02:00.46 kernel  SQL causing error : select A.DEPTID, BM.DEPT_NAME,A.CUR_XSBM_FLAG from GZSP A, BM where A.DEPTID=BM.DEPTID and   A.SP_ID=0
00:00000:00001:2007/01/17 00:02:00.46 kernel  ************************************
00:00000:00001:2007/01/17 00:02:00.46 server  SQL Text: select A.DEPTID, BM.DEPT_NAME,A.CUR_XSBM_FLAG from GZSP A, BM where A.DEPTID=BM.DEPTID and   A.SP_ID=0 00:00000:00001:2007/01/17 00:02:00.48 kernel  curdb = 6 pstat = 0x10000 lasterror = 605
00:00000:00001:2007/01/17 00:02:00.48 kernel  preverror = 0 transtate = 1
00:00000:00001:2007/01/17 00:02:00.48 kernel  curcmd = 193 program =                              
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x26fecc0, 0x1e001e, 0x26fecc0, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x26fecc0, 0x26ff214, 0x270f, 0x2)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x883514 pcstkwalk+ 0x224 (0x1e001e, 0x2, 0x270f, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x26ff5d8, 0x4527a
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x405fe6 terminate_process+ 0x566 (0x26ff638, 0x639a02, 0x6, 0x5)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x4527ea close_network+ 0x1a (0x6, 0x5, 0x15, 0x7)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x5, 0x15, 0x7)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x639a02 s_handle+ 0x162 (0x6, 0x5, 0x15, 0x7)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x452413 ex_raise+ 0x193 (0x50c17970, 0x203d00f0, 0x7, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x542e0d wrongpage+ 0x3bd (0x26ff78c, 0x203d00f0, 0x2, 0x26ffaf
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x578fc9 getindexpage+ 0x1c9 (0x26ffaf8, 0x203d00f0, 0x1, 0x1)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x577813 srchindex+ 0x3e3 (0x203d00f0, 0x1, 0x21689df4, 0x1)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x53141e apl__startscan+ 0x1ce (0x203d00f0, 0x1, 0x1, 0x20a514f0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x530f4f startscan+ 0x21f (0x231fe43c, 0x231fe744, 0x26ffd34, 0x231fe43c)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x6d6741 exec_eop+ 0x2d1 (0x231fe43c, 0x231fe650, 0x26ffd34, 0x20a514f0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x6d6837 exec_eop+ 0x3c7 (0x231fe3a0, 0x231fe43c, 0xc1, 0x26ffd34)
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x68fb50 sortmerr  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x6da130 execerr  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x635bb0 aritherr  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x6d573e execute+ 0x26e (0x21, 0x20a514f0, 0x20a514f0, 0x20a29ce0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x652ccb s_execute+ 0x78b (0x231d8800, 0x21, 0x20a5872d, 0x20a514f0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x6398a0 s_handle  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x63678f sequencer+ 0x15f (0x0, 0x20014ccc, 0x1a001a, 0x2001391c)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x436d31 tdsrecv_language+ 0xc1 (0x4, 0x4000, 0x20014ccc, 0x1a001a)
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x452660 hdl_backout  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  [Handler pc: 0x5c0c40 ut_handle  installed by the following function:-]
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x40dc1c conn_hdlr+ 0xb5c (0x20014ccc, 0x2001391c, 0x1a001a, 0x20014ccc)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20014ccc, 0x0, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  pc: 0x77e6b396 KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00001:2007/01/17 00:02:00.48 kernel  end of stack trace, spid 1, kpid 1966110, suid 7
00:00000:00007:2007/01/17 00:02:51.00 kernel  shutdownproc: shutting down SQL Server!
00:00000:00007:2007/01/17 00:02:51.06 kernel  ueshutdown: exiting
00:00000:00007:2007/01/17 00:02:51.06 kernel  XP Server is not running.

发生错误后,我执行以下操作:
DUMP   TRAN  ZD_JXC  WITH  NO_LOG
go
dump  database  ZD_JXC  TO  'E:\ZD_JXC.DAT'
GO

最后我执行了导入操作:

load  database  ZD_JXC     FROM  'E:\zd_jxc.DAT'

GO


online database ZD_JXC
GO

操作完毕后,打开数据库,USER TABLE全部丢失,请大家帮忙找下原因,感激不尽

注:SYBASE版本11.9,操作系统为WINDOWS2000 SERVER

论坛徽章:
0
2 [报告]
发表于 2007-01-18 10:49 |只看该作者
逻辑页错误了,有数据损失了。。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP