Alter database begin backup
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
./.primary/oracle/db_archive_log_current.sql
Remote Mirroring of an Oracle Database Using Data Replicator Software
B-53
if (( $STATUS > 0 )); then
echo "ERROR: Unable to take database $ORACLE_SID out of
backup mode." >> $TRACE
abend
else
echo "INFO: Database $ORACLE_SID is now online (`date +%T`)"
>> $TRACE
fi
#---------------------------
# Archive current log file
#---------------------------
echo "# su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_archive_log_current.sql" >> $TRACE
su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_archive_log_current.sql > /dev/null 2>>$TRACE
STATUS=$?
echo "STATUS: $STATUS" >> $TRACE
if (( $STATUS > 0 )); then
echo "ERROR: Unable to archive current log file on
$ORACLE_SID." >> $TRACE
abend
else
echo "INFO: Current log file on $ORACLE_SID has been
archived." >> $TRACE
fi
echo "#--------------------------------------------------------
---------------------" >> $TRACE
echo "# End of $SCRIPT_DIR/db_resume @ `date +%T`" >> $TRACE
echo "#--------------------------------------------------------
---------------------" >> $TRACE
exit 0
./.primary/oracle/
db_archive_log_current.sql
set pagesize 0
set heading off
set feedback off
set ver off
set linesize 200
ALTER SYSTEM ARCHIVE LOG CURRENT;
exit sql.sqlcode