background image
<< Used to capture Oracle user dump location | Create backup control file >>
<< Used to capture Oracle user dump location | Create backup control file >>

Function to handle abnormal end

Oracle on the AIX OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B-48
Remote Mirroring of an Oracle Database Using Data Replicator Software
#------------------------------------------------
#------------------------------------------------
# Used to capture Oracle user dump location
#------------------------------------------------
# Arguments:
#
$1 = Oracle SID ($ORACLE_SID)
#
$2 = Oracle home directory ($ORACLE_HOME)
ORACLE_SID=$1
ORACLE_HOME=$2
export ORACLE_SID ORACLE_HOME
UDUMP=`$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 $UDUMP
exit 0
.
/.primary/oracle/db_suspend
#!/bin/ksh
#-------------------------------------------------------------
# Created by LSI Logic, all rights reserved.
# File: db_suspend
# Author: J. Koopmann
# Date: 10/01/06
# Last Update: 02/15/2007 - rlp
#-------------------------------------------------------------
#-------------------------------------------------------------
# put primary database in suspend mode and create
remote_startup.sql script
#-------------------------------------------------------------
# Arguments:
#
$1 = Oracle SID
#
$2 = Oracle Home directory
#
$3 = Log directory
if [[ $# < 3 ]]; then
echo "Usage: db_suspend <ORACLE_SID> <ORACLE_HOME> <LOG_DIR>"