background image
<< Restart local database | Function to handle abnormal end >>
<< Restart local database | Function to handle abnormal end >>

Used to capture Oracle user dump location

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
./.primary/oracle/db_get_udump
Remote Mirroring of an Oracle Database Using Data Replicator Software
B-47
echo "\nRESULT: \c" >> $TRACE
# su - $PRI_DB_ID "-c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_start.sql >> $TRACE" > /dev/null 2>> $TRACE
su - $PRI_DB_ID "-c sqlplus -s / as sysdba @ $ORA_DUMP/
remote_startup.sql" >> $TRACE > /dev/null 2>> $TRACE
STATUS=$?
echo "STATUS: $STATUS" >> $TRACE
if (( $STATUS > 0 )); then
echo "ERROR: Errors encountered during $ORA_DUMP/
remote_startup.sql execution" >> $TRACE
echo " Check $TRACE file for details." >> $TRACE
fi
#--------------------------
# Check database status
#--------------------------
db_status
STATUS=$?
if (( $STATUS < 1 )); then
echo "ERROR: Unable to restart local database." >> $TRACE
echo "#-----------------------------------------------------
------------------------" >> $TRACE
echo "# End of $SCRIPT_DIR/db_start @ `date +%T`" >> $TRACE
echo "#\t\tEXIT STATUS = 1" >> $TRACE
echo "#-----------------------------------------------------
------------------------" >> $TRACE
exit 1
else
echo "INFO: Local database has been restarted." >> $TRACE
echo "#-----------------------------------------------------
------------------------" >> $TRACE
echo "# End of $SCRIPT_DIR/db_start @ `date +%T`" >> $TRACE
echo "#\t\tEXIT STATUS = 0" >> $TRACE
echo "#-----------------------------------------------------
------------------------" >> $TRACE
exit 0
fi
./.primary/oracle/db_get_udump
#!/bin/ksh
#------------------------------------------------
# Created by LSI Logic, all rights reserved.
# File: db_get_udump
# Author: J. Koopmann
# Date: 10/01/2006
# Last Update: 02/16/2007 - rlp