清除Sybase日志满的情况

admin

做以记录！

查看Sybase运行日志文件，会发现运行日志文件里记录了日志满的情况，如下：

Symptom:
The sybase in ims is stop. Hossim can not push image to das. The das is stop in flamingo.
And checked the sybase log, LOG FULL error is found:
/logs/sybase_error.log:
01:00000:00280:2007/12/18 10:16:11.50 server  Space available in the log segment has fallen critically low in database 'ims'.  All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.
02:00000:00535:2007/12/18 10:16:11.55 server  background task message: LOG FULL: Transactions in database 'ims' are suspended.
02:00000:00535:2007/12/18 10:16:11.55 server  background task message: LOG FULL: To recover, do an incremental backup to dump the transaction log.



【解决办法】

方法一：手工清除
ISU570:/local/sybase> isql -Usa -P
1> use ims
2> go
1> dump transaction ims with truncate_only
2> go

方法二：打开chkpt选项，Sybase会自动清除
1> use master
2> go
1> sp_dboption ims, "trunc log on chkpt", true
2> go