youwei 发表于 2009-08-27 18:39

求教,数据库置疑,不能打开,急!!!

以下,是,数据库启动的日志!是wumis 库不能打开!谢谢各位多多指教!!
00:00000:00001:2009/08/27 18:07:33.76 serverRecovering database 'sybsystemprocs'.
00:00000:00001:2009/08/27 18:07:33.83 serverThe transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2009/08/27 18:07:33.88 serverDatabase 'sybsystemprocs' is now online.
00:00000:00001:2009/08/27 18:07:34.07 serverRecovering database 'winmis'.
00:00000:00001:2009/08/27 18:07:34.16 serverThe transaction log in the database 'winmis' will use I/O size of 2 Kb.
00:00000:00001:2009/08/27 18:07:34.21 serverDatabase 'winmis' is now online.
00:00000:00001:2009/08/27 18:07:34.24 serverRecovering database 'wumaster'.
00:00000:00001:2009/08/27 18:07:34.29 serverThe transaction log in the database 'wumaster' will use I/O size of 2 Kb.
00:00000:00001:2009/08/27 18:07:34.33 serverDatabase '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 serverError: 3403, Severity: 22, State: 2
00:00000:00001:2009/08/27 18:07:34.38 serverDuring 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 serverCould 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 serverRecovery complete.
00:00000:00001:2009/08/27 18:07:34.40 serverSQL 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 serveron 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 serverLoaded default Unilib conversion handle.
00:00000:00001:2009/08/27 18:07:34.40 serverWARNING: spid 1, with suid 0 and curdbid 2 has active XDES #1 with xactid (0, 0).

WFCJZ 发表于 2009-08-27 18:44

dbcc traceon(3604)
go
dbcc tablealloc(syslogs)
go
dbcc checktable(syslogs)
go

youwei 发表于 2009-08-27 20:16

可以解释下分别是什么作用吗!
执行了,上面的语句,问题还是没有解决!
各位还有什么方法吗?
谢谢!

WFCJZ 发表于 2009-08-27 20:49

http://bbs.chinaunix.net/archiver/?tid-123187.html

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

WFCJZ 发表于 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官方网站的,你可以参考一下!

youwei 发表于 2009-08-28 08:26

应该不相同,我怀疑,造成的原因,可能是,异常关机,引起的!

WFCJZ 发表于 2009-08-28 12:16

能否确定你这个故障是因为非正常关机造成的?
页: [1]
查看完整版本: 求教,数据库置疑,不能打开,急!!!