How to repair and restore Oracle DMP file?

Published by admin on November 27, 2015

What is DMP file in Oracle?

Oracle DMP file is created by Oracle “Export/Import” tools. One can export all or a part of database into a “dump” file, then import the result in another database on different server and probably in a different versions. DMP files are usually used for exchanging data between different platforms and database and versions. One can import the set of tables belonging to a user or entire table along with other related object like procedures, triggers, constraints, etc or complete database. However, import can also be done selectively. Some users also uses it as a backup but actually it is not made for backup.

Reasons behind the corruption of Oracle DMP file

However, there are several reasons behind the corruption of oracle dmp file. They are as follow:

• Due to media corruption
• Malware/virus can infect the dmp file and make them inaccessible
• Malfunction of software or hardware problem
• Sudden shutdown of database while Oracle database is opened
• Interruptions in network connection when database is opened

In any of the above cases it is possible that your oracle dmp file may get corrupted or damaged. But not to worry below are some solutions that you can follow to restore your corrupted oracle dmp file.

Solution 1

Follow the below steps to manually restore oracle dmp file to your database:

1 – Login to your SQL command line terminal. If you are using Windows then open command prompt or if you are using Linux then open Terminal.

2 – After this login to the SQL-PLUS as a system administrator. To do this follow the below command:

“sqlplus sys/admin@ORADB as sysdba”

Eg: D:Documents and SettingsAdministrator>sqlplus sys/admin@ORADB as sysdba

3 – Now you have to create a new database user

• “create user username identified by password account unlock;” For example: create user jacob identified by jacob account unlock
• “grant connect to username;” For example: grant connect to jacob
• “grant create session, dba to jacob;” For Example: grant create session, dba to jacob

4 – Now log out from the SQL-PLUS. Use “exit” command to do this

5 – Lastly restore your dmp file by using below command:

“imp SYSTEM/test@ORADB fromuser=dbadmin touser=username IGNORE=Y FILE=file_path.dmp”

For Example: D:Documents and SettingsAdministrator>imp SYSTEM/test@ORADB fromuser=WSO2_RSCE touser=jacob IGNORE=Y FILE=D:jacobsample.dmp

Solution 2

If you are unable to restore your oracle dmp file by using above solution then it is recommended that you must use third party Oracle File repair tool. It is designed to repair and recover corrupted oracle database objects that include oracle DMP file as well. The tool comes with easy to use interface and anyone can easily operate it to restore damaged or corrupted oracle data. It can easily restore all the data of Oracle database such as tables, procedures, queries, xml content, etc.

Steps to use Oracle file repair tool to repair and restore Oracle dmp file

Step 1: Search Initial screen of Stellar Phoenix Oracle Recovery with a pop-up window showing options to select or search corrupt Oracle databases in your computer.

Step 2: Click Scan File to initiate the scan process after selecting the oracle database. The recoverable database objects get listed in left-side pane.

Step 3: Click an object to see its preview.

Step 4: : Click Start Repair in the icon bar to start the repair process. A pop-up window is displayed which show the steps needed to perform further. Click next and continue.

Step 5: Give the user name, password and path of the blank database where you want to save the repaired database objects.

Step 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.

1182 Total Views 7 Views Today