紧急求助！！！sybase 11.9.2数据库不能打开！！！！

zhang168869

各位大侠！！！
　　　我的sybase 11.9.2 运行desdit程序ＰＩＮＧ命令服务端是成功的，sybase服务也是启动的，但在客户端运行程序报如下错误：
　　“Database "xlshop" is currently offline.Please wait and try your command again later.

求各位大侠给予支持！！！小弟谢谢了！！！

jtyhyl

重启试试，说不定就解决问题了

hiaw

请贴出errorlog , 或者更多的错误信息.

提示说 xlshop 库脱机,当然不能使用了

zhang168869

各位大侠！！！
　　　我的sybase 11.9.2 运行desdit程序ＰＩＮＧ命令服务端是成功的，sybase服务也是启动的，但在客户端运行程序报如下错误：
　　“Database "xlshop" is currently offline.Please wait and try your command again later.
　　操作系统为：sco operserver 5.0.5,各位大侠如何才能使数据库ＯＮＬＩＮＥ，请解解决方案。
　　谢谢！！！
　　错误日志：

00:05/07/17 11:04:11.18 server  Error: 625, Severity: 21, State: 1
00:05/07/17 11:04:11.19 server  Could not retrieve row from logical page 1241999 via RID because the entry in the offset table for that RID is less than or equal to 0.
00:05/07/17 11:04:11.19 server  Unable to proceed with the recovery of dbid <5>; because of previous errors.  Continuing with the next database.
00:05/07/17 11:04:11.19 server  Recovery complete.
00:05/07/17 11:04:11.19 server  SQL Server's default sort order is:
00:05/07/17 11:04:11.19 server          'bin_iso_1' (ID = 50)
00:05/07/17 11:04:11.19 server  on top of default character set:
00:05/07/17 11:04:11.19 server          'iso_1' (ID = 1).
00:05/07/17 11:04:27.92 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #0 with dbid 1 and objid 30. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:05/07/17 11:04:27.92 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #1 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:05/07/17 11:04:27.92 server  WARNING: spid 1, with suid 0 and curdbid 5 has open system SDES #2 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pattention = 0, pcmderrs = 0x0.
00:05/07/17 11:04:27.92 server  WARNING: spid 1, with suid 0 and curdbid 5 has active XDES #0 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1, xstatus = 0x8, xmode = 0x0.
00:05/07/17 11:04:27.92 server  WARNING: spid 1, with suid 0 and curdbid 5 has active XDES #1 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x110, p3stat = 0x2, pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1, xstatus = 0x8, xmode = 0x0.
00:05/07/17 11:04:27.92 server  Contact Sybase Technical Support.

hiaw

这一个错误可能由一个硬件问题所引起.
数据库本身不太可能被损坏.
请首先检查你的硬件,然后重启server并运行dbcc诊断

dbcc checkdb
dbcc checktable
dbcc checkcatalog