由于掉电引起的Sybase无法启动的问题?

yyhll 2002-11-28 08:48:36
OS : SUN Solaris 2.6
DB : Sybase 11.9
意外掉电后无法启动数据库,信息如下,请问如何解决?
00:00000:00000:2002/11/27 16:34:02.17 kernel Either the config parameter 'use s
ecurity services' is set to 0, or ASE does not support use of external security
mechanisms on this platform. The Security Control Layer will not be initialized.
No external security mechanisms will be supported.
00:00000:00000:2002/11/27 16:34:02.17 kernel engine 0, os pid 15471 online
00:00000:00000:2002/11/27 16:34:02.17 server No active traceflags
00:00000:00001:2002/11/27 16:34:02.19 server Opening Master Database ...
00:00000:00001:2002/11/27 16:34:02.19 server Loading SQL Server's default sort
order and character set
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: listener type: master
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: listener endpoint: /dev/t
cp
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: listener raw address: \x0
0021004847380010000000000000000
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: transport provider: T_COT
S_ORD
00:00000:00001:2002/11/27 16:34:02.27 server Recovering database 'master'
00:00000:00001:2002/11/27 16:34:02.27 server During redo the page timestamp val
ue is less than old timestamp from log. Page #=304, object id = 33, page timesta
mp=0000 0000004a. Log old timestamp=0001 08af49d4.
00:00000:00001:2002/11/27 16:34:02.27 server Cannot recover the master database
, exiting.
00:00000:00001:2002/11/27 16:34:02.27 kernel ueshutdown: exiting
...全文
156 8 打赏 收藏 转发到动态 举报
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
yyhll 2002-12-02
  • 打赏
  • 举报
 回复
此问题我已通过重建master库解决,但人认为应该有更好的方法处理.下面是当时出错的详细日志报告:

00:00000:00000:2002/11/27 16:33:56.15 kernel Using config area from primary master device.
00:00000:00000:2002/11/27 16:33:56.15 kernel Warning: Using default file '/export/home/sybase/SYBASE.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2002/11/27 16:34:01.39 kernel Using 1024 file descriptors.
00:00000:00000:2002/11/27 16:34:01.39 kernel Adaptive Server Enterprise/11.9.2.5/1234/P/SWR 9677 ESD 1/Sun_svr4/OS 5.5.1/FBO/Tue Jul 24 10:19:51 2001
00:00000:00000:2002/11/27 16:34:01.39 kernel Confidential property of Sybase, Inc.
00:00000:00000:2002/11/27 16:34:01.39 kernel Copyright 1987, 2001
00:00000:00000:2002/11/27 16:34:01.39 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2002/11/27 16:34:01.39 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2002/11/27 16:34:01.39 kernel
00:00000:00000:2002/11/27 16:34:01.39 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2002/11/27 16:34:01.39 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2002/11/27 16:34:01.39 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2002/11/27 16:34:01.39 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2002/11/27 16:34:01.39 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2002/11/27 16:34:01.39 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2002/11/27 16:34:01.39 kernel Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA
00:00000:00000:2002/11/27 16:34:01.39 kernel Using '/export/home/sybase/SYBASE.cfg' for configuration information.
00:00000:00000:2002/11/27 16:34:01.39 kernel Logging SQL Server messages in file '/export/home/sybase/install/SYBASE.log'.
00:00000:00000:2002/11/27 16:34:01.44 kernel kdcl_init: connectivity library supports master/query syntax
00:00000:00000:2002/11/27 16:34:01.44 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2002/11/27 16:34:01.44 kernel Network and device connection limit is 1014.
00:00000:00000:2002/11/27 16:34:01.49 server Number of proc buffers allocated: 114982.
00:00000:00000:2002/11/27 16:34:01.59 server Proc header memory allocated 28745 pages for each per engine cache
00:00000:00000:2002/11/27 16:34:01.60 server Number of blocks left for proc headers: 115080.
00:00000:00000:2002/11/27 16:34:01.60 server Memory allocated for the default data cache cache: 866656 Kb
00:00000:00000:2002/11/27 16:34:02.15 server Size of the 2K memory pool: 866656 Kb
00:00000:00000:2002/11/27 16:34:02.17 kernel Initializing virtual device 0, '/export/home/sybase/master.dev'
00:00000:00000:2002/11/27 16:34:02.17 kernel Virtual device 0 started using standard unix i/o.
00:00000:00000:2002/11/27 16:34:02.17 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2002/11/27 16:34:02.17 kernel Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2002/11/27 16:34:02.17 kernel engine 0, os pid 15471 online
00:00000:00000:2002/11/27 16:34:02.17 server No active traceflags
00:00000:00001:2002/11/27 16:34:02.19 server Opening Master Database ...
00:00000:00001:2002/11/27 16:34:02.19 server Loading SQL Server's default sort order and character set
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: listener type: master
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: listener endpoint: /dev/tcp
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: listener raw address: \x00021004847380010000000000000000
00:00000:00002:2002/11/27 16:34:02.19 kernel ninit:0: transport provider: T_COTS_ORD
00:00000:00001:2002/11/27 16:34:02.27 server Recovering database 'master'
00:00000:00001:2002/11/27 16:34:02.27 server During redo the page timestamp value is less than old timestamp from log. Page #=304, object id = 33, page timestamp=0000 0000004a. Log old timestamp=0001 08af49d4.
0
yyhll 2002-12-02
  • 打赏
  • 举报
 回复
