This discussion is archived
10 Replies Latest reply: Nov 6, 2012 12:18 PM by 896548 RSS

restore database after fresh install system

896548 Newbie
Currently Being Moderated
Hi
please let me know where I can find good solution for restore and recover database in situation when I have reinstalled all system with database.
From "old" database I have datafiles(tablespace), backup files, backup controlfile, etc. In "new" database I create new tablespace, the name of "new" database is the same as "old"

yesterday I tried
alter tablespace +name+ add datafile '+/path to old tablespase+'
nothing, I didn't get any table, view, etc.
restore controlfile from '+path to backup controlfile+'
I got error message about wrong database id and can't open database.

Thank you in advance

Regards Krzysztof

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points