Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a situation: I have a dmp file and a database with old data server crashed and the latest data we have ar in the dmp file! we managed to pull the server back but it has old data! so we need to restore from the dmp! how to import back the database from dmp file and replace all data and structure (tables schemes)...

I know it's RMAN's job but we do not have it in place, and it's urgent case!

share|improve this question

migrated from serverfault.com Apr 20 '12 at 22:26

This question came from our site for professional system and network administrators.

2  
What sort of dump file do you have? Do you know the command line that was used to generate it? Do you know whether it was generated using the classic export utility or the newer DataPump version? Do you know if it is a schema-level export, a full export, a tablespace-level export, or something else? –  Justin Cave Apr 20 '12 at 22:28

1 Answer 1

up vote 3 down vote accepted

version, OS, tool are helping things to help you solve this.

I guess OS is Windows. version 9i. export full.

If this is the case: connect to the server, set ORACLE_HOME=/where/is/oracle/home/ set PATH=%ORACLE_HOME%/bin;%PATH% set ORACLE_SID=ORCL -> or your ORACLE_SID name

imp file=x.dmp logfile=imp_x.log full=y

imp help=y gives some clues about the commandline options.

study the errors. If there is a complaint about the dmp file, read the first few blocks. From those you can find who exported it, what type export it is and even some version info. It is a bit binary but just readable enough to get this info.

tip:

If your data has a real value for your company, hire a real dba to make a decent setup and have someone as a backup. It is easy to build a system that work happily for years and due to hardware issues suddenly become less happy. It's a pity if that costs your company the head. This is regardless for what brand of database you setup.

share|improve this answer
    
Thanks, well, they will redo the setup and put a good backup plan ;-) –  Data-Base Apr 24 '12 at 9:20
    
well, than something has grown here. If you need help, drop me a line. –  ik_zelf Apr 24 '12 at 19:29
    
I will if there any help needed ;-) thanks :-) –  Data-Base Apr 24 '12 at 19:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.