Is there any place I can retrieve a cron job for a nightly export? I would like implement nightly exports on our...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.