server Error: 692, Severity: 20, State: 1
今天上班，发现应用系统无法创建新的流程实例，但可以查询数据，登陆数据库服务器，查看日志文件，发现如下提示，请教各位大侠，如何解决，先感谢呐：00:00000:00071:2011/03/14 10:01:53.19 serverError: 692, Severity: 20, State: 1
00:00000:00071:2011/03/14 10:01:53.19 serverUninitialized logical page '6759969' was read while accessing object '373573338' in database '5'. Please contact Sybase Technical Support.
01:00000:00034:2011/03/14 10:03:26.58 serverError: 692, Severity: 20, State: 1
01:00000:00034:2011/03/14 10:03:26.58 serverUninitialized logical page '6759969' was read while accessing object '373573338' in database '5'. Please contact Sybase Technical Support.
00:00000:00034:2011/03/14 10:30:53.78 serverBufunhash: Buffer 0x1b54a65e0 from database id 5 has page number 0
in the page header and page number 6759969 in the buffer header. Buffer will be unhashed,
no action is necessary. Printing headers for diagnostics:
00:00000:00034:2011/03/14 10:30:53.78 serverMass: 0x1b54a65e0 Buffer: 0x1b54a65e0 Mass pageno: 6759969
-Mass virtpg: 140057668 dbid: 5 Mass stat: 0x44001010
-Buffer pageno: 6759969 Buffer virtpg: 140057668 Buf stat: 0x1 keep: 0 awaited: 0 tripsleft: 0
-bpage: 0x1a5e15000 flushseq: 0 dirty seq: 0 filthyseq: 0 linked: ( lru)
00:00000:00034:2011/03/14 10:30:53.78 serverPage: 0x1a5e15000 pageno: 0 objid: 0 indid: 0
- nextpg: 0 prevpg: 0 pstat: 0x0 ts: (0, 0) nextrno: 0
- freeoff: 0 minlen: 0 level: 0
01:00000:00099:2011/03/14 11:18:56.69 serverError: 692, Severity: 20, State: 1
01:00000:00099:2011/03/14 11:18:56.69 serverUninitialized logical page '6759969' was read while accessing object '373573338' in database '5'. Please contact Sybase Technical Support.
01:00000:00034:2011/03/14 11:20:08.11 serverError: 692, Severity: 20, State: 1
01:00000:00034:2011/03/14 11:20:08.11 serverUninitialized logical page '6759969' was read while accessing object '373573338' in database '5'. Please contact Sybase Technical Support.
01:00000:00173:2011/03/14 11:50:11.99 serverBufunhash: Buffer 0x1b582de20 from database id 5 has page number 0
in the page header and page number 6759969 in the buffer header. Buffer will be unhashed,
no action is necessary. Printing headers for diagnostics:
01:00000:00173:2011/03/14 11:50:11.99 serverMass: 0x1b582de20 Buffer: 0x1b582de20 Mass pageno: 6759969
-Mass virtpg: 140057668 dbid: 5 Mass stat: 0x44001010
-Buffer pageno: 6759969 Buffer virtpg: 140057668 Buf stat: 0x1 keep: 0 awaited: 0 tripsleft: 0
-bpage: 0x1aa65d000 flushseq: 0 dirty seq: 0 filthyseq: 0 linked: ( lru)
01:00000:00173:2011/03/14 11:50:11.99 serverPage: 0x1aa65d000 pageno: 0 objid: 0 indid: 0
- nextpg: 0 prevpg: 0 pstat: 0x0 ts: (0, 0) nextrno: 0
- freeoff: 0 minlen: 0 level: 0
补充：
数据库服务器环境：IBM P550(AIX5.0L+HACMP+DS4300+Sybase12.5) 逻辑页面错误， 这个错误比较严重的。 andkylee 发表于 2011-3-22 20:01 static/image/common/back.gif
逻辑页面错误， 这个错误比较严重的。
逻辑页损坏是什么导致的呢？异常关机吗？怎么解决呢？ 本帖最后由 andkylee 于 2011-3-25 10:58 编辑
回复 genius 的帖子
异常关机是个不小的原因。很有可能是硬盘的故障。
这个问题比较难解决。
可以使用：
1.bcp导出损坏的表，如果运气好的话，能够导出足够多的数据。
2.很遗憾，只能从以前的备份进行恢复了。
关于bcp导出损坏的表，还有一些技巧。
页:
[1]