<FONT face=Arial color=#0000ff
size=2>Perhaps preserve the CURRENT redo logs so that after the archived ones
bring you up to their last time, you can use the currents to come up to the
last moments?
<FONT face=Arial color=#0000ff
size=2>
(I've
not tried this exact scenario though)
<FONT face=Tahoma
size=2>-----Original Message-----From: Adams, Matthew (GEA, 088130)
[mailto:MATT.ADAMS_at_APPL.GE.COM]Sent: Wednesday, September 26, 2001
4:40 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: recovery
The control files are all intact and the database is
open. Only one datafile (for an offline tablespace) is
missing.
- 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.
> -----Original Message----- >
From: Gogala, Mladen [<A
href="mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com] <FONT
size=2>> Sent: Wednesday, September 26, 2001 4:27 PM <FONT
size=2>> To: Multiple recipients of list ORACLE-L <FONT
size=2>> Subject: RE: recovery >
> > It is correct if the
files weren't renamed or physically > removed.
In that > case, you have <FONT
size=2>> to re-create the controlfile and do recovery using backup
> controlfile (which >
means that it > doesn't have the target
SCN). > > -----Original
Message----- > Sent: Wednesday, September 26, 2001
4:05 PM > To: Multiple recipients of list
ORACLE-L > >
> > It's been a while
for this scenerio for me. > <FONT
size=2>> 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. > <FONT
size=2>> 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.
> > -- <FONT
size=2>> Please see the official ORACLE-L FAQ: <A target=_blank
href="http://www.orafaq.com">http://www.orafaq.com <FONT
size=2>> -- > Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com <FONT
size=2>> > Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego,
California -- Public Internet access
/ Mailing Lists >
> To REMOVE yourself from this mailing list, send an
E-Mail message > to: ListGuru_at_fatcity.com (note
EXACT spelling of 'ListGuru') and in > the message
BODY, include a line containing: UNSUB ORACLE-L >
(or the name of mailing list you want to be removed from). You
may > also send the HELP command for other
information (like subscribing). >
Received on Wed Sep 26 2001 - 15:28:43 CDT