sheduled export backup of all tablespace [message #97003] |
Wed, 17 October 2001 21:57 |
Sanjay Nag Ray
Messages: 3 Registered: October 2001
|
Junior Member |
|
|
I have made a backup script on particular time but how can i make it run on 5.00 p.m and then after 1 hour it will backup in compressed way in tap and make the database status changed after backup.
Please edit my script and send to me..
the prog is written below...
H1=$1
M1=$2
S1=$3
while true
do
H2=$(date +%H)
M2=$(date +%M)
S2=$(date +%S)
if [[ "${H1}" -lt "${H2}" ]]
then
echo " You have given wrong Hour"
exit
else
if [[ "${H1}" -eq "${H2}" ]]
then
if [[ "${M1}" -lt "${M2}" ]]
then
echo "You have given wrong Minutes "
exit
else
if [[ "${M1}" -eq "${M2}" ]]
then
if [[ "${S1}" -lt "${S2}" ]]
then
echo "You have given wrong Seconds"
exit
else
if [[ "${S1}" -eq "${S2}" ]]
then
echo "working the time"
sh sexp
fi
fi
fi
fi
fi
fi
done
echo " Data Export Done "
----------------------------------------------------------------------
|
|
|
|