10 Replies Latest reply on Nov 6, 2012 8:18 PM by 896548

    restore database after fresh install system

      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