Oh..Archive Log

Filed under: HP-UX, Oracle, Poetry — Wrote on Monday, May 19th, 2008 @ 4:23 pm

Damn…
when project upgrade veritas netbackup from 5.0 to 6.0 never shown their progress.
and the database archive log was grown rapidly, so for the quickly action, I build this script.
works on HP-UX environments


#!/usr/bin/sh
# moving archive log
#####################################
bdf -l /oracle/archivelog | grep -iv Filesystem |awk '{print $6" "$5}' | while
read LINE; do
ASS=`echo $LINE | cut -d"%" -f1 | awk '{ print $2 }'`
if [ $ASS -gt 95 ]; then
/usr/bin/find /oracle/archivelog -name "*.arc" -type f -exec mv {} /backup/archive_may/ \;
fi
done

combination with the crontab..

$ crontab -l
* * * * * sh /scripting/arsip.sh >/dev/null 2>&1

Simple, stupid but deadly.

© it’s simply a matter of a time…