Automatic backup of Linux Oracle database automatic compression script code _linux shell

Copy Code code as follows:

#!
#backup. Sh
# #系统名称
Sysname=gz
syspath=/home/oracle/databak/$sysname/
v_date=$ (date ' +%y%m%d%h%m%s ')
logfile= $syspath/backup. $v _date.log
Echo backup_time>> $logfile
Date ' +%y-%m-%d%h:%m:%s ' >> $logfile
#数据库使用情况
echo "Backup Gznxt" >> $logfile
echo "Start_time" >> $logfile
Date ' +%y-%m-%d%h:%m:%s ' >> $logfile
cd/home/oracle/product/10.2.0
Export oracle_home=/home/oracle/product/10.2.0
Export path= $PATH:/home/oracle/product/10.2.0/bin
Export ORACLE_SID=DB
Echo $syspath
v_date=$ (date ' +%y%m%d%h%m%s ')
Exp gz/gz file= $syspath/gznxt$v_date.dmp compress=n >> $logfile
echo "End_time" >> $logfile
Date ' +%y-%m-%d%h:%m:%s ' >> $logfile
#压缩备份的数据文件
Gzip $syspath/*.dmp