免费注册 查看新帖 |

Chinaunix

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

求教,数据库置疑,不能打开,急!!! [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2009-08-27 18:39 |只看该作者 |倒序浏览
以下,是,数据库启动的日志!是wumis 库不能打开!谢谢各位多多指教!!
00:00000:00001:2009/08/27 18:07:33.76 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2009/08/27 18:07:33.83 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2009/08/27 18:07:33.88 server  Database 'sybsystemprocs' is now online.
00:00000:00001:2009/08/27 18:07:34.07 server  Recovering database 'winmis'.
00:00000:00001:2009/08/27 18:07:34.16 server  The transaction log in the database 'winmis' will use I/O size of 2 Kb.
00:00000:00001:2009/08/27 18:07:34.21 server  Database 'winmis' is now online.
00:00000:00001:2009/08/27 18:07:34.24 server  Recovering database 'wumaster'.
00:00000:00001:2009/08/27 18:07:34.29 server  The transaction log in the database 'wumaster' will use I/O size of 2 Kb.
00:00000:00001:2009/08/27 18:07:34.33 server  Database 'wumaster' is now online.
00:00000:00001:2009/08/27 18:07:34.33 server  
*** Bypassing recovery of database id 7

00:00000:00001:2009/08/27 18:07:34.38 server  Error: 3403, Severity: 22, State: 2
00:00000:00001:2009/08/27 18:07:34.38 server  During recovery initialization, page 1279246 was encountered. This page belongs to object 0, not the log.
00:00000:00001:2009/08/27 18:07:34.40 server  Could not make log consistent during special recovery of database 7.  Please contact Technical support for assistance.
00:00000:00001:2009/08/27 18:07:34.40 server  Recovery complete.
00:00000:00001:2009/08/27 18:07:34.40 server  SQL Server's default sort order is:
00:00000:00001:2009/08/27 18:07:34.40 server          'nocase_cp850' (ID = 42)
00:00000:00001:2009/08/27 18:07:34.40 server  on top of default character set:
00:00000:00001:2009/08/27 18:07:34.40 server          'cp850' (ID = 2).
00:00000:00001:2009/08/27 18:07:34.40 server  Loaded default Unilib conversion handle.
00:00000:00001:2009/08/27 18:07:34.40 server  WARNING: spid 1, with suid 0 and curdbid 2 has active XDES #1 with xactid (0, 0).

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
2 [报告]
发表于 2009-08-27 18:44 |只看该作者
dbcc traceon(3604)
go
dbcc tablealloc(syslogs)
go
dbcc checktable(syslogs)
go

论坛徽章:
0
3 [报告]
发表于 2009-08-27 20:16 |只看该作者
可以解释下分别是什么作用吗!
执行了,上面的语句,问题还是没有解决!
各位还有什么方法吗?
谢谢!

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
4 [报告]
发表于 2009-08-27 20:49 |只看该作者
http://bbs.chinaunix.net/archiver/?tid-123187.html

看看与你的情况是否一样!

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
5 [报告]
发表于 2009-08-27 20:50 |只看该作者
Error 3403
Severity
22

Message text
During recovery initialization, page %ld was encountered.  This page belongs to object %ld, not the log.

This error may be caused by a hardware problem.

Explanation
During recovery, Adaptive Server scans the transaction log until the last page is found. During this scan, if a page is found that has an object ID on the page header that is not the same as that of syslogs, error 3403 occurs.

This may occur either as a result of a hardware failure or due to an Adaptive Server problem.

WARNING! This is a serious error and you must rebuild the affected database either using bcp or from clean backups.

Action
If you have a good backup, restore the database from your backup:

Drop the database. If the drop fails, follow the instructions in “Dropping a database when drop database fails” in the chapter “Other Useful Tasks” in the most recent version of the Troubleshooting and Disaster Recovery guide.

Create a database for load. Make sure the database you create has sizes as least as large as those in sysusages for the original database (and that all other sysusages values match the original values). For more information about creating a database for load, refer to “create database” in the Reference Manual: Commands.

Load the database from backup. (Refer to “load database” in the Reference Manual: Commands.)

Use the online database command to make the database available for use.

To prevent this error from being raised in the future, either perform a normal shutdown of Adaptive Server (specifically, do now use the nowait option), or checkpoint each database that is being used before shutting down Adaptive Server.

Additional information
Refer to “Developing a Backup and Recovery Plan” in the System Administration Guide: Volume 2 for complete information about how to safely create, dump, load, and re-create databases.

Versions in which this error is raised
All versions

以上是SYBASE官方网站的,你可以参考一下!

论坛徽章:
0
6 [报告]
发表于 2009-08-28 08:26 |只看该作者
应该不相同,我怀疑,造成的原因,可能是,异常关机,引起的!

论坛徽章:
33
ChinaUnix元老
日期:2018-07-04 15:10:362015年亚洲杯之阿联酋
日期:2015-02-06 17:15:532015亚冠之武里南联
日期:2015-06-06 15:40:252015亚冠之北京国安
日期:2015-06-17 15:42:412022北京冬奥会纪念版徽章
日期:2015-08-10 16:30:322015亚冠之阿尔纳斯尔
日期:2015-09-20 09:42:1215-16赛季CBA联赛之北京
日期:2016-01-15 10:03:5915-16赛季CBA联赛之青岛
日期:2016-04-26 16:44:4915-16赛季CBA联赛之广夏
日期:2018-07-04 15:33:21C
日期:2016-10-25 16:12:142017金鸡报晓
日期:2017-01-10 15:19:5615-16赛季CBA联赛之同曦
日期:2017-02-22 22:41:10
7 [报告]
发表于 2009-08-28 12:16 |只看该作者
能否确定你这个故障是因为非正常关机造成的?
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP