Database Utilities (MOSC)

MOSC Banner

datapump performance(expdp)

edited Jun 21, 2018 10:53AM in Database Utilities (MOSC) 11 commentsAnswered
 Hi,
we have 4 node  production rac database running on windows 2003 R2(64 bits) .The database version is 10.2.0.3 and current database size is 1.2 TB.
We have scheduled daily online full backup(RMAN) which is taking almost 5 hours and taking logical backup(expdp) of business schema after office hours. the export dump size is 485 GB.
now export is taking almost 6 hours and export is delaying and overlapping RMAN backup. is there any work around that will helps to reduced expdp elapsed time.
here is my expdp script.

CALL expdp expimp/**** FULL=Y JOB_NAME=AJCPD1 EXCLUDE=SCHEMA:\" ='BACKUPDTA'\",SCHEMA:\" ='SYSMAN'\",SCHEMA:\" ='SCOTT'\",SCHEMA:\" ='QUEST'\",SCHEMA:\" ='DBAJITHK'\",SCHEMA:\" ='OLAPSYS'\",SCHEMA:\" ='DBVARGHESE'\",SCHEMA:\" ='DCM'\",SCHEMA:\" ='DBSHARIF'\",SCHEMA:\" ='SYSTEM'\" directory=AJCPRDEXPIMP dumpfile=PROD01EXP.DMP,PROD02EXP.DMP,PROD03EXP.DMP,PROD04EXP.DMP PARALLEL=4 exclude=statistics  logfile=prod64exp_%dt%.log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center