Start dump production database instance

0.  Check the existing Datapump Jobs:


SELECT OWNER_NAME, JOB_NAME, OPERATION, JOB_MODE, ATTACHED_SESSIONS FROM DBA_DATAPUMP_JOBS;

1.  Purge the Recycle Bin Before Process the Production DB dump.

PURGE RECYCLEBIN
PURGE DBA_RECYCLEBIN
PURGE USER_RECYCLEBIN

2.  Select Count Object number for the Production DB.

~~~~~~~~~~~~~~~~~~~~~~~~for listing for all schemas~~~~~~~~~~~~~~~~~~

select owner, object_type, count(*) from dba_objects group by owner, object_type order by owner;

~~~~~~~~~~~~~~~~~~~~~~for a single schema~~~~~~~~~~~~~~~~~~~~~~~

select owner,
count(object_type) "count", object_type
from ALL_OBJECTS
where owner = 'schema_name'
group by owner, object_type;

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3.  Start to process the Production Dump File using the Compression Model and exclude the statics (During the Dump process please avoid to run it  from 8:00 PM to 2:00 AM. The best execution time is process it is from 6:00 PM to 8:00 PM, 2: 00 AM – 10:00 AM).

expdp / file=${ORACLE_SID}_norows.dmp log=${ORACLE_SID}_norows.log full=y compression=y rows=n statistics=none

4. Provide the Production DB dump file size and Dump file log.