Start local Oracle database

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

C-14

Remote Mirroring of an Oracle Database Using Data Replicator Software

${ORACLE_HOME}/bin/sqlplus -s <<EOF >> ${TRACE}

/ as sysdba

@${ORA_DUMP}/startup_backup_control.sql

exit

EOF

Shut Down the Oracle Database on the Remote

Site

#!/bin/ksh

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

# shutdown Oracle database

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

PRI_DB_ID=$1

ORACLE_SID=$2

ORACLE_HOME=$3

ORA_DUMP=$4

LOG=$5

TRACE=$6

RMT_SCRIPT_DIR=$7

ORACLE_BASE=$8

PRI_HOST=$9

export PRI_DB_ID

export ORACLE_SID

export ORACLE_HOME

export ORA_DUMP

export LOG

export TRACE

export RMT_SCRIPT_DIR

export ORACLE_BASE

export PRI_HOST

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

# set up soft links for Oracle dump areas and configuration files

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

su - ${PRI_DB_ID} -c "${RMT_SCRIPT_DIR}/.remote/oracle/

db_create_softlinks ${PRI_DB_ID} ${ORACLE_SID} ${ORACLE_HOME}

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

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

# Start local Oracle database with backup controlfile #

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

su - ${PRI_DB_ID} -c "${RMT_SCRIPT_DIR}/.remote/oracle/

db_start_with_backup_controlfile ${ORACLE_SID} ${ORACLE_HOME}

${ORA_DUMP} ${TRACE}" >> $TRACE 2>&1

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

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