#!/bin/sh
# set SYBASE env
export SYBASE=/sybase_opd/
export SYBASE_OCS=OCS-12_5
export LIBPATH=$SYBASE/$SYBASE_OCS/lib:$SYBASE/$SYBASE_OCS/lib3p:/usr/lib:$LIBPATH
export DSQUERY=서버명
export SYBID=xx
export SYBPWD=xxxxx
# Clear old dump files
rm -rf /dbbcp_opd/*dump*
su - sybopd "-c /dbbcp_opd/NO_DEL/sys_backup $SYBPWD "
# DB Backup
$SYBASE/$SYBASE_OCS/bin/isql -U$SYBID -P$SYBPWD -SGILBASE25_OPD << EOF
exec sp_logback "OPD_DB"
go
declare @dbname varchar(30)
declare @CrruDate varchar(30)
declare @dumpfile varchar(80)
select @dbname = 'OPD_DB'
select @CrruDate = convert(char(8),getdate(),112)+":"+convert(char(8),getdate(),108)
select @dumpfile = 'compress::/dbbcp_opd/'+@dbname+'dump_'
select @dumpfile = @dumpfile + @CrruDate
dump database @dbname to @dumpfile
go
EOF
-----------------------------------------------------------------------------------------
sys_backup
echo "------> dump master database "
isql -Usa -P$1 < dump database master to "/dbbcp_opd/NO_DEL/master_dump"
go
EOF
cd /dbbcp_opd/NO_DEL/
for table_name in sysdatabases sysdevices sysusages syslogins sysloginroles sysconfigures syscurconfigs
do
echo "------> BCP OUT (master..${table_name}) n"
bcp master..${table_name} out ${table_name}.bcp -Usa -P$1 -c
done
echo "------> copy interfaces "
cp $SYBASE/interfaces /dbbcp_opd/NO_DEL/
echo "------> copy .cfg file "
cp $SYBASE/ASE-12_5/*.cfg /dbbcp_opd/NO_DEL/
echo "------> copy master.dat DEVICE "
cp $SYBASE/DBDEVICE/master.dat /dbbcp_opd/NO_DEL/
이렇게 하면 된다는 군요 .
사실 이건 저희 회사 DB 백업 방법임다.
자동으로 해주더라구여.
참고하시구여
이게 맞는 답이었음 좋겠당 ^^
수거하세여
|