请教sybase自动备份

chyhaiouchy

sybase数据库如何进行进行自动备份？我看了论坛整理的自动备份资料，还是不明白：
1) 关于定时备份
http://www.chinaunix.net/cgi-bin/bbs/topic.cgi?forum=10&topic=1233&show=390
crontab 中可以这样写：
00 23 * * * /sybase/ASE-12_0/bin/DUMPDB.sh >;>;/sybase/ASE-12_0/install/DUMPDB.out

放那里都无所谓，一个dumpdb.sh的例子：
#SUN Solaris 8
#!/bin/ksh
export SYBASE=/sybase
export SYBASE_FTS=FTS-12_0
export PATH=/sybase/ASE-12_0/bin:/sybase/OCS-12_0/binPATH:/sybase/ASE-12_0/install:/usr/sbin
export SYBASE_OCS=OCS-12_0
export SYBASE_ASE=ASE-12_0
export LM_LICENSE_FILE=/sybase/SYSAM-1_0/licenses/license.datLM_LICENSE_FILE
export LD_LIBRARY_PATH=/sybase/ASE-12_0/lib:/usr/local/openwin/lib:/sybase/FTS-12_0/lib:/sybase/OCS-12_0/lib:/usr/local/openwin/lib:/usr/lib:/sybase/SQLRemote/libLD_LIBRARY_PATH
export SYBASE_SYSAM=SYSAM-1_0
export HOME=$SYBASE
$SYBASE_OCS/bin/isql -Usa -SSYBASE -P <<!
dump database YOURDBNAME to "/sybdump/dump.01"
stripe on "/sybdump/dump.02"
stripe on "/sybdump/dump.03"
stripe on "/sybdump/dump.04"
stripe on "/sybdump/dump.05"
go
!
这里是一个典型的脚本，用于实现full备份！
#!/usr/bin/sh
# *************************************************************************
#for full backup after excuted dbcc operation
# *************************************************************************
SHLIB_PATH=/opt/sybase/ASE-12_0/lib:/opt/sybase/FTS-12_0/lib:/opt/sybase/OCS-12_0/lib:/usr/lib:/lib:/usr/lib/Motif1.2:/opt/sybase/SQLRemote/
lib
export SHLIB_PATH
SYBASE_OCS=OCS-12_0
export SYBASE_OCS
SYBASE=/opt/sybase
export SYBASE

ISQL="/opt/sybase/OCS-12_0/bin"
ymd=`date +%y%m%d`
bk_user="unb"
bk_pwd="******"
bk_db="SYB_HP"
cd /sybase/backup
mkdir $ymd
LOG="/sybase/backup/$ymd"
echo $ymd >;$LOG/backup.log
echo "\n11*************************" >;>;$LOG/backup.log
echo "Check database $bk_db..." >;>;$LOG/backup.log
d1=`date`
su - sybase -c "isql -SSYB_HP -Usa -P****** <<DBCC >;$LOG/dbcc-$ymd.log 2>;&1
dbcc traceon(3604)
go
dbcc checkdb($bk_db)
go
dbcc traceoff(3604)
go
DBCC
echo $d1,`date` >;>;$LOG/backup.log
echo "\n22*************************" >;>;$LOG/backup.log
d1=`date`
dump_file="/sybase/backup/$dump-unb-full-$ymd.dat"
echo "Dump database $bk_db to " $dump_file >;>;$LOG/backup.log
su - sybase -c "isql -SSYB_HP -Usa -P****** <<DUMP >;$LOG/dump-$ymd.log 2>;&1
dump database $bk_db to "$dump_file"
go
DUMP
echo $d1,`date` >;>;$LOG/backup.log
echo "\n33*************************" >;>;$LOG/backup.log

谢谢！