Recover with missing file in ts

Hi,

The problem is that we have an Oracle backup of all files except for one datafile in the table (NOT INDEX) TABLESPACE. ie. an alter tablespace add datafile4 was done and subsequent updates followed.

We have had to restore from the backup, which excluded datafile4.

We managed to have Oracle recognise this new datafile by recreating the control file.

However, how can we bring the database in sync/recover from this situation?

Thanx in advance for any suggestions!
mayet_at_cc.und.ac.za Received on Wed Dec 01 1993 - 15:57:47 CET