数据库无法启动-请大侠们出手相助

52husky

交换机故障导致系统无法连接。更换新交换机并将服务器进行了重启，结果进行操作系统后无法启动数据库。附错误日志，请解答
00:00000:00008:2009/01/25 08:12:28.68 server  Can't allocate space for object 'syslogs' in database 'master' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.
00:00000:00017:2009/01/25 08:56:32.31 server  Increase the config parameter 'number of open objects' to avoid descriptor reuse. Reuse may result in performance degradation.
00:00000:00008:2009/01/25 08:59:28.59 server  Error: 1105, Severity: 17, State: 4
00:00000:00008:2009/01/25 08:59:28.59 server  Can't allocate space for object 'syslogs' in database 'master' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.
00:00000:00002:2009/01/25 09:31:46.95 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 09:31:46.95 server  Failed to open virtual socket for new connections
00:00000:00002:2009/01/25 09:38:56.10 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 10:03:35.53 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 10:03:35.53 server  Failed to open virtual socket for new connections
00:00000:00002:2009/01/25 10:04:07.46 server  Error: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 10:04:07.46 server  Failed to open virtual socket for new connections
00:00000:00009:2009/01/25 10:05:09.78 server  Error: 1105, Severity: 17, State: 4
00:00000:00009:2009/01/25 10:05:09.78 server  Can't allocate space for object 'syslogs' in database 'master' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.
00:00000:00006:2009/01/25 10:53:26.35 kernel  shutdownproc: shutting down SQL Server!
00:00000:00006:2009/01/25 10:53:26.37 server  The transaction log in database master is almost full.  Your transaction is being suspended until space is made available in the log.
00:00000:00008:2009/01/25 10:57:28.51 server  1 task(s) are sleeping waiting for space to become available in the log segment for database master.
00:00000:00008:2009/01/25 10:58:28.56 server  1 task(s) are sleeping waiting for space to become available in the log segment for database master.
00:00000:00008:2009/01/25 10:59:28.48 server  1 task(s) are sleeping waiting for space to become available in the log segment for database master.
00:00000:00008:2009/01/25 11:00:28.56 server  1 task(s) are sleeping waiting for space to become available in the log segment for database master.
00:00000:00000:2009/01/25 11:00:55.48 kernel  kisignal: SQL Server terminated by system shutdown.
00:00000:00000:2009/01/25 11:00:55.50 kernel  ueshutdown: exiting
00:00000:00000:2009/01/25 11:00:55.53 kernel  shutdown waiting for engine pid 408 to exit...
00:00000:00000:2009/01/25 11:00:55.60 kernel  engine pid 408 exit completed
00:00000:00000:2009/01/25 11:00:55.60 kernel  Abnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2009/01/25 11:18:51.48 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2009/01/25 11:18:51.56 kernel  Using config area from primary master device.
00:00000:00000:2009/01/25 11:18:51.60 kernel  Warning: Using default file 'c:\sybase\DELL6650.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/01/25 11:18:52.07 kernel  Using 100000 file descriptors.
00:00000:00000:2009/01/25 11:18:52.14 kernel  Adaptive Server Enterprise/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1/32-bit/OPT/Tue Jul 30 23:45:57 2002
00:00000:00000:2009/01/25 11:18:52.14 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2009/01/25 11:18:52.14 kernel  Copyright 1987, 2002
00:00000:00000:2009/01/25 11:18:52.14 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2009/01/25 11:18:52.14 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2009/01/25 11:18:52.14 kernel  
00:00000:00000:2009/01/25 11:18:52.14 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/01/25 11:18:52.14 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2009/01/25 11:18:52.14 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2009/01/25 11:18:52.14 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2009/01/25 11:18:52.14 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2009/01/25 11:18:52.14 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/01/25 11:18:52.14 kernel  Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2009/01/25 11:18:52.14 kernel  Using 'c:\sybase\DELL6650.cfg' for configuration information.
00:00000:00000:2009/01/25 11:18:52.14 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2009/01/25 11:18:52.15 kernel  Initializing MSDTC Connection
00:00000:00000:2009/01/25 11:18:54.20 kernel  MSDTC Initialization succeeded
00:00000:00000:2009/01/25 11:18:54.21 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/01/25 11:18:54.21 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2009/01/25 11:18:54.21 kernel  *** WARNING ******************
00:00000:00000:2009/01/25 11:18:54.21 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2009/01/25 11:18:54.21 kernel  SQL Server NT process id is 0x5f0.
00:00000:00000:2009/01/25 11:18:54.21 kernel  SQL Server was started as a Service.
00:00000:00000:2009/01/25 11:18:54.21 kernel  SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2009/01/25 11:18:54.21 kernel  Network and device connection limit is 99992.
00:00000:00000:2009/01/25 11:18:54.62 server  Number of blocks left for proc headers: 38352.
00:00000:00000:2009/01/25 11:18:54.68 server  Proc header memory allocated 19176 pages for each per engine cache
00:00000:00000:2009/01/25 11:18:54.70 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2009/01/25 11:18:54.70 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2009/01/25 11:18:54.70 kernel  Initializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2009/01/25 11:18:54.70 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2009/01/25 11:18:54.70 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2009/01/25 11:18:54.70 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:2009/01/25 11:18:54.70 kernel  engine 0, os pid 424  online
00:00000:00000:2009/01/25 11:18:54.70 server  No active traceflags
00:00000:00001:2009/01/25 11:18:54.71 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1794/32-bit/OPT/Tue Jul 30 17:41:42 2002'.
00:00000:00001:2009/01/25 11:18:54.71 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10322/PC Intel/BUILD125-011-1/OPT/Thu May 02 15:33:17 2002'
00:00000:00001:2009/01/25 11:18:54.71 server  Opening Master Database ...
00:00000:00001:2009/01/25 11:18:54.79 server  Loading SQL Server's default sort order and character set
00:00000:00001:2009/01/25 11:18:54.82 server  Loaded default Unilib conversion handle.
00:00000:00001:2009/01/25 11:18:54.84 server  Recovering database 'master'.
00:00000:00001:2009/01/25 11:18:55.01 server  Redo pass of recovery has processed 14 committed and 3 aborted transactions.
00:00000:00001:2009/01/25 11:18:55.06 server  Checking external objects.
00:00000:00001:2009/01/25 11:18:55.07 server  Database 'master' is now online.
00:00000:00001:2009/01/25 11:18:55.07 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2009/01/25 11:18:55.07 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2009/01/25 11:18:55.09 server  server is unnamed
00:00000:00001:2009/01/25 11:18:55.10 server  Activating disk 'center'.
00:00000:00001:2009/01/25 11:18:55.10 kernel  Initializing virtual device 2, 'D:\center\center.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.14 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.14 server  Activating disk 'center1'.
00:00000:00001:2009/01/25 11:18:55.14 kernel  Initializing virtual device 4, 'D:\center\center1.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.34 kernel  Virtual device 4 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.34 server  Activating disk 'center1log'.
00:00000:00001:2009/01/25 11:18:55.34 kernel  Initializing virtual device 5, 'D:\centerlog\center1log.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.37 kernel  Virtual device 5 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.37 server  Activating disk 'center2'.
00:00000:00001:2009/01/25 11:18:55.37 kernel  Initializing virtual device 6, 'D:\center\center2.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.57 kernel  Virtual device 6 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.57 server  Activating disk 'center2log'.
00:00000:00001:2009/01/25 11:18:55.59 kernel  Initializing virtual device 7, 'D:\centerlog\center2log.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.79 kernel  Virtual device 7 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.79 server  Activating disk 'center3'.
00:00000:00001:2009/01/25 11:18:55.79 kernel  Initializing virtual device 23, 'D:\center\center3.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.82 kernel  Virtual device 23 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.82 server  Activating disk 'centerlog'.
00:00000:00001:2009/01/25 11:18:55.82 kernel  Initializing virtual device 3, 'D:\centerlog\centerlog.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.84 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.84 server  Activating disk 'data'.
00:00000:00001:2009/01/25 11:18:55.84 kernel  Initializing virtual device 24, 'E:\txdata\data.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.89 kernel  Virtual device 24 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.89 server  Activating disk 'data2'.
00:00000:00001:2009/01/25 11:18:55.89 kernel  Initializing virtual device 26, 'e:\txdata\data2' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.92 kernel  Virtual device 26 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.92 server  Activating disk 'data2_log'.
00:00000:00001:2009/01/25 11:18:55.92 kernel  Initializing virtual device 27, 'e:\txdata\data2_log' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.93 kernel  Virtual device 27 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.93 server  Activating disk 'data_log'.
00:00000:00001:2009/01/25 11:18:56.98 kernel  Initializing virtual device 13, 'E:\hisdata\hisdatalog.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.00 kernel  Virtual device 13 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.00 server  Activating disk 'log'.
00:00000:00001:2009/01/25 11:18:57.00 kernel  Initializing virtual device 31, 'F:\log.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.29 kernel  Virtual device 31 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.29 server  Activating disk 'sysprocsdev'.
00:00000:00001:2009/01/25 11:18:57.29 kernel  Initializing virtual device 1, 'c:\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.31 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.31 server  Activating disk 'tempdb'.
00:00000:00001:2009/01/25 11:18:57.31 kernel  Initializing virtual device 8, 'D:\centerlog\tempdb.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.34 kernel  Virtual device 8 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.34 server  Activating disk 'tempdb_data'.
00:00000:00001:2009/01/25 11:18:57.68 kernel  Initializing virtual device 19, 'E:\txdata\txdata2.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.89 kernel  Virtual device 19 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.89 server  Activating disk 'txdata3'.
00:00000:00001:2009/01/25 11:18:57.89 kernel  Initializing virtual device 20, 'E:\txdata\txdata3.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:58.10 kernel  Virtual device 20 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:58.10 server  Activating disk 'txlog'.
00:00000:00001:2009/01/25 11:18:58.10 kernel  Initializing virtual device 21, 'E:\txdata\txlog.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:58.12 kernel  Virtual device 21 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:58.14 kernel  SQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00001:2009/01/25 11:18:58.73 kernel  pc: 0x00689E7F cfg__locate_bynumber+ 0x4d (0x00006F63, 0x00000002, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.73 kernel  pc: 0x00689E7F cfg__locate_bynumber+ 0x4d (0x20037038, 0x23483ED4, 0x00000000, 0x01F7FE8B)
00:00000:00001:2009/01/25 11:18:58.73 kernel  pc: 0x0064355B cfg__getsyscfgvals+ 0x93 (0x01F7FE74, 0x00000016, 0x01F7FCF4, 0x01F7FE8B)
00:00000:00001:2009/01/25 11:18:58.73 kernel  pc: 0x00646667 cfg__restoreconfig+ 0xb3 (0x00000005, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.73 kernel  [Handler pc: 0x00647E5D cfg__handle  installed by the following function:-]
00:00000:00001:2009/01/25 11:18:58.73 kernel  pc: 0x0064117C cfg_main+ 0x3fc (0x00000000, 0x00000000, 0x00000000, 0x2405965
00:00000:00001:2009/01/25 11:18:58.75 kernel  pc: 0x0040526B dsinit+ 0xf7b (0x24059658, 0x00000000, 0x00000000, 0x2405965
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A1EF27 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  end of stack trace, spid 1, kpid 983055, suid 0
00:00000:00001:2009/01/25 11:18:58.84 kernel  ************************************
00:00000:00001:2009/01/25 11:18:58.84 kernel  curdb = 1 pstat = 0x0 lasterror = 0
00:00000:00001:2009/01/25 11:18:58.84 kernel  preverror = 0 transtate = 0
00:00000:00001:2009/01/25 11:18:58.84 kernel  curcmd = 0 program =                              
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x01F7F160, 0x77EB1F44, 0x77E621F0, 0xFFFFFFFF)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x01F7F160, 0x01F7EF18, 0x0000270F, 0x00000002)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A6F8BA pcstkwalk+ 0x204 (0x000F000F, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A6F544 ucstkgentrace+ 0x224 (0x000F000F, 0x00000001, 0x00BEC888, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A2969B ucbacktrace+ 0xab (0x000F000F, 0xFFFFFFFF, 0xC0000005, 0x2348394C)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00406FC1 terminate_process+ 0xb8f (0xC0000005, 0x7800BDB5, 0x01F7F4E0, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A1E47B kiexception+ 0x2e0 (0x24059658, 0x00000000, 0x00000000, 0x2405965
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x00A1EFA7 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  pc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernel  end of stack trace, spid 1, kpid 983055, suid 0

52husky

是MASTER库空间不足？请大侠列出详细操作步骤。谢谢！

52husky

我参考前期贴子内容修改了数据库启动文件，但用SYBASE CENTRAL管理器仍法启动数据库，不知问题出自哪里？

rem
rem Adaptive Server Information:
rem  name:                          DELL6650
rem  master device:                 c:\sybase\data\master.dat
rem  server page size:              2048
rem  master device size:            100
rem  errorlog:                      c:\sybase\ASE-12_5\install\errorlog
rem  interfaces:                    c:\sybase\ini
rem
c:\sybase\ASE-12_5\bin\sqlsrvr.exe -dc:\sybase\data\master.dat -sDELL6650 -ec:\sybase\ASE-12_5\install\errorlog -ic:\sybase\ini -Mc:\sybase\ASE-12_5 -T3607

1017of

好象第二次启动，master库已经recover完成，问题不在master库上。
请注意2009/01/25 11:18:58.14那一行，好象有存储问题，导致E:\txdata\txlog.dat无法activating，建议检查存储或系统相关问题；
按道理，如果是非master库问题，ASE server一般应该可以起来，只是某些用户库无法online，请仔细检查。
ps:大过节的也不休息啊？呵呵，我正好上来晃了一圈~~~

1017of

如果master没有问题了，请把-T3607取消

52husky

按法王建议方法，用批处理执行数据库启动后的日志信息：
00:00000:00000:2009/01/25 14:18:57.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/01/25 14:18:57.71 kernel  basis_dlock: file 'c:\sybase\data\master.dat' already in use by a SQL Server
00:00000:00000:2009/01/25 14:18:57.71 kernel  kdconfig: unable to read primary master device
00:00000:00000:2009/01/25 14:18:57.73 server  kiconfig: read of config block failed
00:00000:00006:2009/01/25 14:21:30.82 kernel  shutdownproc: shutting down SQL Server!
00:00000:00006:2009/01/25 14:21:30.87 kernel  XP Server is not running.
00:00000:00006:2009/01/25 14:21:30.87 server  SQL Server shutdown by request.
00:00000:00006:2009/01/25 14:21:30.89 kernel  ueshutdown: exiting
00:00000:00000:2009/01/25 14:21:54.57 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2009/01/25 14:21:54.59 kernel  Using config area from primary master device.
00:00000:00000:2009/01/25 14:21:54.60 kernel  Warning: Using default file 'c:\sybase\DELL6650.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/01/25 14:21:55.14 kernel  Using 100000 file descriptors.
00:00000:00000:2009/01/25 14:21:55.15 kernel  Adaptive Server Enterprise/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1/32-bit/OPT/Tue Jul 30 23:45:57 2002
00:00000:00000:2009/01/25 14:21:55.15 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2009/01/25 14:21:55.15 kernel  Copyright 1987, 2002
00:00000:00000:2009/01/25 14:21:55.17 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2009/01/25 14:21:55.17 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2009/01/25 14:21:55.17 kernel  
00:00000:00000:2009/01/25 14:21:55.18 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/01/25 14:21:55.18 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2009/01/25 14:21:55.20 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2009/01/25 14:21:55.20 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2009/01/25 14:21:55.20 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2009/01/25 14:21:55.21 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/01/25 14:21:55.23 kernel  Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2009/01/25 14:21:55.25 kernel  Using 'c:\sybase\DELL6650.cfg' for configuration information.
00:00000:00000:2009/01/25 14:21:55.25 kernel  Logging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2009/01/25 14:21:55.28 kernel  Initializing MSDTC Connection
00:00000:00000:2009/01/25 14:21:57.31 kernel  MSDTC Initialization succeeded
00:00000:00000:2009/01/25 14:21:57.31 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/01/25 14:21:57.31 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2009/01/25 14:21:57.31 kernel  *** WARNING ******************
00:00000:00000:2009/01/25 14:21:57.32 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2009/01/25 14:21:57.34 kernel  SQL Server NT process id is 0x8d0.
00:00000:00000:2009/01/25 14:21:57.34 kernel  SQL Server was started from a console window.
00:00000:00000:2009/01/25 14:21:57.35 kernel  SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2009/01/25 14:21:57.35 kernel  Network and device connection limit is 99992.
00:00000:00000:2009/01/25 14:21:57.78 server  Number of blocks left for proc headers: 38352.
00:00000:00000:2009/01/25 14:21:57.84 server  Proc header memory allocated 19176 pages for each per engine cache
00:00000:00000:2009/01/25 14:21:57.85 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2009/01/25 14:21:57.85 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2009/01/25 14:21:57.87 kernel  Initializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2009/01/25 14:21:57.87 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2009/01/25 14:21:57.89 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2009/01/25 14:21:57.89 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:2009/01/25 14:21:57.90 kernel  engine 0, os pid 648  online
00:00000:00000:2009/01/25 14:21:57.90 server  Active traceflags: 3607
00:00000:00001:2009/01/25 14:21:57.92 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10430 ESD#2/P/NT (IX86)/OS 4.0/rel12501/1794/32-bit/OPT/Tue Jul 30 17:41:42 2002'.
00:00000:00001:2009/01/25 14:21:57.93 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10322/PC Intel/BUILD125-011-1/OPT/Thu May 02 15:33:17 2002'
00:00000:00001:2009/01/25 14:21:57.95 server  Opening Master Database ...
00:00000:00001:2009/01/25 14:21:58.01 server  Loading SQL Server's default sort order and character set
00:00000:00001:2009/01/25 14:21:58.03 server  Loaded default Unilib conversion handle.
00:00000:00001:2009/01/25 14:21:58.03 server  WARNING: ***************************
00:00000:00001:2009/01/25 14:21:58.04 server  Booting without recovery
00:00000:00001:2009/01/25 14:21:58.04 server  WARNING: ***************************
00:00000:00001:2009/01/25 14:21:58.06 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2009/01/25 14:21:58.07 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2009/01/25 14:21:58.07 server  SQL Server's default sort order is:
00:00000:00001:2009/01/25 14:21:58.09 server          'bin_cp850' (ID = 50)
00:00000:00001:2009/01/25 14:21:58.09 server  on top of default character set:
00:00000:00001:2009/01/25 14:21:58.10 server          'cp850' (ID = 2).
00:00000:00001:2009/01/25 14:21:58.10 server  Master device size: 100 megabytes, or 51200 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00002:2009/01/25 14:21:58.18 kernel  network name 192.168.4.6, type ether, port 5000, filter NONE
00:00000:00000:2009/01/25 14:29:25.89 kernel  Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2009/01/25 14:29:25.89 kernel  basis_dlock: file 'c:\sybase\data\master.dat' already in use by a SQL Server
00:00000:00000:2009/01/25 14:29:25.89 kernel  kdconfig: unable to read primary master device
00:00000:00000:2009/01/25 14:29:25.89 server  kiconfig: read of config block failed

52husky

着急就容易出错，这次用ISQL 能连接到MASTER上，我可以dump tran master with truncate_only？

1017of

原因分析：
首先：从11点多的日志看，好象master库的问题已经解决了，所以，脚本中的-T3607好象已经没有作用了，建议先删除-T3607看看；
其次：11点多的日志还表明，起码有一个设备遇到存储故障，无法激活，应该会影响相应用户数据库无法恢复，这个故障用-T3607是无法恢复的，需要从存储或者系统级别去检查；
最后：14点21分，ASE server已经启动成功；在14点29分，再次启动；由于ASE server在14点21分已经启动，master设备已经被占用，所以才会报错。

建议步骤：
首先登录进入ASE server，停止ASE server；删除启动脚本中的-T3607，重新启动ASE server。检查是否所有库可使用。

52husky

几点新疑问：
1.我是否需要再对MASTER库日志进行去除？
目前使用ISQL -U -Ｓｘｘ　-ＤＭＡＳＴＥＲ可以连接上，但用dump tran master with truncate_only操作时，提示以下信息
can't dump master database's log as distributed transaction resolution isn't complete yet.please retry later.

2.当前状态可以进入ASE server，我用SYBASE CENTRAL 连接时提示‘数据库未启动’，我点选启动时提示‘数据库无法启动，请检查配置信息’
不知下步如何做，请指教。

1017of

刚才-T3607的时候，你没有做dump tran吗？god。
把-T3607加上，重新启动ASE。进入后dump tran master，如果truncate_only不行，用no_log试试。成功后，停止ASE。删除-T3607，重启ASE。