Suspend the Database

Oracle on the Sun Solaris OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

C-2

Remote Mirroring of an Oracle Database Using Data Replicator Software

############################################################

# remove soft links for Oracle dump areas and configuration files

############################################################

${RMT_SCRIPT_DIR}/.remote/oracle/db_remove_softlinks

${PRI_DB_ID} ${ORACLE_SID} ${ORACLE_HOME} ${ORACLE_BASE}

${TRACE} ${PRI_HOST} >> $TRACE 2>&1

${RMT_SCRIPT_DIR}/.remote/oracle/db_offline ${PRI_DB_ID}

${ORACLE_SID} ${TRACE} >> $TRACE

exit $?

Suspend the Database on the Primary Site

#!/bin/ksh

#-----------------------------------------------------------

# put primary database in suspend mode

#-----------------------------------------------------------

PRI_DB_ID=$1

ORACLE_SID=$2

ORACLE_HOME=$3

ORA_DUMP=$4

LOG=$5

TRACE=$6

PRI_SCRIPT_DIR=$7

PRI_HOST=$8

export PRI_DB_ID

export ORACLE_SID

export ORACLE_HOME

export ORA_DUMP

export LOG

export TRACE

export PRI_SCRIPT_DIR

export PRI_HOST

####################################

# Create pfile on Primary host #

####################################

rcp ${PRI_SCRIPT_DIR}/.primary/oracle/db_create_pfile

$PRI_HOST:$PRI_SCRIPT_DIR/. >> ${TRACE}

rsh $PRI_HOST chown $PRI_DB_ID $PRI_SCRIPT_DIR/db_create_pfile

>> ${TRACE}

STATUS=`rsh $PRI_HOST -l $PRI_DB_ID $PRI_SCRIPT_DIR/

db_create_pfile ${ORACLE_SID} ${ORACLE_HOME}` >> ${TRACE}

if [ $STATUS != 0 ]

then

echo "ERROR!\n\tUnable to create pfile on primary database"

>> $LOG