星期二, 9月 23, 2014

Sybase log device full的解決方式

1)  Log off all users
2)  Shutdown the server
3)  Start the server in single user mode
4)  extend the master database by xxMB's with the following command :
    alter database master on master = xx
5)  shutdown the server
6)  restart the server
7)  do a dump tran in the master database
8)  release to users

Sol:

isql>
shutdown
go

startserver -m -f /opt/sybase/ASE-15_0/install/RUN_sybdba

dump transaction master with no_log
go
disk resize name="logdev", size="130M"
go
alter database master
log on logdev = '50m'
go

dump tran master with truncate_only

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...