-----Original Message-----
I want to write unix script to automate archved logs backup to tape ...
After hot backup of data files is completed...
Within script how do I skip archived log file that is being written by
oracle?
-------------------------------------------------------
Here is my crontab entry (paste it back together). The "70" means start a
backup if the archive directory hits 70% full. This does NOT run around the
time when the normal backup is running.
0,30 1-18 * * * /oracle/app/oracle/admin/dbascripts/rman/check_arch_dir.ksh
70 >> /oracle/app/oracle/admin/dbascripts/rman/arch_debug 2>&1
Here is my script (which calls the backup script)
----- Snip --------------------------------------
#!/bin/ksh
PERCENT1=`/usr/bin/df -k /z01 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,"%")-1)}'`
PERCENT2=`/usr/bin/df -k /z02 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,"%")-1)}'`
PERCENT3=`/usr/bin/df -k /z03 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,"%")-1)}'`
PERCENT4=`/usr/bin/df -k /z04 | /usr/bin/nawk 'NR == 2 {print
substr($5,1,match($5,"%")-1)}'`
PERCENT1=`echo "$PERCENT1" | /usr/bin/sed 's/[^0-9]*//g'`
PERCENT2=`echo "$PERCENT2" | /usr/bin/sed 's/[^0-9]*//g'`
PERCENT3=`echo "$PERCENT3" | /usr/bin/sed 's/[^0-9]*//g'`
PERCENT4=`echo "$PERCENT4" | /usr/bin/sed 's/[^0-9]*//g'`
if [ -z "$PERCENT1" ]; then PERCENT1=0; fi
if [ -z "$PERCENT2" ]; then PERCENT2=0; fi
if [ -z "$PERCENT3" ]; then PERCENT3=0; fi
if [ -z "$PERCENT4" ]; then PERCENT4=0; fi
if [ $PERCENT1 -gt $PERCENT2 ]; then
PERCENT=$PERCENT1
else
PERCENT=$PERCENT2
fi
if [ $PERCENT3 -gt $PERCENT ]; then
PERCENT=$PERCENT3
fi
if [ $PERCENT4 -gt $PERCENT ]; then
PERCENT=$PERCENT4
fi
THRESHOLD="$1"
if [ -z "$THRESHOLD" ]; then
THRESHOLD=50
fi
if [ $PERCENT -gt $THRESHOLD ]; then
/oracle/app/oracle/admin/dbascripts/rman/backup.ksh ARCH ALL >>
/oracle/app/oracle/admin/dbascripts/rman/debug 2>&1
fi
exit 0
---------- Snip --------------------------
The backup.ksh script is a 1559 line big boy I wrote to automate a lot of
stuff and do a lot checking and verifying. I don't think you want to see
it. One thing that might be of interest is a C (not PERL!) frontend I wrote
to make SUID oracle so a non-oracle operator can start a backup by hand if
needed without us opening the permissions on any of our security-sensitive
areas.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
