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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.