use master
go
dump transaction MBFEWKDB with no_log
go
dump transaction MBFEHISDB with no_log
go
use master
go
dump database MBFEWKDB to 'MBFEWKDB.bak'
go
use master
go
dump database MBFEHISDB to 'MBFEHISDB.bak'
go
use master
go
dump transaction MBFEWKDB with no_log
go
dump transaction MBFEHISDB with no_log
go
quit
------------------------------------------------------------
use master
go
dump transaction DIRWAYSDB with no_log
go
dump transaction DISWAYSDB with no_log
go
use master
go
dump database DIRWAYSDB to 'DIRWAYSDB.bak'
go
use master
go
dump database DISWAYSDB to 'DISWAYSDB.bak'
go
use master
go
dump transaction DIRWAYSDB with no_log
go
dump transaction DISWAYSDB with no_log
go
quit
备份脚本;
DATE=`date "+%Y%m%d"`
. ~/.bash_profile
isql -Usa -P <<!
dump database cddb to '/home/sybase/dbbak/$DATE.cddb.bak'
go
dump database hddb to '/home/sybase/dbbak/$DATE.hddb.bak'
go
dump transaction cddb with no_log
go
dump transaction hddb with no_log
go
!
清理日志脚本;
$ cat /sybase/sbin/logclear
#!/bin/ksh
SYBASE=/sybase
DSQUERY=SYBASE
PATH=$SYBASE:$SYBASE/bin:$SYBASE/install:$PATH:.
LD_LIBRARY_PATH=/sybase/lib:$LD_LIBRARY_PATH
export SYBASE DSQUERY PATH LD_LIBRARY_PATH
EDITOR=vi;export EDITOR
cat $HOME/sbin/logclear.sql |isql -Usa -P
$ cat $HOME/sbin/logclear.sql
use master
go
dump transaction MBFEWKDB with no_log
go
dump transaction MBFEHISDB with no_log
go
dump transaction DIRWAYSDB with no_log
go
dump transaction DISWAYSDB with no_log
go
恢复SYBASE:
isql -Usa -P <<!
load database cddb from '/home/sybase/dbbak/$DATE.cddb.bak'
go
online database cddb
go
load database hddb from '/home/sybase/dbbak/$DATE.hddb.bak'
go
online database hddb
go
shutdown SYB_BACKUP
go
shutdown
go
!
sybase 备份和恢复
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
上一篇:servlet上传文件报错(一)
下一篇:rm: cannot remove `/home/cn0000/log/formlog.20140417': Read-only file system
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
备份和恢复
SpringData
图形化 命令行 经验分享