Oracle EXPDP (Datapump) backup on Multiple locations
Welcome Back to KSH Infotainment.
Oracle Datapump backup on Multiple locations
----------------------------------------------------------
Overview
----------
We have 1 mount point for backup , but it does not have sufficient space for complete backup.
But it can hold 40-50% , Along with this we have another mount point which have sufficient space to
store the rest 50% of backup.
So , We will split our backup in both mount points using datapump.
Pre-Requisite:
-------------------
1) Parallel parameter is mandatory since we are using multiple paths/dumps.
2) Not supported in Standard edition.
3) Filesize parameter.
My Setup:
-----------
Oracle 12c
DB Size : 2 GB
Backup Size : Approx 600MB.
Available Mount Points :
Filesystem Size Used Avail Use% Mounted on
/dev/sdg 388M 2.3M 366M 1% /bkp1
/dev/sdf 388M 2.3M 366M 1% /bkp2
syntax:
----------
dumpfile=DIRECTORY1:DUMPFILE1,DIRECTORY2:DUMPFILE2,........ logfile=DIRECTORY1:LOGFILE parallel=2... filesize=300m
expdp system/sys full=y dumpfile=BKP1:expdp_full_DP_1.dmp,BKP2:expdp_full_DP_2.dmp logfile=BKP1:expdp_full.log parallel=2 filesize=300m
If it helps you then Please like and subscribe to support this small effort.
