NetBackup SAP ASE Backup

Netbackup SAP ASE 백업

#!/usr/bin/ksh
#Sybase Database Backup

BPBACKUP_POLICY=NCCI1_SYBASE
BPBACKUP_SCHED=Default-Application-Backup

LOG=/usr/openv/sybase/log/full_log.`/usr/bin/date +'%Y%m%d'`
echo "##### Sybase Online Backup Start ##### `/usr/bin/date +%H:%M`" >> $LOG

/usr/bin/su - sybase15 -c "
/data/sybase15/OCS-15_0/bin/isql -Usa -P"패스워드" << EOF

print 'backup ccris_db'
dump database ccris_db to 'sybackup::'
go

print 'backup ccris_test'
dump database ccris_test to 'sybackup::'
go

print 'backup master'
dump database master to 'sybackup::'
go

print 'backup model'
dump database model to 'sybackup::'
go

print 'backup nccris_01'
dump database nccris_01 to 'sybackup::'
go

print 'backup nccris_02'
dump database nccris_02 to 'sybackup::'
go

print 'backup sybsyntax'
dump database sybsyntax to 'sybackup::'
go

print 'backup sybsystemdb'
dump database sybsystemdb to 'sybackup::'
go

print 'backup sybsystemprocs'
dump database sybsystemprocs to 'sybackup::'
go

quit
EOF

" >> $LOG 2>&1

echo "##### Sybase Online Backup Complete ##### `/usr/bin/date +%H:%M`" >> $LOG