#!/bin/ksh -p

# Author: Gil Standen

# write_recovery_files.ksh (subroutine to write the dynamically-generated recovery scripts)

#

# To implement on production, take following steps:

# Change "st2" to "spr" using :%s/st2/spr/gc

# Change "ft2" to "fpr" using "%s/ft2/fpr/gc

#

# verify existence of $ORACLE_HOME/pfcs"xx".env file before implementing this script on a new

# environment.

# where "xx" is [ pr, t2, d1, ... ]

##################################################################################################

[ "${DEBUG}" = "TRUE" ] && set -x

export ORACLE_SID=$1

export n=$2

export ext1=$3

export TMPFILE=$4

export xx=$5

export lfname=$6

export sfname=$7

export recovery_file=$8

export RF=$9

cd /home/orapf"$xx"

. .profile

cd /home/orapf"$xx"/osbmenu

#. ${ORACLE_HOME}/pfcs"$xx".env

export dest=/mnt/pfcs/pfcs"$xx"/HOTBACKUP/backup/

export dest_prev=/mnt/pfcs/pfcs"$xx"/HOTBACKUP/backup2/

export dest_files=/mnt/pfcs/pfcs"$xx"/HOTBACKUP/datafile_recovery_scripts/

echo ' ' >> $recovery_file

echo 'if [ -r '$dest$sfname'.*.gz ]' >> $recovery_file

echo 'then' >> $recovery_file

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' | read pwc" >> $recovery_file

echo 'while [ $pwc -gt '$n' ]' >> $recovery_file

echo 'do' >> $recovery_file

echo 'sleep 2' >> $recovery_file

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' | read pwc" >> $recovery_file

echo 'done' >> $recovery_file

echo 'cat '$dest$sfname'.*.gz | gunzip > '$lfname' &' >> $recovery_file

echo 'else' >> $recovery_file

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' | read pwc" >> $recovery_file

echo 'while [ $pwc -gt '$n' ]' >> $recovery_file

echo 'do' >> $recovery_file

echo 'sleep 2' >> $recovery_file

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' | read pwc" >> $recovery_file

echo 'done' >> $recovery_file

echo 'cat '$dest_prev$sfname'.*.gz | gunzip > '$lfname' &' >> $recovery_file

echo 'fi' >> $recovery_file

exit