#!/bin/bash
source ~/.bash_profile

#create or replace directory dumpdir as '/tools/backup/expdp'
#execute sys.dbms_metadata_util.load_stylesheets;
#select * from dba_directories

scriptdir=/U01/app/backup_stage/scripts
backupdir=/U01/app/backup_stage/expdp_bak
filename=${ORACLE_SID}_`date +%Y%m%d`

expdp \'/ as sysdba\' directory=dumpdir dumpfile=${filename}_%U.dmp logfile=${filename}.log filesize=4096M full=y
sqlplus -s '/as sysdba' <  ${scriptsdir}/dbinfo.sql

#find ${backupdir}/  -name  '*.dmp' -mtime +5 -exec rm -f {} \;