Q

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.

This was last published in December 2003

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close