Tablespace lost

Hello !

I'm currently running through all my emergency procedures. And I discovered that I always rely on having all of my filesystems files ( Unix ) representing tablespaces in oracle on my backup.

What could I do if I lost for instance my rollback tablespace, my index tablespace or my temp tablespace ?

I mean often no data is lost ( or very litle ), and I need to get the rest of the data back online ?

Is there a way, or is all data lost forever ?

Tom Kruhlmann
tok_at_sni.dk Received on Sat Oct 28 1995 - 00:00:00 CET