Put Oracle database in backup mode
Oracle on the AIX OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B-50
Remote Mirroring of an Oracle Database Using Data Replicator Software
echo "STATUS: $STATUS" >> $TRACE
SPFILE=$(su - $PRI_DB_ID -c sqlplus -s / as sysdba @
$SCRIPT_DIR/db_check_pfile.sql | tail -1)
fi
echo "INFO: \$SPFILE=$SPFILE" >> $TRACE
#---------------------------------------------
# Create backup control file on Primary host
#---------------------------------------------
echo "# su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_backup_controlfile.sql" >> $TRACE
su - $PRI_DB_ID -c sqlplus -s / as sysdba @ $SCRIPT_DIR/
db_backup_controlfile.sql > /dev/null
STATUS=$?
echo "STATUS: $STATUS" >> $TRACE
if (( $STATUS > 0 )); then
echo "ERROR: Unable to create backup control file" >> $TRACE
abend
else
CONTROL=$(ls -t $ORACLE_DUMP/*.trc | head -1)
head -17 $CONTROL >> $TRACE
cp $CONTROL $ORACLE_DUMP/backup_control.sql > /dev/null 2>&1
fi
#----------------------------------------------
# Create startup sql script from control file
#----------------------------------------------
# echo "# grep -nw 'STARTUP NOMOUNT' $CONTROL | head -1 | awk -
F':' '{print \$1}'" >> $TRACE
CNTRL_START=$(grep -nw 'STARTUP NOMOUNT' $CONTROL | head -1 | awk
-F':' '{print $1}')
echo "INFO: \$CNTRL_START=$CNTRL_START" >> $TRACE
# echo "# grep -nw 'End of tempfile' $CONTROL | head -1 | awk -
F':' '{print \$1}'" >> $TRACE
CNTRL_END=$(grep -nw 'End of tempfile' $CONTROL | head -1 | awk
-F':' '{print $1}')
echo "INFO: \$CNTRL_END=$CNTRL_END" >> $TRACE
echo "# head -$CNTRL_END $CONTROL | tail +$CNTRL_START | sed '/
^--/d' > $ORACLE_DUMP/remote_startup.sql" >> $TRACE
head -$CNTRL_END $CONTROL | tail +$CNTRL_START | sed '/^--/d' >
$ORACLE_DUMP/remote_startup.sql
echo "\nEXIT sql.sqlcode" >> $ORACLE_DUMP/remote_startup.sql
chown oracle:oinstall $ORACLE_DUMP/remote_startup.sql > /dev/
null 2>&1
sleep 1
if [[ ! -f $ORACLE_DUMP/remote_startup.sql ]]; then
