#!/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 백업 방법임다.

자동으로 해주더라구여.

참고하시구여

이게 맞는 답이었음 좋겠당 ^^

수거하세여