I am recovering a database that lost all its control files and data files. A tablespace that was just created 8:30 am this morning was also lost. The last good backup was taken at 2:00am this morning. That backup doesn't have that tablespace (prodx) that was created after the backup.

Now, What I did is restore the good backup and re-build the controlfile from the trace file. Now, I started the recovery process. Accroding to the docs, I also create the new datafiles for the tablespace that was created after the 2:00 am backup. Everything went pretty well.

The only problem is that the recovery process keep asking new archived logs even after all archived logs have been applied. I tried to cancel the recovery and tried open the database resetlogs. It failed. Now, I am going nowhere.

What could be wrong?