sybase 备份和恢复

最新推荐文章于 2019-08-07 13:37:09 发布

weixin_30892987

最新推荐文章于 2019-08-07 13:37:09 发布

阅读量162

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/3797880.html

本文提供了一套针对Sybase数据库的备份与恢复方案，包括使用T-SQL脚本进行数据库及事务日志备份的过程，并提供了清理日志的脚本。此外还详细介绍了如何将备份的数据库文件恢复到正常状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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
!

转载于:https://www.cnblogs.com/zhaoyangjian724/p/3797880.html