RMAN restore, but skip one datafile
I've got an interesting problem here.
I've got a backup of the database (10g SE, windows x32), apart from one file that apparently has not been backed up for a year(!). I am tasked with restoring said database to a specific point in time (begining of march) and extracting data from a specific table (which does NOT reside in the "unbacked up" datafile). How on earth do I go about browbeating the database into letting me do this?
RMAN duplicate from the running database (that someone have deleted data from, hence this mess) works fine until it tries to do recover. At this point it stops and asks for logs that are ancient (and aged out) since there are no newer file backup.
At this point in time I want to "skip" the file and do a recover to march on all the other files. I'm not at all worried about consistency - all I want is the data in the table I'm tasked to retrieve. I've tried to create new controlfiles omitting the offending datafile, but this would force me to reset the logs and thus making further recovery to said point in time impossible.
Anyone have any ideas?