Question

请教关于 sybase数据库offline的问题

Answer 1

1> select name,status from sysdatabases
2> go
name status
------------------------------ ------
OIL -32768
config_db -32768
master -32768
model -32768
sybsystemdb -32768
sybsystemprocs -32768
tempdb -32768

现在麻烦拉，小弟搞不定了，请大哥们帮忙，感谢~~
日志：00:00000:00062:2008/04/04 17:16:44.60 server Error: 691, Severity: 20, State: 1
00:00000:00062:2008/04/04 17:16:44.60 server Encountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00132:2008/04/04 17:25:54.33 server Shutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00132:2008/04/04 17:25:54.34 server SQL Server shutdown by request.
00:00000:00132:2008/04/04 17:25:54.34 kernel ueshutdown: exiting
00:00000:00000:2008/04/04 17:29:24.99 kernel Warning: There is no valid license for ASE server product. Server is booting with all the option features disabled.
00:00000:00000:2008/04/04 17:29:25.19 kernel Using config area from primary master device.
00:00000:00000:2008/04/04 17:29:25.22 kernel Internal run-time model set for Linux - Native
00:00000:00000:2008/04/04 17:29:25.22 kernel Using 1024 file descriptors.
00:00000:00000:2008/04/04 17:29:25.22 kernel Adaptive Server Enterprise/12.5.0.1/EBF 10431 ESD#2/P/Linux Intel/Linux 2.2.14-5.0smp i686/rel12501/1792/32-bit/OPT/Mon Jul 29 22:24:47 2002
00:00000:00000:2008/04/04 17:29:25.22 kernel Confidential property of Sybase, Inc.
00:00000:00000:2008/04/04 17:29:25.22 kernel Copyright 1987, 2002
00:00000:00000:2008/04/04 17:29:25.22 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2008/04/04 17:29:25.22 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2008/04/04 17:29:25.22 kernel
00:00000:00000:2008/04/04 17:29:25.22 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2008/04/04 17:29:25.22 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2008/04/04 17:29:25.22 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2008/04/04 17:29:25.22 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2008/04/04 17:29:25.22 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2008/04/04 17:29:25.22 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2008/04/04 17:29:25.22 kernel Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2008/04/04 17:29:25.22 kernel Using '/opt/sybase-12.5/ASE/QJ_QZ.cfg' for configuration information.
00:00000:00000:2008/04/04 17:29:25.22 kernel Logging ASE messages in file '/opt/sybase-12.5/ASE/install/QJ_QZ.log'.
00:00000:00000:2008/04/04 17:29:25.47 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2008/04/04 17:29:25.49 kernel Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2008/04/04 17:29:25.49 kernel SSL Plus v3.0.8 security modules loaded successfully.
00:00000:00000:2008/04/04 17:29:25.49 kernel Network and device connection limit is 1014.
00:00000:00000:2008/04/04 17:29:26.11 server Number of blocks left for proc headers: 51152.
00:00000:00000:2008/04/04 17:29:26.20 server Proc header memory allocated 25576 pages for each per engine cache
00:00000:00000:2008/04/04 17:29:26.74 server Memory allocated for the default data cache cachelet 1: 204800 Kb
00:00000:00000:2008/04/04 17:29:26.76 server Size of the 2K memory pool: 204800 Kb
00:00000:00000:2008/04/04 17:29:26.76 kernel Initializing virtual device 0, '/opt/sybase-12.5/data/master.dat' with dsync 'on'.
00:00000:00000:2008/04/04 17:29:26.76 kernel Virtual device 0 started using standard unix i/o.
00:00000:00000:2008/04/04 17:29:26.76 kernel Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/04/04 17:29:26.77 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:2008/04/04 17:29:26.77 kernel Unix interval timer enabled for sysclk interrupts.
00:00000:00000:2008/04/04 17:29:26.77 kernel engine 0, os pid 1214 online
00:00000:00000:2008/04/04 17:29:26.78 server No active traceflags
00:00000:00001:2008/04/04 17:29:26.86 kernel libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/EBF 10431 ESD#2/P/Linux Intel/Linux 2.2.14-5.0smp i686/rel12501/1792/32-bit/OPT/Mon Jul 29 22:24:47 2002'.
00:00000:00001:2008/04/04 17:29:26.86 kernel libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF10320/DRV.12.5.0.1/Linux Intel/Linux 2.2.14-5.0smp i686/BUILD125-011-1/OPT/Thu May 2 10:02:16 2002'
00:00000:00001:2008/04/04 17:29:26.87 server Opening Master Database ...
00:00000:00001:2008/04/04 17:29:26.96 server Loading SQL Server's default sort order and character set
00:00000:00001:2008/04/04 17:29:26.96 server Loaded default Unilib conversion handle.
00:00000:00001:2008/04/04 17:29:26.99 server
*** Bypassing recovery of MASTER database
00:00000:00001:2008/04/04 17:29:27.03 server 'bin_iso_1' (ID = 50)
00:00000:00001:2008/04/04 17:29:27.03 server on top of default character set:
00:00000:00001:2008/04/04 17:29:27.03 server 'iso_1' (ID = 1).
00:00000:00001:2008/04/04 17:29:27.03 server Master device size: 100 megabytes, or 51200 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00128:2008/04/04 17:35:14.49 server Error: 691, Severity: 20, State: 1
00:00000:00128:2008/04/04 17:35:14.49 server Encountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00128:2008/04/04 17:35:55.37 server Error: 691, Severity: 20, State: 1
00:00000:00128:2008/04/04 17:35:55.37 server Encountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00064:2008/04/04 17:37:12.36 server Error: 691, Severity: 20, State: 1
00:00000:00064:2008/04/04 17:37:12.36 server Encountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00065:2008/04/04 17:37:12.36 server Error: 691, Severity: 20, State: 1
00:00000:00065:2008/04/04 17:37:12.36 server Encountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.
00:00000:00062:2008/04/04 17:37:17.73 server Error: 625, Severity: 21, State: 1
00:00000:00062:2008/04/04 17:37:17.73 server Adaptive Server failed to retrieve a row via its RID in database 'OIL' because the entry in the offset table for that RID is less than or equal to 0. Rid pageid = 0x2aa; row num = 0x0. Page pointer = 0x0x4f330800, pageno = 682, status = 0x11, objectid = 608002166, indexid = 0, level = 0.
00:00000:00033:2008/04/04 17:37:23.23 server Error: 691, Severity: 20, State: 1
00:00000:00033:2008/04/04 17:37:23.23 server Encountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.