check flashback scn
select name from v$database;
select to_char(CURRENT_SCN) from v$database;
create directory
create directory TROY_DUMP as '+DATA/TROY/EXPDP';
grant read,write on directory TROY_DUMP to public;
par file – expdp_TROY.par
userid="/ as sysdba"
directory=TROY_DUMP
dumpfile=expdp_TROY_oel6-node04_23jul2020_%U.dmp
logfile=DATA_PUMP_DIR:expdp_TROY_oel6-node04_23jul2020.log
PARALLEL=12
job_name=expdp_TROY
flashback_scn=16021873162707
full=y
ksh file – expdp_TROY.ksh
expdp parfile=expdp_TROY.par
run command
nohup ksh ./expdp_TROY.ksh > expdp_TROY.out &