After system failure I have bought a new server and now Im trying to recreate the oracle database I had. I have a dump file which was made with the command exp and full=y. So can I restore the full database from this dump? If yes how?

Oracle 11g Windows server 2003

  • There's a dba.stackexchange.com sister site that may give you better guidance on Oracle matters. – cjc Oct 22 '12 at 18:30
  • thx I submited the question there. – Alexk Oct 22 '12 at 18:33
  • @Alexk Do not cross-post; if you want a Q moved to another site, Flag it and we'll move it. – Chris S Oct 22 '12 at 19:18
imp file=blabla.dmp username/password


imp file=impfile.dmp fromuser=xy touser=xy 

if you are sysdba

But!!!: you have to have the same(!) version (major + cpu) And you have to have created the users and tablespaces before

| improve this answer | |
  • I want to add that if you have everything in place... installed correct oracle version and your instance is working the import is going to be easy. So dont worry... – cljk Oct 22 '12 at 18:48
  • The versions are the same and i am dba. Shouldnt I use the full=y command in imp? In what state should the DB in for the imp? – Alexk Oct 22 '12 at 18:49
  • The DB should be in normal state (mounted, connected and open). Currently I dont have an oracle box at hands but I dont remember a full parameter on imp. If there is any just have a look in the doc. I think i never needed it for restoring. I used exp/imp quite a lot for creating duplicate databases a long time ago and dump files are our basis for backup too. – cljk Oct 22 '12 at 18:54
  • ok, had a short look at the doc. seems that full=y on imp tells the process to recreate the tablespaces and discard present data. So give it a try... – cljk Oct 22 '12 at 18:58
  • Users and tablespaces created ok but I got tons of specific errors, 2 to be exact ORA-00001 and ORA-02195. – Alexk Oct 25 '12 at 9:39

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