#!/bin/bash

if [[ $# == 2 ]]
then
  sid=$1
  ticket=$2
else
 echo " sid and ticket parameters are required $0 "
 exit
fi

if [ `uname -n` == vmsrac20.provade.com ]
then
  db_instance=${sid}1
else
  db_instance=${sid}2 
fi

export ORACLE_SID=${db_instance}
export ORACLE_HOME=`/usr/local/bin/dbhome $sid`
export PATH=$ORACLE_HOME/bin:/bin:/usr/local/bin
export parfile=/home/oracle/bin/exp_db_schema_parfile_${ticket}.sql

OUTFILE=/var/log/oracle/run_${sid}_current_scn.file
OUTFILE1=/var/log/oracle/run_${sid}_current_scn.file1

echo $OUTFILE
echo $OUTFILE1

sqlplus /nolog << EOF
connect / as sysdba
set pages 0
set lines 20
set heading off
set echo off
set feedback off
SELECT ltrim( DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER ) from dual ;
spool $OUTFILE
/
spool off
exit
EOF

/bin/grep '^[1-9]' $OUTFILE  > $OUTFILE1
/bin/echo $(cat $OUTFILE1 | /usr/bin/tr -d "\ ") > $OUTFILE
echo $OUTFILE
explog=/dumps/dp_exp_dir/exp_${sid}_${ticket}.log
flashbackscn=`cat  $OUTFILE `
expdp \'/ as sysdba\' DIRECTORY=DP_EXP_DIR DUMPFILE=exp_${sid}_${ticket}_%U.dmp logfile=exp_${sid}_${ticket}.log parfile=${parfile} FLASHBACK_SCN=${flashbackscn} cluster=N parallel=8 filesize=4GB

errfile=/var/log/oracle/export_${orasid}.err

/bin/grep "ORA-" $explog > $errfile

if [ -s $errfile ]
then
        /bin/mail -s "Oracle $ORACLE_SID export errors" pcheung@datapipe.com < $errfile
fi