All,

I am Oracle DBA I had created a cron for exporting the dmp files of our DB
The methodoly i followed was

Create a shell script

#!/bin/bash
#Script to Perform Datapump Export Daily
############################################################################
#DATE AUTHOR CHANGE
#--------- ----------------------- -------------------
#10-DEC-2011 Dave New Script Created
############################################################################
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=test
export PATH=$PATH:$ORACLE_HOME/bin
expdt=`date +%d-%m-%Y-%H-%M`
expdp system/sys@test schemas=TEST dumpfile=TEST_$expdt.DMP directory=MY_DIR logfile=TEST_$expdt.log consistent=y
expdp system/sys@test schemas=TEST1 dumpfile=TEST1_$expdt.DMP directory=MY_DIR logfile=TEST_$expdt.log consistent=y
mv /home/oracle/ordump/TEST*.log /home/oracle/ordump/logs

Scheduled at cron

* 3 * * * /home/oracle/scripts/exp.sh 2>&1 /home/oracle/ordump/logs/CS_cron.log

Cron is working fine but the log output of cron is directed into default i,e in /var/mail/oracle although i had given the path " /home/oracle/ordump/logs/CS_cron.log"


Pls help me to resolve the logfile issue which going to default.


Any help on this is highly appreciated

Thanks
-Dave

Two things ...

You forgot the actual redirect in your script.
It's
, not
And are you sure you need to run that script so many times, every minute from 03:00 till 03:59?


Cheers,
Tink

2 members found this post helpful.

that pipes stderr to stdout and gives a parameter -- which the script never even looks at. I think you want

1 members found this post helpful.

Hi all,

Thanks for your support.

i have scheduled in the cron in this way.

* 10,13,15,19 * * * /backup-node3/oracle_scripts/exp.sh >> /backup-node3/dmp_cron_logs/exp_cron.log 2>&1

unfortunately the export is running at every minute. i want to schedule it at moring 10, afternoon 1 clok ,evening 3 and 7o clock at evening.

Pls give me some input on this

Thanks in Advance

-Dave

change
to

1 members found this post helpful.

Thank you all. I resolved my issues.