#!/bin/ksh
####################################################
### This Script is used to Export FULL DATABASE.
### This Script calls a general par file for all the databases.
### Author : ANBU S SUBRAMANIAN
### Date : 09/11/2004
### $1 is the instance name passed as a parameter. #################################################
dba_team='anbus@1234.com'
###. /u02/oracle/backups/scripts/.$1
. /oracle/.102boraenv
opwd=`cat /home/bin/.infodb.pw`
export opwd
dtstamp=`date +%m%d%Y`
exp parfile= /u02/backups/scripts/full_exp_10g_par \
file=/u02/backups/daily/$1_full_$dtstamp.dmp \
log=/u02/backups/daily/$1_full_$dtstamp.log >/dev/null 2>&1 << ENDD
$opwd@$1
ENDD
/usr/bin/cat /u02/backups/daily/$1_full_$dtstamp.log grep 'Export terminated successfully without warnings.' > /dev/null
if [ $? != 0 ]
then
mailx -s "Error in $1 full export on $dtstamp " $dba_team1< /u02/backups/daily/$1_full_$dtstamp.log
else
mailx -s "$1 full export is successful on $dtstamp" $dba_team1<
EOF
fi
/usr/bin/gzip /u02/backups/daily/$1_full_$dtstamp.dmp
/usr/bin/gzip /u02/backups/daily/$1_full_$dtstamp.log
Full Export Parameter File:
full=Y
buffer=4000000
statistics=none
No comments:
Post a Comment