Check Datapump dump file is corrupted or not

Hi, in this article we are going to learn how to check datapump dump file is corrupted or not. Actually, sometimes we face the situation. We take the export backup a long time back and we are not sure the dump file is still valid or not. Sometimes the application team says the dump file is corrupted which is provided by you.

Table of Contents

Check Datapump dump file is corrupted or not

So here is the easiest way to check the dumpfile is corrupted or not. Using the below command we can verify the dump file.

How to import DDL only

$impdp directory=dir dumpfile=scott.dmp logfile=imp_scott.log sqlfile=to_check_corruption_ddl.sql

In the above example, we used the sqlfile parameter. This is never be going to import any data it is just written DDL statements in the file. Which we mention in the command (to_check_corruption_ddl.sql). So it’ll read the entire dumpfile and will report if any corruption is deducted.

Use Checksum with expdp

The checksum is also used to check the dumpfile validation. Use the below query to use the checksum.

$ expdp system@ocpdb TABLES=scott.emp directory=dir DUMPFILE=emp.dmp CHECKSUM=yes REUSE_DUMPFILES=yes

Click here to Read More about checksum

Read – How to use REMAP_TABLE parameter in impdp utility

Connect with me on:

Instagram: https://www.instagram.com/digitalshripal/
Linkedin: 
https://www.linkedin.com/in/shripal-singh
Twitter: 
https://twitter.com/ocptechnology
Facebook: 
https://www.facebook.com/ocptechnology
YouTube:
https://www.youtube.com/ocptechnology

2 thoughts on “Check Datapump dump file is corrupted or not”

Leave a Comment

%d bloggers like this:
Enable Notifications    OK No thanks