background image
<< Create a pfile if using spfile | Oracle Configuration >>
<< Create a pfile if using spfile | Oracle Configuration >>

Get the userdump

Oracle on the Linux OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
D-10
Remote Mirroring of an Oracle Database Using Data Replicator Software
WHERE name='spfile';
exit
EOF`
if [ ${SPFILE_LOCATION} != "" ]
then
${ORACLE_HOME}/bin/sqlplus -s <<EOF > /dev/null 2>&1
/ as sysdba
set heading off
set feedback off
CREATE PFILE FROM SPFILE;
exit
EOF
fi
if [ -f ${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora ]
then
echo 0
else
echo 1
fi
Get the
userdump
Destination Location on the
Primary Site
#!/bin/ksh
#-----------------------------------------------------------
# get the user_dump_dest location
#-----------------------------------------------------------
ORACLE_SID=$1
ORACLE_HOME=$2
export ORACLE_SID
export ORACLE_HOME
USER_DUMP_DEST=`${ORACLE_HOME}/bin/sqlplus -s <<EOF
/ as sysdba
set heading off
set feedback off
SELECT value
FROM v\\$parameter
WHERE name='user_dump_dest';
exit
EOF`
echo ${USER_DUMP_DEST}