马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?站点注册
×
单位一台服务器(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.
紧急求助各位大虾,谁有办法啊?无论连接数据库或者能倒出其中的数据均可!先谢谢了 !!! |