sybase 备份和恢复

use mastergodump transaction MBFEWKDB with no_loggodump transaction MBFEHISDB with no_loggouse mastergodump database MBFEWKDB to 'MBFEWKDB.bak'gouse mastergodump database MBFEHISDB to 'MBFEHISDB.bak'gouse mastergodump transaction MBFEWKDB with no_loggodump transaction MBFEHISDB with no_loggoquit------------------------------------------------------------use mastergodump transaction DIRWAYSDB with no_loggodump transaction DISWAYSDB with no_loggouse mastergodump database DIRWAYSDB to 'DIRWAYSDB.bak'gouse mastergodump database DISWAYSDB to 'DISWAYSDB.bak'gouse mastergodump transaction DIRWAYSDB with no_loggodump transaction DISWAYSDB with no_loggoquit备份脚本；DATE=`date "+%Y%m%d"`. ~/.bash_profileisql -Usa -P <<!dump database cddb to '/home/sybase/dbbak/$DATE.cddb.bak'godump database hddb to '/home/sybase/dbbak/$DATE.hddb.bak'godump transaction cddb with no_loggodump transaction hddb with no_loggo!清理日志脚本；$ cat /sybase/sbin/logclear#!/bin/kshSYBASE=/sybaseDSQUERY=SYBASEPATH=$SYBASE:$SYBASE/bin:$SYBASE/install:$PATH:.LD_LIBRARY_PATH=/sybase/lib:$LD_LIBRARY_PATHexport SYBASE DSQUERY PATH LD_LIBRARY_PATHEDITOR=vi;export EDITORcat $HOME/sbin/logclear.sql |isql -Usa -P$ cat $HOME/sbin/logclear.sqluse mastergodump transaction MBFEWKDB with no_loggodump transaction MBFEHISDB with no_loggodump transaction DIRWAYSDB with no_loggodump transaction DISWAYSDB with no_loggo恢复SYBASE:isql -Usa -P <<!load database cddb from '/home/sybase/dbbak/$DATE.cddb.bak'goonline database cddbgoload database hddb from '/home/sybase/dbbak/$DATE.hddb.bak'goonline database hddbgoshutdown SYB_BACKUPgoshutdowngo!