happyyzm 发表于 2008-04-04 12:32

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

系统版本Linux 7.0 PS tuxedo8.0 数据库12-5

现在看数据库：
> sp_helpdb OIL
2> go
quit
name                     db_size       owner                  dbid
       created      
       status                                                                                                
------------------------ ------------- ------------------------ ------
       --------------
       ------------------------------------------------------------------------------------------------------
OIL                        6000.0 MB sa                            4
       Jun 28, 2004
       select into/bulkcopy/pllsort, trunc log on chkpt, offline                                             

(1 row affected)
device_fragments               size          usage               
       created             free kbytes                  
------------------------------ ------------- --------------------
       ------------------- ------------------------------
dev_db1                        2000.0 MB   data only         
       Jun 28 20042:35AM          1698476               
dev_db2                        2000.0 MB   data only         
       Jun 28 20042:35AM          2040000               
dev_db3                        1000.0 MB   data only         
       Jun 28 20042:35AM          1020000               
dev_log1                     1000.0 MB   log only            
       Jun 28 20042:35AM not applicable               
                                                               
--------------------------------------------------------------
log only free kbytes = 947312            
发现数据已经offline 了，服务器上的服务都不正常。

查看sybase日志：00:00000:00001:2008/04/03 14:51:17.20 serverBoot Count: 206
00:00000:00001:2008/04/03 14:51:17.21 serverChecking external objects.
00:00000:00001:2008/04/03 14:51:17.21 serverThe transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:17.24 serverDatabase 'sybsystemdb' is now online.
00:00000:00001:2008/04/03 14:51:17.29 serverRecovering database 'model'.
00:00000:00001:2008/04/03 14:51:17.32 serverChecking external objects.
00:00000:00001:2008/04/03 14:51:17.32 serverThe transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:17.36 serverDatabase 'model' is now online.
00:00000:00001:2008/04/03 14:51:17.36 serverThe logical pagesize of the server is 2 Kb.
00:00000:00001:2008/04/03 14:51:17.36 server0 dump conditions detected at boot time
00:00000:00001:2008/04/03 14:51:17.36 serverResident Node id: dfc4d77ec974
00:00000:00001:2008/04/03 14:51:17.36 serverTransaction coordinator initialized.
00:00000:00001:2008/04/03 14:51:17.36 serverClearing temp db
00:00000:00001:2008/04/03 14:51:32.85 serverThe transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:32.87 serverDatabase 'tempdb' is now online.
00:00000:00001:2008/04/03 14:51:32.95 serverRecovering database 'sybsystemprocs'.
00:00000:00001:2008/04/03 14:51:35.66 serverChecking external objects.
00:00000:00001:2008/04/03 14:51:35.98 serverThe transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:36.01 serverDatabase 'sybsystemprocs' is now online.
00:00000:00002:2008/04/03 14:51:36.02 kernelnetwork name QJ_QZ, type ether, port 4100, filter NONE
00:00000:00001:2008/04/03 14:51:36.07 serverRecovering database 'OIL'.

