- 论坛徽章:
- 0
|
单位一台服务器(RAID 1, SCO OpenServer5.06 + Sybase11.0.3)今天突然断电, 恢复电源后数据库启动报错,我按网上的解决数据库suspect的方法做了(就是设置sysdatabases中为-32768的然后再改回的)
1. 执行suspect过程后(最后一步启动重新sybase):
00:08/02/21 16:45:38.73 serverRecovering database 'sss'.
00:08/02/21 16:45:38.74 serverRecovery dbid 5 ckpt (1863336,6) oldest tran=(1863336,5)
00:08/02/21 16:45:38.75 serverError: 624, Severity: 21, State: 1
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'.
Rid pageid = 0x0; row num = 0x0.
LOG SCAN DEFINTION:
Database id : 5
Forward scan: starting at begining of log
log records for object id 1
LOG RECORDS:
Total number of log records 0
00:08/02/21 16:45:38.75 serverError: 3414, Severity: 21, State: 1
00:08/02/21 16:45:38.75 serverDatabase 'sss' (dbid 5): Recovery failed. Check
the SQL Server errorlog for further information as to the cause.
===================================================================================
2. 执行isql -Usa
00:08/02/21 18:06:14.23 server WARNING: spid 1, with suid 0 and curdbid 2 has o
pen system SDES #4 with dbid 5 and objid 8. PSS pstat = 0x0, p2stat = 0x100, p3s
tat = 0x2, pattention = 0, pcmderrs = 0x0.
00:08/02/21 18:06:14.23 server WARNING: spid 1, with suid 0 and curdbid 2 has a
ctive XDES #2 with xactid (0, 0). PSS pstat = 0x0, p2stat = 0x100, p3stat = 0x2,
pxactcnt = 0, pattention = 0, pcmderrs = 0x0, XDES dbt_dbid = 5, xstate = 0x1,
xstatus = 0x8, xmode = 0x0.
00:08/02/21 18:06:14.23 server Contact Sybase Technical Support.
===================================================================================
3. 再次启动sybase
00:08/02/21 18:07:02.93 server Error: 926, Severity: 14, State: 1
00:08/02/21 18:07:02.93 server Database 'sss' cannot be opened. An earlier atte
mpt at recovery marked it 'suspect'. Check the SQL Server errorlog for informati
on as to the cause.
00:08/02/21 18:07:02.93 server Unable to proceed with the recovery of dbid <5>
because of previous errors. Continuing with the next database.
紧急求助各位大虾,谁有办法啊?无论连接数据库或者能倒出其中的数据均可!先谢谢了 !!! |
|