Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: recovery

RE: recovery

From: Shreter, Hilary <ShreterH_at_orau.gov>
Date: Wed, 26 Sep 2001 13:28:43 -0700
Message-ID: <F001.00399E14.20010926132657@fatcity.com>

<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.

> -----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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US