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 first published in December 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close