请问hobbylu(东方一剑),rebuild_log具体如何操作?能详细讲一下吗?

—————————————————————————————————
┏━★━━◆━━★━┓
♂欢|◢ＣＳＤＮ◣|使♂ 　　　　　　　▲自由保存帖子，浏览，关注检测
┃迎|◥论坛助手◤|用┃ 　　　　　　　▲完善的ＣＳＤＮ客户端工具
┗━☆━━◇━━━☆┛　　　　　　　▲自动添加签名......

让你更快，更爽，更方便地上CSDN...
http://www.csdn.net/expert/topic/573/573604.xml
http://www.chinaok.net/csdn/csdn.zip
aceplus 2002-12-02
  • 打赏
  • 举报
 回复
关注中......
(留过脚印)
yyhll 2002-11-29
  • 打赏
  • 举报
 回复
hobbylu(东方一剑) 朋友,你的方法我已试过,但是还是报相同的错误.只是Page #, object id的值与先前的不同.只能恢复"master"库了.
wanghai 2002-11-29
  • 打赏
  • 举报
 回复
关注
hobbylu 2002-11-29
  • 打赏
  • 举报
 回复
你的日志还没有清除，如果dump tran master with no_log请不掉的话，那么需要rebuild_log
wanghai 2002-11-28
  • 打赏
  • 举报
 回复
master库坏了，恢复master库吧
hobbylu 2002-11-28
  • 打赏
  • 举报
 回复
你的问题是由于recovery日志引起的，你需要把master日志做dump
1、修改RUN_xxxx这个文件，在最后面增加-T3607
2、启动server
3、dump tran master with no_log
4、shutdown with nowait
5、恢复RUN_xxxx文件
6、起动数据库
ok
PostgreSQL数据库管理（三）
它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Firebird)，和专有系统(比如 Oracle、Sybase、IBM 的 DB2 和 Microsoft SQL Server)之外的另一种选择。   事实上， PostgreSQL 的特性覆盖了 SQL-2/SQL-92...
SYBASE灾难备份方案
本方案主要从计算机系统的可用性出发，给出了高可用性问题的一般描述及群机方式的特色，进而提出了灾难备份的特殊考虑及SYBASE的灾难备份方案。 一、系统高可用性（High Availability）... 2 1、高可用性方案......
Sybase数据库性能调优
Sybase数据库性能调优:http://www.soft6.com/know/detail.asp?id=AJIDDA广铁集团电算...然而，数据库性能调优是一个非常复杂的问题，不仅需要潜心研究数据库的理论知识，更需要参考同行的实践经验。本期我们特别为DBA选
Sybase

2,596

社区成员

25,614

社区内容

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章