RMAN and datafile

We have a somewhat strange situation on a production database. A datafile was added by accident to the INDX-tablespace. It was almost immediatly resized and put offline (another datafile was added to the right tablespace). The database is running fine and rman does an online backup fine (no error/warning). So far so good. Now we got space problems because rman does not consider anything as obsolete anymore because of this accidently added datafile ('report need backup days 7 database' gives back the datafile - we have an redundancy of 1). The datafile can not be put online (Enterprise Manager says it needs recovery) and it cannot be recovered because its not in the backup. The datafile is empty (Enterprise Manager says 0.00% used) und could be deleted, but what i have read about this topic is not promising. So any suggestions on what can/should be done so i have a good backup again?

[Oracle 9.2.0.1.0]

Regards

Volker Received on Tue May 30 2006 - 04:32:19 CDT