Q
Problem solve Get help with specific problems with your technologies, process and projects.

Performing nightly exports in cron

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.

#! /bin/csh
# export_SID_full.sh
#
# This script is run every nightly to export the database.
setenv ORAENV_ASK NO
unsetenv SQLPATH
set SCRIPT_HOME=/directory/scripts
set EXP_HOME=/directory/export
set LOG_HOME=/directory/scripts/logs
set PIPE_HOME=/directory/tmp

#for each SID, do
foreach SID ( ORCL )
setenv ORACLE_SID $SID
source /usr/local/bin/coraenv
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'`
end

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close