Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datapump export and import ( Fast method)

supersenMay 25 2016 — edited Jun 8 2016

Hello Gurus,

My requirement is to take cold backup of 145GB size database and restore it using datapump.

1) I want to back and restore only two schemas MTAS ,MTAS_MT

yesterday I took backup (expdp)

expdp mtas/mtas directory=exp_dir dumpfile=$ORACLE_SID.dmp logfile=$ORACLE_SID.log schemas=mtas,mtas_ht compression=all

it took 1 hour

2) Today I am asked to restore the same.

I will drop the tables before i import.

impdp mtas/mtas directory=imp_dir dumpfile=$ORACLE_SID.dmp schemas=mtas,mtas_ht logfile=$ORACLE_SID.log

it took 2.5 hours.

Please advise how can I speed up the activity. I have 60 cpu count.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 6 2016

Added on May 25 2016

#database-key-features, #export-import-sql-loader-external-tables

28 comments

13,705 views