Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

share|improve this question

closed as off topic by EEAA, cjc, Chris S Oct 22 '12 at 19:17

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

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

1 Answer 1

up vote 0 down vote accepted
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

share|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.