/dbbackup/oracle_expdp_dmp.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
| export ORACLE_SID=orcl
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=${ORACLE_BASE}/product/19.3.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH
BACK_DIR=/dbbackup/orcl
LOG_DIR=$BACK_DIR
DATE=$(date +%F_%H%M)
DMP_FILE=${ORACLE_SID}_full_${DATE}.dmp
LOG_FILE=${ORACLE_SID}_full_${DATE}.log
BACKUP_START_TIME=$(date +%s)
echo "backup start at `date +%Y%m%d%H%M%S`"
expdp system/Password \
directory=dump_dir \
dumpfile=$DMP_FILE \
logfile=$LOG_FILE \
full=y \
compression=all \
parallel=4
cd $BACK_DIR;
gtar -zcvf ${ORACLE_SID}_full_${DATE}.tar.gz ${ORACLE_SID}_full_${DATE}.dmp ${ORACLE_SID}_full_${DATE}.log
rm -rf $BACK_DIR/${ORACLE_SID}_full_${DATE}.dmp $BACK_DIR/${ORACLE_SID}_full_${DATE}.log
find $BACK_DIR -type f -name "*.tar.gz" -mtime +7 -delete
#find $LOG_DIR -type f -name "*.log" -mtime +7 -delete
BACKUP_STOP_TIME=$(date +%s)
(( BACKUP_TIME = (BACKUP_STOP_TIME - BACKUP_START_TIME) / 60 ))
echo "backup end at `date +%Y%m%d%H%M%S`";
echo "backup end spend $BACKUP_TIME minutes"
|