Sybase12日志满的解决办法2.doc

Sybase12.5日志满问题的解决日志满分为两种情况：1.非master(用户库或者其他系统库sybsystemprocs)库的日志满，导致用户库不能访问；2.系统库master日志满，导致服务都不能正常启动。针对以上情况要分别对待处理。1.非master库日志满的处理：重庆数据库后台sybsystemprocs库日志报满：09:00000:01631:2011/11/13 06:45:36.16 server Error: 3475, Severity: 21, State: 709:00000:01631:2011/11/13 06:45:36.16 server There is no space available in SYSLOGS to log a record for which space has been reserved. This process will retry at intervals of one minute.11:00000:04104:2011/11/13 06:20:11.87 server Space available in the log segment has fallen critically low in database sybsystemprocs. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available.00:00000:02407:2011/11/13 06:20:11.89 server Error: 2812, Severity: 16, State: 500:00000:02407:2011/11/13 06:20:11.89 server Stored procedure sp_thresholdaction not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).或某个用户库etoh2_cq的日志空间满报：00:00000:00001:2008/12/02 17:28:07.38 serverError: 1105, Severity: 17, State: 300:00000:00001:2008/12/02 17:28:07.38 serverCant allocate space for object syslogs in database etoh2_cq because logsegment segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase size of the segment.00:00000:00001:2008/12/02 17:28:07.38 serverError: 3475, Severity: 21, State: 700:00000:00001:2008/12/02 17:28:07.38 serverThere is no space available in SYSLOGS for process 1 to log a record for which space has been reserved. This process will retry at intervals of one minute. The internal error number is -4.处理方法步骤：1、马上增加日志设备，并把设备分配给数据库。alter database name log on 设备名=200;-设备名泛指日志设备，如果设备文件还没在磁盘上初始化，则先需要disk init初始化设备文件，-如果是系统库，可以考虑先不加设备。go2、把数据库置于-32768状态，再把日志清除。- -32768这个状态值根据实际情况作出调整.-各状态值的含义详见我的blog:Sybase ASE12.5数据库状态值的含义。-/xujinyang/article/details/6968650sp_configure allow update,1goupdate master.sysdatabases set status=-32768 where name=数据库名goshutdown with nowait-(注意：可能会延长启动SYBASE数据库时间，若确认没有用户在用，请使用shutdown with wait)go-在sybase install目录下startserver -f RUN_etoh-启动完成isql -Usa -P -Sservername1dump tran database_namewith no_log2go3update master.sysdatabases set status=0 where name=数据库名4go5sp_configure allow update,06go7shutdown with nowait8go重启SYBASE后，日志满报错数据库正常了。2.master库日志满，已经导致数据库服务都不正常启动情况下日志如下：Recovering database master00:00000:00001:2004/03/12 10:05:27.70 server Redo pass of recovery has processed 10 committed and 0 aborted transactions.00:00000:00001:2004/03/12 10:05:27.81 server No such message: 110500:00000:00001:2004/03/12 10:05:27.81 server There is no space available in SYSLOGS for process 1 to log a record for which space has been reserved. This process will retry at intervals of one minute. The internal error number is -4.处理方法步骤：1、在启动文件中加-T3607 -m,然后用sa进dump tran master with no_log或alter database master on 设备名=xxxM 即可 -设备名泛指master库设备如还遇到以下问题：启动报：Error: 3475, Severity: 21, State: 700:00000:00006:2004/03/12 10:38:55.71 server There is no space available in SYSLOGS for process 6 to log a record for which space has been reserved. This process will retry at intervals of one minute. The internal error number is -4.用sa登陆进不去：报：Cant allocate space for object syslogs in database master becauselogsegment segment is full/has no free extents. If you ran out of space insyslogs, dump the transaction log. Otherwise, use ALTER DATABASE orsp_extendsegment to increase size of the segment.Msg 3475, Level 21, State 7:There is no space available in SYSLOGS for process 6 to log a record for whichspace has been reserved. This process will retry at intervals of one minute. Theinternal error number is -4.CT-LIBRARY error:ct_connect(): user api layer: internal Client Library error: Read from the server has timed out.2、 再加 -T699(Turn off transaction logging for the entire SQL dataserver)这次sa可进执行alter database master on ma