#!/bin/ksh -p

# Author: Gil Standen

# write_backup_files.ksh (subroutine to write the dynamically-generated backup 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 tstatus=$8

export RF=$9

#. ${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/tablespace_copy_scripts/

if [ $tstatus = 'Tablespacealtered' ]

then

echo ' ' >> ${TMPFILE}

echo 'if [ -r '$dest$sfname'.*.gz ]' >> ${TMPFILE}

echo 'then' >> ${TMPFILE}

echo 'rm '$dest_prev$sfname'.*.gz ]' >> ${TMPFILE}

echo 'mv '$dest$sfname'.*.gz '$dest_prev'. &' >> ${TMPFILE}

echo 'fi' >> ${TMPFILE}

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' | read pwc" >> ${TMPFILE}

echo 'while [ $pwc -gt '$n' ]' >> ${TMPFILE}

echo 'do' >> ${TMPFILE}

echo 'sleep 2' >> ${TMPFILE}

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' | read pwc" >> ${TMPFILE}

echo 'done' >> ${TMPFILE}

echo "ps -ef | grep 'cat' | grep -ic '$ORACLE_SID' >> $9" >> ${TMPFILE}

echo 'cat '$lfname' | gzip -1 -c > '$dest$sfname'.'$ext1'.gz &' >> ${TMPFILE}

echo ' ' >> ${TMPFILE}

fi

exit