Processing log and trace files
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
erm.ksh
Remote Mirroring of an Oracle Database Using Data Replicator Software
B-39
echo `date +%T`" ERROR! - Can not mount all volume
copies!" >> $LOG
echo `date +%T`" Check $RMT_DB_TRACE" >> $LOG
exit 1
fi
#-----------------------------------------------
# Restarting local database (crossing fingers)
#-----------------------------------------------
display "Restarting local database"
$RMT_SCRIPT_DIR/.remote/$DB_TYPE/db_start $CFG_FILE $TIME_STAMP
> /dev/null 2>>$TRACE
STATUS=$?
if (( STATUS > 0 )); then
Kill_WAIT 1
echo "\t${B1}ERROR:${EB} Bummer, can't restart local
database!"
echo "\tCheck the $RMT_DB_TRACE file for details."
echo `date +%T`" ERROR! - Can not restart local database!"
>> $LOG
echo `date +%T`" Check $RMT_DB_TRACE" >> $LOG
else
echo `date +%T`" SUCCESS - Local database has been
restarted" >> $LOG
Kill_WAIT 0
fi
#---------------------------------
# Processing log and trace files
#---------------------------------
ESTATUS=`cat $LOG |grep -c 'ERROR'`
WSTATUS=`cat $LOG |grep -c 'WARNING'`
echo "\nArchiving trace files...\c"
tar -cvf $RMT_LOG_DIR/${TIME_STAMP}_trace_files.tar
$PRI_DB_TRACE $RMT_DB_TRACE $TRACE $LOG > /dev/null 2>&1
gzip $RMT_LOG_DIR/${TIME_STAMP}_trace_files.tar > /dev/null 2>&1
rm $TRACE > /dev/null
rm $PRI_DB_TRACE > /dev/null
rm $RMT_DB_TRACE > /dev/null
echo "${B2} OK ${EB}"
if [[ $ESTATUS != 0 || $WSTATUS != 0 ]]; then
echo `date +%T`" *** $ESTATUS ERROR(S) occurred during
script execution! ***" >> $LOG
echo `date +%T`" *** $WSTATUS WARNINGS(S) occurred during
script execution! ***" >> $LOG
echo "\n${B1}$ESTATUS ERROR(S)${EB} and ${B3}$WSTATUS
WARNING(S)${EB} occurred during this script execution!"
echo "\nPlease check the ${B3}$LOG${EB} and"
echo "${B3}$TRACE${EB}files!\n"
