Dear Experts,
I'm importing back the dump file (all 90000 tables + indexes + etc ) once I have dropped the tablespace to be reorganized of 600Gb in size (filled 10%)
The expdat.dmp is of size 37Gb having full tablespace content.
The Impdp is running SYS.BR_IMPORT_SFAFOACH db job right now since 24 hours by now performing:
direct path read temp with 1 Data Pump Worker.
I can see the CPU and disk is in used 60% (we have it on AIX , the System above oracle db is SAP)
How can I speed up this process ?
If impdp process is broken in this stage, can I consider the database content consistent ?
As I can see the tables were imported ok as well as next steps:
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
................
Import parameter:
full=y
content=all
table_exists_action=skip
parallel=1
directory=br_dumpdir_sfafoach
dumpfile=expdat.dmp
logfile=br_logdir_sfafoach:import.log
job_name=br_import_sfafoach
Export parameter:
content=all
compression=none
parallel=1
directory=br_dumpdir_sfafkvrv
dumpfile=expdat.dmp,expdat%U.dmp
filesize=100000M
tablespaces=PSAPMGI
logfile=br_logdir_sfafkvrv:export.log
job_name=br_export_sfafkvrv
Thank you,
With best regards
Grigore