Hi
I have finally recovered the dropped tablespaceI am posting the full solution here and hope that someone will find it useful
1. Drop tablespace test including contents;
2. Shutdown and startup mount
3. Restore controlfile
run {
set until time "to_date('25-07-2005 17:22:00','dd-mm-yyyy hh24:mi:ss')";
restore controlfile to '/tmp/control01.ctl' ; }
4. Shutdown and copy all backup control file to actual location
5. startup mount and starts recovery
run {
set until time "to_date('25-07-2005 17:22:00','dd-mm-yyyy hh24:mi:ss')";
restore database;
recover database;
sql "ALTER DATABASE OPEN RESETLOGS"; }
You have successfully recovered from your dropped tablespace! Case closed![]()
Thanks hrishy for all your contributions!I will get back to the metalink guy with the solution!
![]()




I am posting the full solution here and hope that someone will find it useful 
Reply With Quote