hi,

I have a script which export a database evernight in a directory.

The script alos ftpies the files in the directory to another machine.

Problem is I am copying/ftping everything in the directory. This directory will grow overtime so I want to know I ftp last export in directory and not everything as is doen currently.


Thanks

This makes no sense to me. You should know what file you are exporting to so you should only ftp that file. Or you should be cleaning up at the end of ftping the file so you aren't sending more files. You should not be putting this in a directory that will have other files. You should be either setting up your file name so it is special for each day (and ftping only that one) or putting it in such a place or in such a way that it overwrites yesterday export and you still only have one file to send.

Please give more info on your set up or incorporate the suggestions given. Post OS and version and DB and version.

If it's not too, too big, why don't you post your script in here? Or at least the part of your script which copies the file to the other directory and then ftp's it to the other machine...

Like thehoghunter is suggesting, it sounds like you may have a problem with the logic in your code.

Below is the script,

Cheers


# Set enivironment variables

ORAENV_ASK=NO
ORACLE_SID=cidw1
DATESTAMP="`date +'%d%m%y%H%M'`"
PATH=/usr/dt/bin:/usr/bin:/usr/ccs/bin:/usr/ccs/lib:/usr/ucb:/etc:/usr/sbin:/usr/local/bin:/u001/oracle/product/817/bin:.
LOGDIR=/u001/home/oracle/test/dump
LOGFILE=/u001/home/oracle/export_ftp.log
SSH=/usr/local/bin/ssh

export PATH LOGFILE DATESTAMP BASE SSH ORACLE_SID EXPORT_DIR

perform_export_wiadmin()
{
cd $LOGDIR
rm test*
exp / file=test.$DATESTAMP.dmp log=test.$DATESTAMP.log owner=wi_admin >> $LOGFILE

if [ `cat $LOGFILE | grep -i "Export terminated successfully without warnings" | wc -l` = 0 ]
then
echo "####################################"
echo "** Export of WI_ADMIN Schema successful **"
echo "Scriptname:" $0
echo "Started:"$START "Completed:" `date`
echo "####################################"
# exit 0
else
echo "####################################"
echo "** Export of WI_ADMIN unsuccessful **"
echo "Scriptname:" $0
echo "Started:" $START "Completed:" `date`
echo "####################################"
exit 1
fi
}

perform_ftp()
{
cd /u001/home/oracle/test/
ftp -inv inditf2 <<EOF
user oracle robo3cop0
bin
cd /u001/home/oracle/test/dump/
mget test*.*
bye
EOF
}

main()
{
perform_export_wiadmin
perform_ftp
}
main
#exit 0

Hi,

I might be missing the point of the question but can't you just do

get test.$DATESTAMP.dmp

instead of

mget test*.*

Matt.

Thanks, you got the point still learning but I'll get there.

Cheers once again