sybase数据库offline的问题

http://t.chinaunix.net/archiver/tid-1075262.html

 

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 2004  2:35AM          1698476              
dev_db2                        2000.0 MB     data only          
         Jun 28 2004  2:35AM          2040000              
dev_db3                        1000.0 MB     data only          
         Jun 28 2004  2:35AM          1020000              
dev_log1                       1000.0 MB     log only           
         Jun 28 2004  2:35AM not applicable                
                                                               
--------------------------------------------------------------
log only free kbytes = 947312           
发现数据已经offline 了，服务器上的服务都不正常。

查看sybase日志：00:00000:00001:2008/04/03 14:51:17.20 server  Boot Count: 206
00:00000:00001:2008/04/03 14:51:17.21 server  Checking external objects.
00:00000:00001:2008/04/03 14:51:17.21 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:17.24 server  Database 'sybsystemdb' is now online.
00:00000:00001:2008/04/03 14:51:17.29 server  Recovering database 'model'.
00:00000:00001:2008/04/03 14:51:17.32 server  Checking external objects.
00:00000:00001:2008/04/03 14:51:17.32 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:17.36 server  Database 'model' is now online.
00:00000:00001:2008/04/03 14:51:17.36 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2008/04/03 14:51:17.36 server  0 dump conditions detected at boot time
00:00000:00001:2008/04/03 14:51:17.36 server  Resident Node id: dfc4d77ec974
00:00000:00001:2008/04/03 14:51:17.36 server  Transaction coordinator initialized.
00:00000:00001:2008/04/03 14:51:17.36 server  Clearing temp db
00:00000:00001:2008/04/03 14:51:32.85 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:32.87 server  Database 'tempdb' is now online.
00:00000:00001:2008/04/03 14:51:32.95 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2008/04/03 14:51:35.66 server  Checking external objects.
00:00000:00001:2008/04/03 14:51:35.98 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2008/04/03 14:51:36.01 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2008/04/03 14:51:36.02 kernel  network name QJ_QZ, type ether, port 4100, filter NONE
00:00000:00001:2008/04/03 14:51:36.07 server  Recovering 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 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.
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错误，问题应该说比较严重，但也并不表示不能恢复