系统版本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.
请各位帮我看看是什么问题?该如何解决。再次感谢!!