Schema dump export taking too long
Hallo!I am doing a schema export of a 110 GB schema.My backup script is as belowexport DATE=$(date +%Y-%m-%d-%H-%M)expdp dumpfile=CBKLPROD_${DATE}.dmp logfile=CBKLPRODEXP_${DATE}.log directory=oradump5 schemas=CBKLPROD.The backup has been running for almost 3 hours and it has been stuck at the pointProcessing object type SCHEMA_EXPORT/JOBfor 2 and a half hours.I it normal for this to happen.I used the same script to backup the schema when it was 80 GB and the schema export took 1 hour.I am sure that the export is still running as the dump file is increasing and the Datapump job is showing EXECUTING when I do SELECT * FROM DBA_DATAPUMP_JOBS;
0