ORA-01159: file is not from same database as previous files - wrong databas
jjkMay 1 2011 — edited May 1 2011Hello everyone,
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
We are trying to restore few tablespaces of our database, which were backed up using OS utilities during offline backup.
There are tablespaces, say tbs1 to tbs31 and system/sysaux/undo/user ts.
tbs1 - tbs31 are all read only, except tbs29 &tbs30.
On target database, while recreating control file, I get subjected error.
I've taken the traced control file backup from source, edited it to contain the datafiles from all the "read only" tablespaces also in "datafile" clause of control file.
I want to know if that's allowed. Also, currently we are using "REUSE". Will using "SET" resolve the problem as I guess, it will create a new DBID.
thanks