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


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.


expdp parfile=/u01/export_data.par

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

$ chmod 744

Step 3: expdp jobs in background

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

$ nohup &

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.

How do you run Parfile in Expdp?

In this article you also learn how we run parfile in expdp.
expdp parfile=/u01/export_data.par

How do I run a Parfile in Nohup?

Using the above method you also learn how do we run a parfile nohup.
$ nohup &

Does nohup run in background?

Yes, check above blog.

Does nohup work with SSH?

Yes, it wok. $ nohup &

Leave a Comment