紧急求助！数据库无法链接上
<div class="t_msgfont" id="message7988809">单位一台服务器(RAID 1, SCO OpenServer5.06 + Sybase11.0.3)今天突然断电, 恢复电源后数据库启动报错,我按网上的解决数据库suspect的方法做了(就是设置sysdatabases中为-32768的然后再改回的)<br/><br/>1. 执行suspect过程后(最后一步启动重新sybase)： <br/>00:08/02/21 16:45:38.73 serverRecovering database 'sss'.<br/>00:08/02/21 16:45:38.74 serverRecovery dbid 5 ckpt (1863336,6) oldest tran=(1863336,5)<br/>00:08/02/21 16:45:38.75 serverError: 624, Severity: 21, State: 1<br/>00:08/02/21 16:45:38.75 serverAttempt to retrieve row from page via RID failed because the requested RID has a higher number than the last RID on the page. Rid pageid = 0x1c6ead; row num = 0x5.Page pointer = 0x8089b800, pageno = 1863341,status = 0x105, objectid = 8, indexid = 0, level = 0.00:08/02/21 16:45:38.75 serverError while undoing log row in database 'sss'.<br/>Rid pageid = 0x0; row num = 0x0.<br/>LOG SCAN DEFINTION:<br/>Database id : 5<br/>Forward scan: starting at begining of log<br/>log records for object id 1<br/><br/>LOG RECORDS:<br/><br/>Total number of log records 0<br/>00:08/02/21 16:45:38.75 serverError: 3414, Severity: 21, State: 1<br/>00:08/02/21 16:45:38.75 serverDatabase 'sss' (dbid 5): Recovery failed. Check<br/>the SQL Server errorlog for further information as to the cause.<br/>===================================================================================<br/>2. 执行isql -Usa<br/>00:08/02/21 18:06:14.23 server WARNING: spid 1, with suid 0 and curdbid 2 has o<br/>pen system SDES #4 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x100, p3s<br/>tat = 0x2, pattention = 0, pcmderrs = 0x0.<br/>00:08/02/21 18:06:14.23 server WARNING: spid 1, with suid 0 and curdbid 2 has a<br/>ctive XDES #2 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x100, p3stat = 0x2,<br/>pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1,<br/>xstatus = 0x8, xmode = 0x0.<br/>00:08/02/21 18:06:14.23 server Contact Sybase Technical Support.<br/>===================================================================================<br/>3. 再次启动sybase<br/>00:08/02/21 18:07:02.93 server Error: 926, Severity: 14, State: 1<br/>00:08/02/21 18:07:02.93 server Database 'sss' cannot be opened. An earlier atte<br/>mpt at recovery marked it 'suspect'. Check the SQL Server errorlog for informati<br/>on as to the cause.<br/>00:08/02/21 18:07:02.93 server Unable to proceed with the recovery of dbid <5><br/>because of previous errors. Continuing with the next database.<br/><br/>紧急求助各位大虾，谁有办法啊？无论连接数据库或者能倒出其中的数据均可！先谢谢了 ！！！</div> <p>不知道是什么原因，但还是关注一下</p> <p>貌似很复杂</p><p> </p>
<p>看看errorlog里的具体内容</p>
页:
[1]