Is there any place I can retrieve a cron job for a nightly export? I would like implement nightly exports on our production databases in addition to our current backup procedures.
Here is a script that I've used to perform nightly exports in cron. You'll have to make adjustments for your specific environment.
# This script is run every nightly to export the database.
setenv ORAENV_ASK NO
#for each SID, do
foreach SID ( ORCL )
setenv ORACLE_SID $SID
compress < $PIPE_HOME/exp_pipe > $EXP_HOME/exp_full.dmp.Z &
exp file=$PIPE_HOME/exp_pipe full=y log=$LOG_HOME/exp_full.log
userid=system < $SCRIPT_HOME/security/passwd > /dev/null
mv $LOG_HOME/exp_full.log $LOG_HOME/exp_`date '+%h%d'`
Feel free to use and modify the above script for your purposes.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.