sybase出错！！

radmondlrx

我的SYBASE.log昨天出现如下错误信息：
Database 'prod' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
Unable to proceed with the recovery of dbid <6>; because of previous errors.

好象prod数据库已经recovery失败，但状态为suspect,有什么好方法恢复prod,   即使有数据丢失！！！


请高手赐教。谢谢

Blackrose

日志！

看看日志中最后几次启动时，报告的错误信息贴出来看看！

RS9000

select * from sysdatabases
看看你的数据库的状态，是否为suspect
如果是：
sp_configure 'allow updates system tables',1(大概是这个名字，可以用sp_configure 看一下）
update sysdatabases set status=-32768 where dbid=6
重启服务
updatte sysdatabases set status=0 where dbid=6
sp_configure 'allow updates system tables',0
这样恢复后可能数据会有问题，检查错误日志，看是什么原因造成的，并做DBCC检查

radmondlrx

server  Error: 1605, Severity: 18, State: 1
server  Failed to open virtual socket for new connections
server  Recovering database 'atsdb'.
server  Redo pass of recovery has processed 54 committed and 1 aborted transactions.
server  Undo pass of recovery has processed 2 incomplete transactions.
server  The transaction log in the database 'hy97db' will use I/O size of 2 Kb.
server  Database 'atsdb'is now online.
server  Error: 926, Severity: 14, State: 1
server  Database 'prod' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
server  Unable to proceed with the recovery of dbid <6>; because of previous errors.  Continuing with the next database.
server  Recovering database 'yqlb'.
server  Redo pass of recovery has processed 4 committed and 0 aborted transactions.
server  The transaction log in the database 'hytest' will use I/O size of 2 Kb.
server  Database 'yqlb' is now online.
server  Recovery complete.
server  SQL Server's default sort order is:
server          'bin_iso_1' (ID = 50)
server  on top of default character set:
server          'iso_1' (ID = 1).
server  Loaded default Unilib conversion handle.
kernel  engine 1, os pid 1274  online
kernel  engine 2, os pid 1275  online
kernel  engine 3, os pid 1276  online
kernel  ncheck: Network c4017b44 online
server  Error: 1608, Severity: 18, State: 4
server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

radmondlrx

server  Error: 1605, Severity: 18, State: 1
server  Failed to open virtual socket for new connections
server  Recovering database 'atsdb'.
server  Redo pass of recovery has processed 54 committed and 1 aborted transactions.
server  Undo pass of recovery has processed 2 incomplete transactions.
server  The transaction log in the database 'atsdb' will use I/O size of 2 Kb.
server  Database 'atsdb'is now online.
server  Error: 926, Severity: 14, State: 1
server  Database 'prod' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
server  Unable to proceed with the recovery of dbid <6>; because of previous errors.  Continuing with the next database.
server  Recovering database 'yqlb'.
server  Redo pass of recovery has processed 4 committed and 0 aborted transactions.
server  The transaction log in the database 'hytest' will use I/O size of 2 Kb.
server  Database 'yqlb' is now online.
server  Recovery complete.
server  SQL Server's default sort order is:
server          'bin_iso_1' (ID = 50)
server  on top of default character set:
server          'iso_1' (ID = 1).
server  Loaded default Unilib conversion handle.
kernel  engine 1, os pid 1274  online
kernel  engine 2, os pid 1275  online
kernel  engine 3, os pid 1276  online
kernel  ncheck: Network c4017b44 online
server  Error: 1608, Severity: 18, State: 4
server  A client process exited abnormally, or a network error was encountered. Unless other errors occurred, continue processing normally.

leoyangli

原帖由 "RS9000" 发表：
select * from sysdatabases
看看你的数据库的状态，是否为suspect
如果是：
sp_configure 'allow updates system tables',1(大概是这个名字，可以用sp_configure 看一下）
update sysdatabases set status=-327..........

重启前，先做dump database dbname with no_log
go