Unanswered: Importing Tablespace from One DB to Another DB...
I'm very new in the field of DBA and the scenerio I am facing is as below:
I'd a database in which I added a new tablespace TS with datafile "TS.dbf". Also I added two datafiles to an existing tablespace PO with names "PO01.dbf" and "PO02.dbf".
Then I creaded two databases DB1 and DB2 from this database. All workedfine till Jan12th. But then after, these three files in DB1 are showing RECOVER status, while in DB2 all is working fine.
I have only 5th cold backup of DB1... but I don't want to refresh the database from that backup as a lot of work has been done since then.
So, my questions are:
1. Can we replace these three .dbf from 5th backup.
2. I've export backup of DB2 (database which is working fine)... can I import tablespace TS and PO from this export backup of DB2 into DB1.
TS contains only one object/table...
PO contains 1495 objects.
Please Help me in this... I'll provide further information if needed.