#!/bin/sh
#set environment variable
export ORACLE_SID=cddcdb
export ORACLE_HOME=/u01/app/oracle/db_1
export NLS_LANG=american_america.zhs16gbk

FILE=`date +%Y%m%d`
$ORACLE_HOME/bin/expdp system/system123 directory=dump full=y  dumpfile=CDDC_DB_$FILE.dmp logfile=dump_d:CDDC_DB_$FILE.log

find /dbbak/flashback_recovery_area/dmps/ -name "*.dmp" -mtime +30 -exec rm {} \;
find /dbbak/flashback_recovery_area/ -name "*.log" -mtime +30 -exec rm {} \;