Re: Database Fails to Open after Recover TableSpace - No Backups!

Habib, I think in the future you need to read the error message and figure our what it means. If the database cannot read a file you need to find out why and try to make the file accessible again. The problem could have been as simple as a file system not being mounted.

What happens if you issue "select * from v$recover_file;" ?

Every version of Oracle includes one or more manuals on the topic of backup and recovery. I think you need to read yours.

I suggest you scan the rdbms dictionary views and compile a list of all objects allocated to the tablespace that the dropped file belonged to.

Do you have any recent database export files? Can the objects allocated to the dropped file be found in the export.

I imagine that you have damaged your Siebel system. The question is does your installation use the objects that were allocated to the dropped file. If not an export may be enough to salvage the system. But if some of the data was important then someone is probably going to be unhappy if this was a production system. If it is test then you might be able to reconstruct the lost objects from production.

• Mark D Powell --