#!/bin/bash
#设置定时导出文件夹
folder=/oracleBackup/$(date '+%Y%m%d');
#如果文件夹不存在就创建
if [ ! -d $folder ];then
  mkdir $folder
fi
#oracle环境变量
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin:/usr/java/jdk1.8.0_181-amd64/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/swftools/bin/:/root/bin
#导出命令
exp scott/tiger@orcl owner=huasheng file=$folder/hs_$(date '+%Y%m%d%H%M%S').dmp;