It's been a while for this scenerio for me.
Other dba takes a tablespace offline to shuffle files
around. Accidently nukes on of the files clear out of
exsistence. DB is in archivelog mode.
Recovery steps as I recall them.
1) get missing file from last backup
2) Get needed archive log files from backup
3) issue 'alter database recover tablespace blah'
correct?
----
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger.
