#!/bin/bash PATH=$PATH:$HOME/bin ORACLE_BASE=/data01/oracleDB ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 ORACLE_SID=orcl PATH=$ORACLE_HOME/bin:$PATH export ORACLE_BASE ORACLE_HOME ORACLE_SID export PATH NLS_LANG=AMERICAN_AMERICA.UTF8 export NLS_LANG #export DELTIME=`date -d "15 days ago" +%Y%m%d` export BACKUPTIME=`date +%Y%m%d%H%M%S` echo "Starting backup..." echo "Backup file path $DATA_DIR/$BAKUPTIME.dump" echo "Backuping HR system data" expdp user/user@orcl directory=DATA_PUMP_DIR_BACKUP dumpfile=user$BACKUPTIME.DUMP schemas=user #备份用户数据 echo "Delete 3 days before data files..." echo "Delete backup cycle before HR system backup data" #rm -f /data01/backup/HDSFDX_HR$DELTIME*.DUMP find /data01/backup/ -mtime +15 -name "user*.dump" -exec rm -rf {} ; #删除前15天的数据
版权声明：
本文来源网络，所有图片文章版权属于原作者，如有侵权，联系删除。
本文网址：https://www.mushiming.com/mjsbk/2876.html