recovery

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Wed, 26 Sep 2001 12:13:12 -0700
Message-ID: <F001.00399C22.20010926120527@fatcity.com>

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:13:12 CDT