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