Chinaunix

标题: sybase 926问题求救 [打印本页]

作者: 背景离乡 时间: 2005-12-19 20:35
标题: sybase 926问题求救
00:00000:00001:2005/12/15 09:44:01.28 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2005/12/15 09:44:01.28 server  Database 'cwbase3' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.

00:00000:00001:2005/12/15 09:44:13.02 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2005/12/15 09:44:13.02 server  Database 'cwbase6' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2005/12/15 09:44:13.70 server  Unable to proceed with the recovery of dbid <10> because of previous errors.  Continuing with the next database.

数据库出现926 问题，按照官方的恢复办法：Q.如何解决数据库被标记为"suspect"的问题之一（一般解决方案）？

A.现象：Error 926
　Severity Level 14
　Error Message Text
　Database 'xx' cannot be opened - it has been marked SUSPECT by recover Explanation

(1) 启动Backup Server, 后备master数据库

1>dump database master to "/usr/sybase/master_dump.20051219"
2>go

(2) 用isql登录到SQL Server, 须用sa帐号

1>sp_configure "allow updates", 1
2>go
1>begin tran
2>go
1>update master..sysdatabases
2>set status = -32768
3>Where name="pubs2"
4>go
(0 row)

1>rollback
2>go

重起数据库，看sybase.log文件仍然报926的错误，但是在shutdown 前checkpiont 没有报任何错误，
无法执行，请DX指点，小弟非常感谢！

作者: 背景离乡 时间: 2005-12-19 21:56
请dx指教呀熬夜通宵呢谢谢跪求！

作者: c001100c 时间: 2005-12-20 09:46
问题是否解决，贴出日志，什么操作系统，SYBASE版本

作者: 冷月无声 时间: 2005-12-20 10:12
你的update根本没有成功啊！你现在数据库的status位是多少?

作者: 背景离乡 时间: 2005-12-21 10:22
问题已经解决，数据库的状态已经改变，主要解决办法是先把status=0 更新，然后将status=-32768 继续更新，谢谢DX的帮助！

作者: clytcn 时间: 2005-12-22 10:41
能不能详细点，成功分享

作者: 1017of 时间: 2005-12-22 10:58
00:00000:00001:2005/12/15 09:44:01.28 server  Database 'cwbase3' cannot be opened.

1>update master..sysdatabases
2>set status = -32768
3>Where name="pubs2"
4>go

I have no idea of the relation between cwbase3 and pubs2,there is something wrong happens in pubs2?

作者: YtBenjamin 时间: 2005-12-29 11:45
haha...
careful about using 'copy', usually

作者: jtyhyl 时间: 2005-12-29 12:46
congratulate

作者: showzhonghua 时间: 2009-01-13 15:16
能够更详细一点吗？

作者: WFCJZ 时间: 2009-01-13 17:21
926的问题可以是说在SYBASE中很常见，处理也较比简单！

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)