LSI Logic ERM Solution

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

./.primary/oracle/db_create_pfile.sql

Remote Mirroring of an Oracle Database Using Data Replicator Software

B-55

set linesize 200

CREATE PFILE FROM SPFILE;

exit sql.sqlcode

./.primary/oracle/db_create_pfile.sql

set pagesize 0

set heading off

set feedback off

set ver off

set linesize 200

ALTER DATABASE END BACKUP;

exit sql.sqlcode

./goodies/move_ora_admin_files.ksh

#!/bin/ksh

#--------------------------------------------------

# File: move_ora_admin_files.ksh

# Author: R. Paxton

# Date: 02/14/2007

#--------------------------------------------------

#-------------------------------------------------------------

# This file is used to move the $ORACLE_HOME/admin/$ORACLE_SID

# directory structure to a volume that will be mirrored via

# ERM. This file will move the directories and create links

# in the original directories for the new locations.

#-------------------------------------------------------------

typeset -u ANS

B0=`tput smso`

B1=`tput setaf 1``tput setab 0`

B2=`tput setaf 2``tput setab 0`

B3=`tput setaf 3``tput setab 0`

EB=`tput sgr0`

clear

if [[ `whoami` != "oracle" ]]; then

echo "This file must be run as user: ${B0} oracle ${EB}

${B1}STATUS=9${EB}\n"

exit 9