PART II: - Beyond a basic Oracle EXP/IMP shell script: Error Handling & Exit 2005-08-31 - By oracle@(protected)
There's a million ways to do what you're wanting to do. Here's some
cutesy things I do within bash scripts.... $? is your friend.
BCVStatus=0
/opt/emc/WideSky/V5.3.0/bin/symmir -g DBNAME verify DB1-DBNAME BCV ld
BCV-DBNAME -synched > /dev/null 2>&1
BCVStatus=$?
until [ "$BCVStatus" = 0 ]
do
sleep 5;
/opt/emc/WideSky/V5.3.0/bin/symmir -g DBNAME verify DB1-DBNAME
BCV ld BCV-DBNAME -synched > /dev/null 2>&1
BCVStatus=$?;
done
Copious output for reading cron output after getting to the office...
echo "`/bin/date +%H:%M:%S` Export D_S tables"
$ORACLE_HOME/bin/exp / file=/e07/oracle/export/exp_das_$TSTAMP.dmp
TABLES=BLAH1,BLAH2
LOG=/d02/app/oracle/admin/DBNAME/adhoc/logs/exp_das_$TSTAMP.log
STATUS=$?
if [ $STATUS -gt 0 ]; then
echo "*** Export encountered errors - errorlevel $STATUS"
echo "*** Export encountered errors - errorlevel $STATUS" |
/usr/ucb/mail -s "DBNAME refresh failed: Export D_S encountered errors"
dba@(protected)
exit 1
fi
echo "`/bin/date +%H:%M:%S` Export D_S tables complete"
hope this helps
--
http://www.freelists.org/webpage/oracle-l
|
|
