Run Expdp Jobs in Background

In this article we are going to learn how to run expdp jobs in background (nohup) step by step. Keywords “nohup expdp / as sysdba”, “expdp parfile userid=/ as sysdba”, “How to run expdp in nohup”.

Steps to run export in background

Follow the below steps to run expdp/impdp in nohup.

Step 1: Create parfile

The parfile is help us to execute export jobs, we can execute all datapump commands through PARFILE.

$vi /u01/export_data.par

userid=scott/tiger
job_name=scott_tables
directory=EXP_IMP
dumpfile=SCOTT_table.dmp
logfile=SCOTT_tab.log
REUSE_DUMPFILES=y
tables=EMP,XZY

Save the above file and follow the next step.

Step 2: Now call the above script in shell script.

Create a shell script and call the above parfile inside it.

$vi exp_dmp.sh

expdp parfile=/u01/export_data.par

Save the above shell script and set executable permissions using the below command.

$ chmod 744 exp_dmp.sh

Step 3: expdp jobs in background

This is the final command which is run our export jobs in background (nohup).

$ nohup exp_dmp.sh &

Now your export backup job is running in the background. If you want to check the job details, you can use the following commands.

$jobs   - it will display the details of the running jobs

or you can monitor the expdp jobs using SQL prompt.

Click here to monitor datapump jobs

Run export in background directly

Using the following command you can run expdp directly from prompt.

$nohup expdp \"/ as sysdba\" dumpfile=expdp_data.dmp directory=exp_imp logfile=expdp_data.log FULL=Y &

Or you can use the follwoing comand which automatically create the current date directory also its iclude current date & time in file name.

$nohup expdp \"/ as sysdba\" dumpfile=expdp_PROD-$(date +%Y-%m-%d_%H-%M-%S).dmp directory=exp_imp logfile=expdp_PROD-$(date +%Y-%m-%d_%H-%M-%S).log FULL=Y &

Thanks for visitng our blog. I hope you realy learn somthing from above topc, if yes please share your fillings with us in comment box and follow us on social netwok.

Ream about RMAN.