免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2226 | 回复: 1
打印 上一主题 下一主题

紧急求助!数据库无法链接上 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2008-02-21 18:19 |只看该作者 |倒序浏览
单位一台服务器(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.

紧急求助各位大虾,谁有办法啊?无论连接数据库或者能倒出其中的数据均可!先谢谢了 !!!

论坛徽章:
0
2 [报告]
发表于 2008-02-22 12:46 |只看该作者
624错误
看样子是syslogs损坏,用解决suspect的方法后看能否重建日志,这个要看些运气了。
总的来说如果有所有的备份(包括损坏后未进行修复的文件备份),尝试一下。不是简单的工作了。。。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP