• Arun Kumar

Schedule Datapump Export in crontab

Backups using EXP / EXPDP is at times useful than RMAN as it allows to take backups of specific tables and does not require db in archivelog mode.


Create EXPDP Job


  1. Create a file which contains

EXPDP script: /home/oracle/backup_script

export DATE=$(date +%m_%d_%y_%H_%M)
export ORACLE_SID=orcl
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

$ORACLE_HOME/bin/expdp username/password@sid directory=export_dir dumpfile=backup_$DATE.dmp logfile=backup_$DATE.log full=y

2. To schedule EXPDP backup in CRONTAB: Backup every day at 20:00 (8:00 PM)

# crontab –e –u oracle
00 20 * * * /home/oracle/backup_script

3. The first five fields are

  • Minute (0-59)

  • Hour (0-23)

  • Day of month (1-31)

  • Month of year (1-12)

  • Day of week (0-6)

Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

Automate RMAN Backups using Shell Scripts

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback