Admin directory
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
./goodies/undo_move_admin_files.ksh
Remote Mirroring of an Oracle Database Using Data Replicator Software
B-61
if [[ ! -n $ORACLE_HOME || ! -n $ORACLE_SID ]]; then
echo "Please make sure \$ORACLE_HOME and \$ORACLE_SID are
properly set."
echo "${B1}Exit=8${EB}\n"
exit 8
fi
MIRROR_PATH=$(ls -l $ORACLE_HOME/admin/$ORACLE_SID | awk -F' '
'{print $11}' | sed "s/\/$ORACLE_SID//")
echo "\nAll files and directories from ${B0}$MIRROR_PATH/
$ORACLE_SID${EB}"
echo "\nwill be moved back to ${B0}$ORACLE_HOME/admin/
$ORACLE_SID${EB}"
echo "\nIs this correct? (Y or N) [ ]\b\b\c"
read ANS
if [[ $ANS != 'Y' ]]; then
echo "\nAborting script, no files or directories processed."
echo "${B1}Exit=5${EB}\n"
exit 5
fi
if [[ -L $ORACLE_HOME/dbs/init${ORACLE_SID}.ora ]]; then
echo "\nMoving init${ORACLE_SID}.ora...\c"
rm $ORACLE_HOME/dbs/init${ORACLE_SID}.ora > /dev/null
mv $MIRROR_PATH/$ORACLE_SID/pfile/init${ORACLE_SID}.ora
$ORACLE_HOME/dbs > /dev/null
STATUS=$?
if (( STATUS > 0 )); then
echo "${B1}ERROR!${EB}"
echo " Could not move $MIRROR_PATH/$ORACLE_SID/pfile/
init${ORACLE_SID}.ora to"
echo " $ORACLE_HOME/dbs directory.
${B1}STATUS=$STATUS${EB}"
else
echo "${B2}OK${EB}"
fi
else
echo "${B3}WARNING: No init.ora file link exists at
$ORACLE_HOME/dbs/init${ORACLE_SID}.ora${EB} -- Skipping
init.ora"
fi
if [[ -L $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora ]]; then
echo "Moving spfile${ORACLE_SID}.ora...\c"
rm $ORACLE_HOME/dbs/spfile${ORACLE_SID}.ora > /dev/null 2>&1
mv $MIRROR_PATH/$ORACLE_SID/pfile/spfile${ORACLE_SID}.ora
$ORACLE_HOME/dbs > /dev/null
