Back Up the Control File

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

C-8

Remote Mirroring of an Oracle Database Using Data Replicator Software

export ORACLE_HOME

${ORACLE_HOME}/bin/sqlplus -s <<EOF > /dev/null 2>&1

/ as sysdba

ALTER DATABASE BEGIN BACKUP;

exit

EOF

echo 0

End the Online Backup on the Primary Site

#!/bin/ksh

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

# Mark the end of the online backup

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

ORACLE_SID=$1

ORACLE_HOME=$2

export ORACLE_SID

export ORACLE_HOME

${ORACLE_HOME}/bin/sqlplus -s <<EOF > /dev/null 2>&1

/ as sysdba

ALTER DATABASE END BACKUP;

exit

EOF

echo 0

Back Up the Control File on the Primary Site

#!/bin/ksh

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

# backup controlfile

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

ORACLE_SID=$1

ORACLE_HOME=$2

ORA_DUMP=$3

export ORACLE_SID

export ORACLE_HOME

export ORA_DUMP

${ORACLE_HOME}/bin/sqlplus -s <<EOF > /dev/null 2>&1

/ as sysdba

set heading off

set feedback off