Скачать или смотреть 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.