#!/bin/sh
# Parameter
ORACLE_HOME=$1
export ORACLE_HOME
ORACLE_SID=$2
export ORACLE_SID
ORACLE_DBNAME=$3
export ORACLE_DBNAME
NLS_LANG=$4
export NLS_LANG

# Test Parameter
if [ "$4" = ""  ]; then
   echo "Syntax: $f ORACLE_HOME ORACLE_SID ORACLE_DBNAME NLS_LANG"
   echo " "
   echo " "
   exit 2
fi
if [ ! -d $1 ]; then
   echo "Directory ORACLE_HOME=$1 not exist"
   echo " "
   exit 3
fi
if [ ! -d ${BACKUP_DEST}/${ORACLE_DBNAME} ]; then
   echo "Backup Directory ${BACKUP_DEST}/${ORACLE_DBNAME} not exist"
   echo " "
   exit 4
fi

#Enviroment for execute as cronjob
LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

# Run RMAN Script for this DB

#${ORACLE_HOME}/bin/rman target / nocatalog @${SCRIPTS}/backup.rman

# Delete old Trace of Controlfile

rm ${BACKUP_DEST}/${ORACLE_DBNAME}/controlfile_trace_${DAY_OF_WEEK}.trc

# Run Script to generate Trace of Controlfile
# Run Script to generate Copy of pfile

${ORACLE_HOME}/bin/sqlplus / as sysdba << EOScipt
ALTER DATABASE backup controlfile TO trace AS '${BACKUP_DEST}/${ORACLE_DBNAME}/controlfile_trace_${DAY_OF_WEEK}.trc';
CREATE pfile='${BACKUP_DEST}/${ORACLE_DBNAME}/init_${ORACLE_DBNAME}_${DAY_OF_WEEK}.ora' FROM spfile;
exit;
EOScipt

#Run Script to get DB Metadata Information

${ORACLE_HOME}/bin/sqlplus / as sysdba @${SCRIPTS}/info.sql

#PatchLevel of the database

$ORACLE_HOME/OPatch/opatch lsinventory > ${BACKUP_DEST}/${ORACLE_DBNAME}/software_lsinventory_${ORACLE_DBNAME}.log

#Save Password File
cp ${ORACLE_HOME}/dbs/orapw${ORACLE_SID} ${BACKUP_DEST}/${ORACLE_DBNAME}/orapw${ORACLE_SID}_${DAY_OF_WEEK}