ur right on.
the ts is offline, restore the file, do the alter database recovery
tablespace command, alter tablespace online.
tested on 9i on linux, with a rm -f of the datafile after the ts was taken
offline.
joe
>>> MATT.ADAMS_at_APPL.GE.COM 09/26/01 04:05PM
>>>
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 -
matt.adams_at_appl.ge.com Meddle not in the affairs of
troff, for it is subtle and quick to anger.
Received on Wed Sep 26 2001 - 14:53:45 CDT
