数据库无法启动-请大侠们出手相助
交换机故障导致系统无法连接。更换新交换机并将服务器进行了重启，结果进行操作系统后无法启动数据库。附错误日志，请解答00:00000:00008:2009/01/25 08:12:28.68 serverCan'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 serverIncrease 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 serverError: 1105, Severity: 17, State: 4
00:00000:00008:2009/01/25 08:59:28.59 serverCan'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 serverError: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 09:31:46.95 serverFailed to open virtual socket for new connections
00:00000:00002:2009/01/25 09:38:56.10 serverError: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 10:03:35.53 serverError: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 10:03:35.53 serverFailed to open virtual socket for new connections
00:00000:00002:2009/01/25 10:04:07.46 serverError: 1605, Severity: 18, State: 1
00:00000:00002:2009/01/25 10:04:07.46 serverFailed to open virtual socket for new connections
00:00000:00009:2009/01/25 10:05:09.78 serverError: 1105, Severity: 17, State: 4
00:00000:00009:2009/01/25 10:05:09.78 serverCan'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 kernelshutdownproc: shutting down SQL Server!
00:00000:00006:2009/01/25 10:53:26.37 serverThe 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 server1 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 server1 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 server1 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 server1 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 kernelkisignal: SQL Server terminated by system shutdown.
00:00000:00000:2009/01/25 11:00:55.50 kernelueshutdown: exiting
00:00000:00000:2009/01/25 11:00:55.53 kernelshutdown waiting for engine pid 408 to exit...
00:00000:00000:2009/01/25 11:00:55.60 kernelengine pid 408 exit completed
00:00000:00000:2009/01/25 11:00:55.60 kernelAbnormal exit detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00000:2009/01/25 11:18:51.48 kernelWarning: 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 kernelUsing config area from primary master device.
00:00000:00000:2009/01/25 11:18:51.60 kernelWarning: 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 kernelUsing 100000 file descriptors.
00:00000:00000:2009/01/25 11:18:52.14 kernelAdaptive 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 kernelConfidential property of Sybase, Inc.
00:00000:00000:2009/01/25 11:18:52.14 kernelCopyright 1987, 2002
00:00000:00000:2009/01/25 11:18:52.14 kernelSybase, Inc.All rights reserved.
00:00000:00000:2009/01/25 11:18:52.14 kernelUnpublished 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 kernelThis software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/01/25 11:18:52.14 kernelInc. Use,duplication or disclosure of the software and documentation by
00:00000:00000:2009/01/25 11:18:52.14 kerneltheU.S.Governmentissubjecttorestrictions set forth in a license
00:00000:00000:2009/01/25 11:18:52.14 kernelagreementbetweentheGovernmentandSybase,Inc.orotherwritten
00:00000:00000:2009/01/25 11:18:52.14 kernelagreementspecifyingtheGovernment's rights to use the software and any
00:00000:00000:2009/01/25 11:18:52.14 kernelapplicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/01/25 11:18:52.14 kernelSybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2009/01/25 11:18:52.14 kernelUsing 'c:\sybase\DELL6650.cfg' for configuration information.
00:00000:00000:2009/01/25 11:18:52.14 kernelLogging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2009/01/25 11:18:52.15 kernelInitializing MSDTC Connection
00:00000:00000:2009/01/25 11:18:54.20 kernelMSDTC Initialization succeeded
00:00000:00000:2009/01/25 11:18:54.21 kernelkdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/01/25 11:18:54.21 kernelDirectory 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 kernelOperating 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 kernelSQL Server NT process id is 0x5f0.
00:00000:00000:2009/01/25 11:18:54.21 kernelSQL Server was started as a Service.
00:00000:00000:2009/01/25 11:18:54.21 kernelSSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2009/01/25 11:18:54.21 kernelNetwork and device connection limit is 99992.
00:00000:00000:2009/01/25 11:18:54.62 serverNumber of blocks left for proc headers: 38352.
00:00000:00000:2009/01/25 11:18:54.68 serverProc header memory allocated 19176 pages for each per engine cache
00:00000:00000:2009/01/25 11:18:54.70 serverMemory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2009/01/25 11:18:54.70 serverSize of the 2K memory pool: 8192 Kb
00:00000:00000:2009/01/25 11:18:54.70 kernelInitializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2009/01/25 11:18:54.70 kernelVirtual device 0 started using asynchronous i/o.
00:00000:00000:2009/01/25 11:18:54.70 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2009/01/25 11:18:54.70 kernelEither 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 kernelengine 0, os pid 424online
00:00000:00000:2009/01/25 11:18:54.70 serverNo active traceflags
00:00000:00001:2009/01/25 11:18:54.71 kernellibomni1 - 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 kernellibomni1 - 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 serverOpening Master Database ...
00:00000:00001:2009/01/25 11:18:54.79 serverLoading SQL Server's default sort order and character set
00:00000:00001:2009/01/25 11:18:54.82 serverLoaded default Unilib conversion handle.
00:00000:00001:2009/01/25 11:18:54.84 serverRecovering database 'master'.
00:00000:00001:2009/01/25 11:18:55.01 serverRedo pass of recovery has processed 14 committed and 3 aborted transactions.
00:00000:00001:2009/01/25 11:18:55.06 serverChecking external objects.
00:00000:00001:2009/01/25 11:18:55.07 serverDatabase 'master' is now online.
00:00000:00001:2009/01/25 11:18:55.07 serverThe transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2009/01/25 11:18:55.07 serverWarning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2009/01/25 11:18:55.09 serverserver is unnamed
00:00000:00001:2009/01/25 11:18:55.10 serverActivating disk 'center'.
00:00000:00001:2009/01/25 11:18:55.10 kernelInitializing virtual device 2, 'D:\center\center.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.14 kernelVirtual device 2 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.14 serverActivating disk 'center1'.
00:00000:00001:2009/01/25 11:18:55.14 kernelInitializing virtual device 4, 'D:\center\center1.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.34 kernelVirtual device 4 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.34 serverActivating disk 'center1log'.
00:00000:00001:2009/01/25 11:18:55.34 kernelInitializing virtual device 5, 'D:\centerlog\center1log.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.37 kernelVirtual device 5 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.37 serverActivating disk 'center2'.
00:00000:00001:2009/01/25 11:18:55.37 kernelInitializing virtual device 6, 'D:\center\center2.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.57 kernelVirtual device 6 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.57 serverActivating disk 'center2log'.
00:00000:00001:2009/01/25 11:18:55.59 kernelInitializing virtual device 7, 'D:\centerlog\center2log.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.79 kernelVirtual device 7 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.79 serverActivating disk 'center3'.
00:00000:00001:2009/01/25 11:18:55.79 kernelInitializing virtual device 23, 'D:\center\center3.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.82 kernelVirtual device 23 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.82 serverActivating disk 'centerlog'.
00:00000:00001:2009/01/25 11:18:55.82 kernelInitializing virtual device 3, 'D:\centerlog\centerlog.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.84 kernelVirtual device 3 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.84 serverActivating disk 'data'.
00:00000:00001:2009/01/25 11:18:55.84 kernelInitializing virtual device 24, 'E:\txdata\data.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.89 kernelVirtual device 24 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.89 serverActivating disk 'data2'.
00:00000:00001:2009/01/25 11:18:55.89 kernelInitializing virtual device 26, 'e:\txdata\data2' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.92 kernelVirtual device 26 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.92 serverActivating disk 'data2_log'.
00:00000:00001:2009/01/25 11:18:55.92 kernelInitializing virtual device 27, 'e:\txdata\data2_log' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:55.93 kernelVirtual device 27 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:55.93 serverActivating disk 'data_log'.
00:00000:00001:2009/01/25 11:18:56.98 kernelInitializing virtual device 13, 'E:\hisdata\hisdatalog.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.00 kernelVirtual device 13 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.00 serverActivating disk 'log'.
00:00000:00001:2009/01/25 11:18:57.00 kernelInitializing virtual device 31, 'F:\log.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.29 kernelVirtual device 31 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.29 serverActivating disk 'sysprocsdev'.
00:00000:00001:2009/01/25 11:18:57.29 kernelInitializing virtual device 1, 'c:\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.31 kernelVirtual device 1 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.31 serverActivating disk 'tempdb'.
00:00000:00001:2009/01/25 11:18:57.31 kernelInitializing virtual device 8, 'D:\centerlog\tempdb.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.34 kernelVirtual device 8 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.34 serverActivating disk 'tempdb_data'.
00:00000:00001:2009/01/25 11:18:57.68 kernelInitializing virtual device 19, 'E:\txdata\txdata2.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:57.89 kernelVirtual device 19 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:57.89 serverActivating disk 'txdata3'.
00:00000:00001:2009/01/25 11:18:57.89 kernelInitializing virtual device 20, 'E:\txdata\txdata3.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:58.10 kernelVirtual device 20 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:58.10 serverActivating disk 'txlog'.
00:00000:00001:2009/01/25 11:18:58.10 kernelInitializing virtual device 21, 'E:\txdata\txlog.dat' with dsync 'on'.
00:00000:00001:2009/01/25 11:18:58.12 kernelVirtual device 21 started using asynchronous i/o.
00:00000:00001:2009/01/25 11:18:58.14 kernelSQL Server system exception (0xc0000005) generated by a storage access violation.
00:00000:00001:2009/01/25 11:18:58.73 kernelpc: 0x00689E7F cfg__locate_bynumber+ 0x4d (0x00006F63, 0x00000002, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.73 kernelpc: 0x00689E7F cfg__locate_bynumber+ 0x4d (0x20037038, 0x23483ED4, 0x00000000, 0x01F7FE8B)
00:00000:00001:2009/01/25 11:18:58.73 kernelpc: 0x0064355B cfg__getsyscfgvals+ 0x93 (0x01F7FE74, 0x00000016, 0x01F7FCF4, 0x01F7FE8B)
00:00000:00001:2009/01/25 11:18:58.73 kernelpc: 0x00646667 cfg__restoreconfig+ 0xb3 (0x00000005, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.73 kernel
00:00000:00001:2009/01/25 11:18:58.73 kernelpc: 0x0064117C cfg_main+ 0x3fc (0x00000000, 0x00000000, 0x00000000, 0x24059658)
00:00000:00001:2009/01/25 11:18:58.75 kernelpc: 0x0040526B dsinit+ 0xf7b (0x24059658, 0x00000000, 0x00000000, 0x24059658)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A1EF27 kpntwrapper+ 0x84 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelend 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 kernelcurdb = 1 pstat = 0x0 lasterror = 0
00:00000:00001:2009/01/25 11:18:58.84 kernelpreverror = 0 transtate = 0
00:00000:00001:2009/01/25 11:18:58.84 kernelcurcmd = 0 program =
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x01F7F160, 0x77EB1F44, 0x77E621F0, 0xFFFFFFFF)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A94A4D os_get_cur_stk_desc+ 0x13a (0x01F7F160, 0x01F7EF18, 0x0000270F, 0x00000002)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A6F8BA pcstkwalk+ 0x204 (0x000F000F, 0x00000002, 0x0000270F, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A6F544 ucstkgentrace+ 0x224 (0x000F000F, 0x00000001, 0x00BEC888, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A2969B ucbacktrace+ 0xab (0x000F000F, 0xFFFFFFFF, 0xC0000005, 0x2348394C)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00406FC1 terminate_process+ 0xb8f (0xC0000005, 0x7800BDB5, 0x01F7F4E0, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A1E47B kiexception+ 0x2e0 (0x24059658, 0x00000000, 0x00000000, 0x24059658)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x00A1EFA7 kpntwrapper+ 0x104 (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelpc: 0x77E6B388 KERNEL32.dll (0x00000000, 0x00000000, 0x00000000, 0x00000000)
00:00000:00001:2009/01/25 11:18:58.84 kernelend of stack trace, spid 1, kpid 983055, suid 0 是MASTER库空间不足？请大侠列出详细操作步骤。谢谢！ 我参考前期贴子内容修改了数据库启动文件，但用SYBASE CENTRAL管理器仍法启动数据库，不知问题出自哪里？
rem
rem Adaptive Server Information:
remname: DELL6650
remmaster device: c:\sybase\data\master.dat
remserver page size: 2048
remmaster device size: 100
remerrorlog: c:\sybase\ASE-12_5\install\errorlog
reminterfaces: 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 好象第二次启动，master库已经recover完成，问题不在master库上。
请注意2009/01/25 11:18:58.14那一行，好象有存储问题，导致E:\txdata\txlog.dat无法activating，建议检查存储或系统相关问题；
按道理，如果是非master库问题，ASE server一般应该可以起来，只是某些用户库无法online，请仔细检查。
ps:大过节的也不休息啊？呵呵，我正好上来晃了一圈~~~ 如果master没有问题了，请把-T3607取消 按法王建议方法，用批处理执行数据库启动后的日志信息：
00:00000:00000:2009/01/25 14:18:57.70 kernelWarning: 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 kernelbasis_dlock: file 'c:\sybase\data\master.dat' already in use by a SQL Server
00:00000:00000:2009/01/25 14:18:57.71 kernelkdconfig: unable to read primary master device
00:00000:00000:2009/01/25 14:18:57.73 serverkiconfig: read of config block failed
00:00000:00006:2009/01/25 14:21:30.82 kernelshutdownproc: shutting down SQL Server!
00:00000:00006:2009/01/25 14:21:30.87 kernelXP Server is not running.
00:00000:00006:2009/01/25 14:21:30.87 serverSQL Server shutdown by request.
00:00000:00006:2009/01/25 14:21:30.89 kernelueshutdown: exiting
00:00000:00000:2009/01/25 14:21:54.57 kernelWarning: 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 kernelUsing config area from primary master device.
00:00000:00000:2009/01/25 14:21:54.60 kernelWarning: 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 kernelUsing 100000 file descriptors.
00:00000:00000:2009/01/25 14:21:55.15 kernelAdaptive 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 kernelConfidential property of Sybase, Inc.
00:00000:00000:2009/01/25 14:21:55.15 kernelCopyright 1987, 2002
00:00000:00000:2009/01/25 14:21:55.17 kernelSybase, Inc.All rights reserved.
00:00000:00000:2009/01/25 14:21:55.17 kernelUnpublished 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 kernelThis software contains confidential and trade secret information of Sybase,
00:00000:00000:2009/01/25 14:21:55.18 kernelInc. Use,duplication or disclosure of the software and documentation by
00:00000:00000:2009/01/25 14:21:55.20 kerneltheU.S.Governmentissubjecttorestrictions set forth in a license
00:00000:00000:2009/01/25 14:21:55.20 kernelagreementbetweentheGovernmentandSybase,Inc.orotherwritten
00:00000:00000:2009/01/25 14:21:55.20 kernelagreementspecifyingtheGovernment's rights to use the software and any
00:00000:00000:2009/01/25 14:21:55.21 kernelapplicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2009/01/25 14:21:55.23 kernelSybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2009/01/25 14:21:55.25 kernelUsing 'c:\sybase\DELL6650.cfg' for configuration information.
00:00000:00000:2009/01/25 14:21:55.25 kernelLogging ASE messages in file 'c:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2009/01/25 14:21:55.28 kernelInitializing MSDTC Connection
00:00000:00000:2009/01/25 14:21:57.31 kernelMSDTC Initialization succeeded
00:00000:00000:2009/01/25 14:21:57.31 kernelkdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2009/01/25 14:21:57.31 kernelDirectory 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 kernelOperating 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 kernelSQL Server NT process id is 0x8d0.
00:00000:00000:2009/01/25 14:21:57.34 kernelSQL Server was started from a console window.
00:00000:00000:2009/01/25 14:21:57.35 kernelSSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2009/01/25 14:21:57.35 kernelNetwork and device connection limit is 99992.
00:00000:00000:2009/01/25 14:21:57.78 serverNumber of blocks left for proc headers: 38352.
00:00000:00000:2009/01/25 14:21:57.84 serverProc header memory allocated 19176 pages for each per engine cache
00:00000:00000:2009/01/25 14:21:57.85 serverMemory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2009/01/25 14:21:57.85 serverSize of the 2K memory pool: 8192 Kb
00:00000:00000:2009/01/25 14:21:57.87 kernelInitializing virtual device 0, 'c:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2009/01/25 14:21:57.87 kernelVirtual device 0 started using asynchronous i/o.
00:00000:00000:2009/01/25 14:21:57.89 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2009/01/25 14:21:57.89 kernelEither 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 kernelengine 0, os pid 648online
00:00000:00000:2009/01/25 14:21:57.90 serverActive traceflags: 3607
00:00000:00001:2009/01/25 14:21:57.92 kernellibomni1 - 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 kernellibomni1 - 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 serverOpening Master Database ...
00:00000:00001:2009/01/25 14:21:58.01 serverLoading SQL Server's default sort order and character set
00:00000:00001:2009/01/25 14:21:58.03 serverLoaded default Unilib conversion handle.
00:00000:00001:2009/01/25 14:21:58.03 serverWARNING: ***************************
00:00000:00001:2009/01/25 14:21:58.04 serverBooting without recovery
00:00000:00001:2009/01/25 14:21:58.04 serverWARNING: ***************************
00:00000:00001:2009/01/25 14:21:58.06 serverWarning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2009/01/25 14:21:58.07 serverSQL Server's default unicode sort order is 'binary'.
00:00000:00001:2009/01/25 14:21:58.07 serverSQL 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 serveron 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 serverMaster device size: 100 megabytes, or 51200 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00002:2009/01/25 14:21:58.18 kernelnetwork name 192.168.4.6, type ether, port 5000, filter NONE
00:00000:00000:2009/01/25 14:29:25.89 kernelWarning: 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 kernelbasis_dlock: file 'c:\sybase\data\master.dat' already in use by a SQL Server
00:00000:00000:2009/01/25 14:29:25.89 kernelkdconfig: unable to read primary master device
00:00000:00000:2009/01/25 14:29:25.89 serverkiconfig: read of config block failed 着急就容易出错，这次用ISQL 能连接到MASTER上，我可以dump tran master with truncate_only？ 原因分析：
首先：从11点多的日志看，好象master库的问题已经解决了，所以，脚本中的-T3607好象已经没有作用了，建议先删除-T3607看看；
其次：11点多的日志还表明，起码有一个设备遇到存储故障，无法激活，应该会影响相应用户数据库无法恢复，这个故障用-T3607是无法恢复的，需要从存储或者系统级别去检查；
最后：14点21分，ASE server已经启动成功；在14点29分，再次启动；由于ASE server在14点21分已经启动，master设备已经被占用，所以才会报错。
建议步骤：
首先登录进入ASE server，停止ASE server；删除启动脚本中的-T3607，重新启动ASE server。检查是否所有库可使用。 几点新疑问：
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 连接时提示‘数据库未启动’，我点选启动时提示‘数据库无法启动，请检查配置信息’
不知下步如何做，请指教。 刚才-T3607的时候，你没有做dump tran吗？god。
把-T3607加上，重新启动ASE。进入后dump tran master，如果truncate_only不行，用no_log试试。成功后，停止ASE。删除-T3607，重启ASE。
页:
[1]
2