datapump performance(expdp)
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
0