hi guys, not too sure whether this is the right forum to post up the below script and ask for understanding.
ORACLE_HOME=/opt/ora10g/oracle/product/10.2.0/db_1;export ORACLE_HOME
PATH=.:$ORACLE_HOME/bin:/usr/bin;export PATH
ORACLE_SID=USUP
PASS=Figomom#0;export PASS
rm /orabkup/USUP/*.Z
if [[ ! -f /tmp/system_reboot.flg ]]
then
echo $PASS | sqlplus system@USUP @/home/ora10g/crons/scripts/hot.sql
echo $PASS | sqlplus system@USUP @/home/ora10g/crons/scripts/hotback.sql
fi
#compress /orabkup/USUP/*.dbf
#compress /orabkup/USUP/*.DBF
I am not too sure what is
PASS=Figomom#0;export PASS and
*if [[ ! -f /tmp/system_reboot.flg ]]*
the above script suppose to do a hot backup . is a user- managed hot backup.