# Script: dbb_gen_all.shl
# Purpose: Create the list of PROD, PPRD, TRNG, and SEED database files
#          to be backed up, including the unzip scripts, the PROD textual
#          control files, and all of the databases' datafiles and other
#          associated files.
#
# Let the unzip files (see below) be the first files in the backup list.
# (Note: bkupnum set by dbbackup.shl script.)
#
rm zipem.shl
rm unzipem.shl
rm backemup.dat
echo /u05/oradata/PROD.gzip${bkupnum}/unzipem.shl >>backemup.dat
echo /u05/oradata/PPRD.gzip${bkupnum}/unzipem.shl >>backemup.dat
echo /u05/oradata/TRNG.gzip${bkupnum}/unzipem.shl >>backemup.dat
echo /u05/oradata/SEED.gzip${bkupnum}/unzipem.shl >>backemup.dat
#
# Add the current set of textual control files to the list of files that
# are to be backed up.  Also, create the gzip and gunzip shell files to
# zip (compress) those files before backing up and to unzip (uncompress)
# those files if they ever need restoring.  (The backup will run against
# the list of zipped files.)
#
find /u00/oracle/admin/PROD/udump -name "*.trc" ! -type d 2>/dummy |
  sort -t/ -k3 >backup_list.lst
dbb_gen_cmds.shl PROD
#
# Create the list of PROD, PPRD, TRNG, and SEED datafiles and other files
# that need to be backed up.
#
dbb_gen_list.shl PROD
dbb_gen_cmds.shl PROD
#
dbb_gen_list.shl PPRD
dbb_gen_cmds.shl PPRD
#
dbb_gen_list.shl TRNG
dbb_gen_cmds.shl TRNG
#
dbb_gen_list.shl SEED
dbb_gen_cmds.shl SEED
#
# We don't want to restore control files or online redo log files,
# in most cases, so, comment them out in the unzip shell file.  (They
# can be uncommented if they are really needed during a restore.)
#
cat unzipem.shl | sed "s/\(.*\/ctrl.*\.ctl\)/# \1/" |
  sed "s/\(.*\/log.*\.rdo\)/# \1/" >unzipemx.shl
mv -f unzipemx.shl unzipem.shl