Hi

I am not sure here but can you please try this (i am speculating hmm feels like i am a Investment banker by uttering that word)

RMAN>
run {
set until time "to_date('06-07-2005 16:50:00','dd-mm-yyyy hh24:mi:ss')";
restore controlfile to /tmp/control01.ctl;
restore controlfile from /tmp/control01.ctl ;
alter database mount;
restore database;
recover database;
}

alter database open resetlogs

I need to know the ouput of what happens ?

I am suspecting that the controlfile restored did not have the entry for dropped tablespace.So you need to restore a sufficiently old controlfile.


regards
Hrishy