Get the userdump Destination Location

Oracle on the Sun Solaris OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

C-10

Remote Mirroring of an Oracle Database Using Data Replicator Software

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

if [ -f ${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora ]

then

echo 0

else

echo 1

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}