background image
<< Put Oracle database in backup mode | Archive current log file >>
<< Put Oracle database in backup mode | Archive current log file >>

End backup mode of database

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
./.primary/oracle/db_resume
Remote Mirroring of an Oracle Database Using Data Replicator Software
B-51
echo "ERROR: Unable to create $ORACLE_DUMP/
remote_startup.sql script" >> $TRACE
abend
else
echo "INFO: Oracle startup script = $ORACLE_DUMP/
remote_startup.sql" >> $TRACE
fi
#-----------------------------------------------------
# Put Oracle database in backup mode on Primary host
#-----------------------------------------------------
echo "# su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_begin_backup.sql" >> $TRACE
su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_begin_backup.sql > /dev/null 2>>$TRACE
STATUS=$?
echo "STATUS: $STATUS" >> $TRACE
if (( $STATUS > 0 )); then
echo "ERROR: Unable to alter database for backup." >> $TRACE
abend
else
echo "INFO: Database $ORACLE_SID is now in backup mode (`date
+%T`)" >> $TRACE
fi
# Sync filesystem to ensure files are stable
sync; sync
echo "#--------------------------------------------------------
---------------------" >> $TRACE
echo "# End of $SCRIPT_DIR/db_suspend @ `date +%T`" >> $TRACE
echo "#--------------------------------------------------------
---------------------" >> $TRACE
exit 0
./.primary/oracle/db_resume
#!/bin/ksh
#-------------------------------------------------------------
# Created by LSI Logic, all rights reserved.
# File: db_resume
# Author: J. Koopmann
# Date: 10/01/06
# Last Update: 02/15/2007 - rlp
#-------------------------------------------------------------
#-------------------------------------------
# Resume primary database from backup mode
#-------------------------------------------