查看TUXEDO日志：141525.QJ_QZ!communication.1305.1024.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed
141525.QJ_QZ!communication.1306.1024.0: 04-03-2008: Tuxedo Version 8.0, 32-bit
141525.QJ_QZ!communication.1306.1024.0: LIBTUX_CAT:262: INFO: Standard main starting
141533.QJ_QZ!communication.1306.1024.0: connect error
141533.QJ_QZ!communication.1306.1024.0: CONNECT error:code=[-921]
[Database 'OIL' has not been recovered yet - please wait and try again.



请各位帮我看看是什么问题？该如何解决。在次感谢！！

chuxu 发表于 2008-04-04 13:57

是否执行了load database OIL？
online database OIL

happyyzm 发表于 2008-04-04 14:15

没有重新行过load database OIL，服务器只是菪机后，重新启动服务器就发现offline了。

hobbylu 发表于 2008-04-04 17:48

sybase日志不够2详细

chuxu 发表于 2008-04-04 19:42

如果没有执行load的话，猜想是设备的问题，设备权限改了？看sybase的log

happyyzm 发表于 2008-04-04 21:13

现在的数据库状态为
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 serverError: 691, Severity: 20, State: 1
00:00000:00062:2008/04/04 17:16:44.60 serverEncountered 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 serverShutdown with nowait detected - SQL Server process level execution bindings will be cleared on startup.
00:00000:00132:2008/04/04 17:25:54.34 serverSQL Server shutdown by request.
00:00000:00132:2008/04/04 17:25:54.34 kernelueshutdown: exiting
00:00000:00000:2008/04/04 17:29:24.99 kernelWarning: 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 kernelUsing config area from primary master device.
00:00000:00000:2008/04/04 17:29:25.22 kernelInternal run-time model set for Linux- Native
00:00000:00000:2008/04/04 17:29:25.22 kernelUsing 1024 file descriptors.
00:00000:00000:2008/04/04 17:29:25.22 kernelAdaptive 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 kernelConfidential property of Sybase, Inc.
00:00000:00000:2008/04/04 17:29:25.22 kernelCopyright 1987, 2002
00:00000:00000:2008/04/04 17:29:25.22 kernelSybase, Inc.All rights reserved.
00:00000:00000:2008/04/04 17:29:25.22 kernelUnpublished 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 kernelThis software contains confidential and trade secret information of Sybase,
00:00000:00000:2008/04/04 17:29:25.22 kernelInc.   Use,duplication or disclosure of the software and documentation by
00:00000:00000:2008/04/04 17:29:25.22 kerneltheU.S.Governmentissubjecttorestrictions set forth in a license
00:00000:00000:2008/04/04 17:29:25.22 kernelagreementbetweentheGovernmentandSybase,Inc.orotherwritten
00:00000:00000:2008/04/04 17:29:25.22 kernelagreementspecifyingtheGovernment's rights to use the software and any
00:00000:00000:2008/04/04 17:29:25.22 kernelapplicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2008/04/04 17:29:25.22 kernelSybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2008/04/04 17:29:25.22 kernelUsing '/opt/sybase-12.5/ASE/QJ_QZ.cfg' for configuration information.
00:00000:00000:2008/04/04 17:29:25.22 kernelLogging ASE messages in file '/opt/sybase-12.5/ASE/install/QJ_QZ.log'.
00:00000:00000:2008/04/04 17:29:25.47 kernelkdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2008/04/04 17:29:25.49 kernelDirectory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2008/04/04 17:29:25.49 kernelSSL Plus v3.0.8 security modules loaded successfully.
00:00000:00000:2008/04/04 17:29:25.49 kernelNetwork and device connection limit is 1014.
00:00000:00000:2008/04/04 17:29:26.11 serverNumber of blocks left for proc headers: 51152.
00:00000:00000:2008/04/04 17:29:26.20 serverProc header memory allocated 25576 pages for each per engine cache
00:00000:00000:2008/04/04 17:29:26.74 serverMemory allocated for the default data cache cachelet 1: 204800 Kb
00:00000:00000:2008/04/04 17:29:26.76 serverSize of the 2K memory pool: 204800 Kb
00:00000:00000:2008/04/04 17:29:26.76 kernelInitializing virtual device 0, '/opt/sybase-12.5/data/master.dat' with dsync 'on'.
00:00000:00000:2008/04/04 17:29:26.76 kernelVirtual device 0 started using standard unix i/o.
00:00000:00000:2008/04/04 17:29:26.76 kernelWorker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2008/04/04 17:29:26.77 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:2008/04/04 17:29:26.77 kernelUnix interval timer enabled for sysclk interrupts.
00:00000:00000:2008/04/04 17:29:26.77 kernelengine 0, os pid 1214online
00:00000:00000:2008/04/04 17:29:26.78 serverNo active traceflags
00:00000:00001:2008/04/04 17:29:26.86 kernellibomni1 - 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 kernellibomni1 - 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 May2 10:02:16 2002'
00:00000:00001:2008/04/04 17:29:26.87 serverOpening Master Database ...
00:00000:00001:2008/04/04 17:29:26.96 serverLoading SQL Server's default sort order and character set
00:00000:00001:2008/04/04 17:29:26.96 serverLoaded 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 serveron 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 serverMaster device size: 100 megabytes, or 51200 virtual pages. (A virtual page is 2048 bytes.)
00:00000:00128:2008/04/04 17:35:14.49 serverError: 691, Severity: 20, State: 1
00:00000:00128:2008/04/04 17:35:14.49 serverEncountered 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 serverError: 691, Severity: 20, State: 1
00:00000:00128:2008/04/04 17:35:55.37 serverEncountered 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 serverError: 691, Severity: 20, State: 1
00:00000:00064:2008/04/04 17:37:12.36 serverEncountered 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 serverError: 691, Severity: 20, State: 1
00:00000:00065:2008/04/04 17:37:12.36 serverEncountered 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 serverError: 625, Severity: 21, State: 1
00:00000:00062:2008/04/04 17:37:17.73 serverAdaptive 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 serverError: 691, Severity: 20, State: 1
00:00000:00033:2008/04/04 17:37:23.23 serverEncountered invalid logical page '0' while accessing object '14' in database '2'. This is an internal system error. Please contact Sybase Technical Support.

happyyzm 发表于 2008-04-04 21:22

还有我不能把STATUS改为0 ,老是报"attempt to begin tranasction in database 'aa' failed because database is in bypass recovery mode"错误,

hobbylu 发表于 2008-04-07 08:27

tempdb库有问题，另外OIL库也存在着某个表的625错误，问题应该说比较严重，但也并不表示不能恢复
页: [1]
查看完整版本: 请教关于 sybase数据库offline的问题，急~