Hi

I tried the whole exercise again. This time the tablespace was restored at db level only! The only difference from the previous recovery was that I have removed the datafile from OS level this time. I only used the drop tablespace command previously.

When I tried to access the data in the table I got the following error:

ORA-01110: data file 11: '/oracle/app/product/9204/dbs/MISSING00011'

There is a missing datafile from the OS level, it was not restored. How about yours? Did you manage to get all your data and datafiles restored??

Thanks!