0

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

3
  • There's a dba.stackexchange.com sister site that may give you better guidance on Oracle matters.
    – cjc
    Oct 22, 2012 at 18:30
  • thx I submited the question there.
    – Alexk
    Oct 22, 2012 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, 2012 at 19:18

1 Answer 1

0
imp file=blabla.dmp username/password

or

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

9
  • 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, 2012 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, 2012 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, 2012 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, 2012 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, 2012 at 9:39

Not the answer you're looking for? Browse other questions tagged .