Create backup control file
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ..
/.primary/oracle/db_suspend
Remote Mirroring of an Oracle Database Using Data Replicator Software
B-49
echo "\t<ORACLE_SID> = Oracle instance ID (ORACLE_SID)"
echo "\t<ORACLE_HOME> = Oracle Home directory (ORACLE_HOME)"
echo "\t<LOG_DIR> = Directory to log trace information"
exit 1
fi
ORACLE_SID=$1
ORACLE_HOME=$2
ADMIN_DIR=$ORACLE_HOME/admin/$ORACLE_SID
ORACLE_DUMP=$ADMIN_DIR/udump
PRI_DB_ID=oracle
HOST=`hostname`
TRACE=$3/${HOST}_${ORACLE_SID}_trace.tmp
SCRIPT_DIR=/opt/LSI_ERM
abend ()
{
# Function to handle abnormal end.
echo "#-----------------------------------------------------
------------------------" >> $TRACE
echo "# ERROR: Abnormal end for $SCRIPT_DIR/db_suspend" >>
$TRACE
echo "# Database suspend of '$ORACLE_SID' on $HOST was
aborted!" >> $TRACE
echo "#-----------------------------------------------------
------------------------" >> $TRACE
exit 1
}
umask 000
echo "#--------------------------------------------------------
---------------------" >> $TRACE
echo "# Start of $SCRIPT_DIR/db_suspend @ `date +%T`" >> $TRACE
echo "#--------------------------------------------------------
---------------------" >> $TRACE
umask 022
#------------------------------------------------------
# Check and create pfile on Primary host if required
#------------------------------------------------------
echo "# su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_check_pfile.sql | tail -1" >> $TRACE
SPFILE=$(su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_check_pfile.sql | tail -1)
if [[ ! -n $SPFILE ]]; then
echo "# su - $PRI_DB_ID -c sqlplus -s / as sysdba @
$SCRIPT_DIR/db_create_pfile" >> $TRACE
su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_create_pfile > /dev/null
STATUS=$?
