sybase Error: 624, Severity: 21, State: 1

最新推荐文章于 2021-07-31 08:27:59 发布

置顶

laizemu

最新推荐文章于 2021-07-31 08:27:59 发布

阅读量6.1k

点赞数

分类专栏：数据库文章标签： sybase asynchronous server database sql server disk

本文链接：https://blog.csdn.net/laizemu/article/details/4683679

版权

这篇博客详细记录了解决Sybase数据库错误624和3414的过程。错误提示表明数据库'escourt5'的日志段出现问题，导致恢复失败。尝试了截断日志和重做日志两种方法，最终通过`dbcc rebuild_log`命令修复日志，并调整数据库状态，成功启动服务。建议使用`dbcc checkdb`检查数据一致性以确保恢复正常。

摘要由CSDN通过智能技术生成

数据库版本：
Adaptive Server Enterprise/12.5.0.3/EBF 11449 ESD#4/P/NT (IX86)/OS 4.0/rel12503
/
1939/32-bit/OPT/Sat Sep 20 22:28:57 2003

errolog输出：

00:00000:00006:2009/10/16 11:22:27.51 kernel shutdownproc: shutting down SQL Server!
00:00000:00006:2009/10/16 11:22:27.62 kernel XP Server is not running.
00:00000:00006:2009/10/16 11:22:27.76 server SQL Server shutdown by request.
00:00000:00006:2009/10/16 11:22:27.78 kernel ueshutdown: exiting
00:00000:00006:2009/10/16 11:22:27.78 kernel shutdown waiting for engine pid 1308 to exit...
00:00000:00006:2009/10/16 11:22:27.78 kernel engine pid 1308 exit completed
00:00000:00000:2009/10/16 11:22:30.70 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2009/10/16 11:22:30.70 kernel Using config area from primary master device.
00:00000:00000:2009/10/16 11:22:30.70 kernel Warning: Using default file 'c:/sybase/DYQCserver.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2009/10/16 11:22:30.79 kernel Using 100000 file descriptors.
00:00000:00000:2009/10/16 11:22:30.79 kernel Adaptive Server Enterprise/12.5.0.3/EBF 11449 ESD#4/P/NT (IX86)/OS 4.0/rel12503/1939/32-bit/OPT/Sat Sep 20 22:28:57 2003
00:00000:00000:2009/10/16 11:22:30.79 kernel Confidential property of Sybase, Inc.
00:00000:00000:2009/10/16 11:22:30.79 kernel Copyright 1987, 2003
00:00000:00000:2009/10/16 11:22:30.79 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2009/10/16 11:22:30.79 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2009/10/16 11:22:30.79 kernel
00:00000:00000:2009/10/16 11:22:30.79 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/10/16 11:22:30.79 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2009/10/16 11:22:30.79 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2009/10/16 11:22:30.79 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2009/10/16 11:22:30.79 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2009/10/16 11:22:30.79 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/10/16 11:22:30.79 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2009/10/16 11:22:30.79 kernel Using 'c:/sybase/DYQCserver.cfg' for configuration information.
00:00000:00000:2009/10/16 11:22:30.79 kernel Logging ASE messages in file 'c:/sybase/ASE-12_5/install/errorlog'.
00:00000:00000:2009/10/16 11:22:30.81 kernel Initializing MSDTC Connection
00:00000:00000:2009/10/16 11:22:31.82 kernel MSDTC Initialization succeeded
00:00000:00000:2009/10/16 11:22:31.82 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/10/16 11:22:31.82 kernel Directory Control Layer (DCL) using directory driver: Inte