Re: recovery

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

>>> [EMAIL PROTECTED] 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 - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger.

Reply via email to