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.
How do you run Parfile in Expdp?
In this article you also learn how we run parfile in expdp.
How do I run a Parfile in Nohup?
Using the above method you also learn how do we run a parfile nohup.
$ nohup exp_dmp.sh &
Does nohup run in background?
Yes, check above blog.
Does nohup work with SSH?
Yes, it wok. $ nohup exp_dmp.sh &