#!/bin/bash
export ORACLE_HOME=/vol0/app/oracle/product/11.2.0/db_1
export ORACLE_SID=XLR
export EXPORT_FOLDER=/vol0/pump
DATE=$(date +"%Y%m%d")
$ORACLE_HOME/bin/expdp \"/ as sysdba\" full=y directory=PUMP \
dumpfile=$DATE-${ORACLE_SID}_full_export.dmp logfile=$DATE-${ORACLE_SID}_full_export.log \
flashback_time=SYSTIMESTAMP
tar cjf $EXPORT_FOLDER/$DATE-${ORACLE_SID}_full_export.tar.bz2 \
$EXPORT_FOLDER/$DATE-${ORACLE_SID}_full_export.dmp \
$EXPORT_FOLDER/$DATE-${ORACLE_SID}_full_export.log
rm $EXPORT_FOLDER/$DATE-${ORACLE_SID}_full_export.dmp $EXPORT_FOLDER/$DATE-${ORACLE_SID}_full_export.log
find $EXPORT_FOLDER/*${ORACLE_SID}_full_export.tar.bz2 -mtime +15 -delete
No comments:
Post a Comment