RE: Database Recovery question

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Fri, 11 Aug 2000 17:23:08 -0700
Message-Id: <10586.114444@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C003F3.7DBC69D0
Content-Type: text/plain;

charset="iso-8859-1"

>>If however there was an active transaction that began before the oldest
online log (unlikely but possible), you would need the archived logs too.

note that the abort has already begun .. so how would it ever reach the archives??

thx
deepAk

-----Original Message-----
From: Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com] Sent: Friday, August 11, 2000 9:56 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Database Recovery question

Not completely true. If the database was aborted, you will need to do recovery, but you probably won't need the archived logs - just the online logs. If however there was an active transaction that began before the oldest online log (unlikely but possible), you would need the archived logs too.

"Thapliyal, Deepak" <DThapliyal_at_ea.com> wrote:

>>We shut the database down

normal/abort/immediate -- does not matter hence you do not need any "media" recovery .. hence no need of archives as ur db is uptodate ...in case it it not(abort) .. ur instance recovery will handle the rest for you from ur online logs

hth
deepAk

-----Original Message-----
Sent: Thursday, August 10, 2000 12:44 PM To: Multiple recipients of list ORACLE-L

I have a database that was in archivelog mode. We shut the database down and did a full backup using Veritos. We want to restore the database to a different machine (same SID, file structure, etc). Are any archivelogs going to need to be applied or will we not need them since we are restoring from a cold backup?

This is Oracle 8.0.5/HPUX.

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FRE! ! ! E way to access your mailbox via any web browser, anywhere!

-- 
Author: 
INET: cemail_at_sprintmail.com

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).
-- 
Author: Thapliyal, Deepak
INET: DThapliyal_at_ea.com

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, sen! ! ! d 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).




  _____  

Do You Yahoo!?
Kick off your party with Yahoo! Invites <http://invites.yahoo.com/> .


------_=_NextPart_001_01C003F3.7DBC69D0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 5.00.3105.105" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN 
class=421112700-12082000>&gt;&gt;</SPAN>If however there was an active 
transaction that began before the oldest online log (unlikely but possible), you 
would need the archived logs too. </FONT></FONT></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=421112700-12082000>note 
that the abort has already begun .. so how would it ever reach the 
archives??</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=421112700-12082000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=421112700-12082000>thx</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=421112700-12082000>deepAk</SPAN></FONT></DIV>
<BLOCKQUOTE>
  <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Chuck Hamilton 
  [mailto:chuck_hamilton_at_yahoo.com]<BR><B>Sent:</B> Friday, August 11, 2000 9:56 
  AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: 
  Database Recovery question<BR><BR></DIV></FONT>
  <P>Not completely true. If the database was aborted, you will need to do 
  recovery, but you <EM>probably </EM>won't need the archived logs - just the 
  online logs. If however there was an active transaction that began before the 
  oldest online log (unlikely but possible), you would need the archived logs 
  too. 
  <P>&nbsp; <B><I>"Thapliyal, Deepak" &lt;DThapliyal_at_ea.com&gt;</I></B> wrote: 
  <BR>
  <BLOCKQUOTE 
  style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">&gt;&gt;We 
    shut the database down <BR><BR>normal/abort/immediate -- does not matter 
    <BR>hence you do not need any "media" recovery .. hence no need of archives 
    as<BR>ur db is uptodate ...in case it it not(abort) .. ur instance recovery 
    will<BR>handle the rest for you from ur online 
    logs<BR><BR>hth<BR>deepAk<BR><BR><BR><BR>-----Original Message-----<BR>Sent: 
    Thursday, August 10, 2000 12:44 PM<BR>To: Multiple recipients of list 
    ORACLE-L<BR><BR><BR><BR>I have a database that was in archivelog mode. We 
    shut the database<BR>down and did a full backup using Veritos. We want to 
    restore<BR>the database to a different machine (same SID, file 
    structure,<BR>etc). Are any archivelogs going to need to be applied or 
    will<BR>we not need them since we are restoring from a cold 
    backup?<BR><BR>This is Oracle 8.0.5/HPUX.<BR><BR>-----<BR>Sent using 
    MailStart.com ( http://MailStart.Com/welcome.html )<BR>The FRE! ! ! E way to 
    access your mailbox via any web browser, anywhere!<BR><BR>-- <BR>Author: 
    <BR>INET: cemail_at_sprintmail.com<BR><BR>Fat City Network Services -- (858) 
    538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet 
    access / Mailing 
    Lists<BR>--------------------------------------------------------------------<BR>To 
    REMOVE yourself from this mailing list, send an E-Mail message<BR>to: 
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the 
    message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of 
    mailing list you want to be removed from). You may<BR>also send the HELP 
    command for other information (like subscribing).<BR>-- <BR>Author: 
    Thapliyal, Deepak<BR>INET: DThapliyal_at_ea.com<BR><BR>Fat City Network 
    Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- 
    Public Internet access / Mailing 
    Lists<BR>--------------------------------------------------------------------<BR>To 
    REMOVE yourself from this mailing list, sen! ! ! d an E-Mail message<BR>to: 
    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the 
    message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of 
    mailing list you want to be removed from). You may<BR>also send the HELP 
    command for other information (like subscribing).</BLOCKQUOTE>
  <P><BR>
  <HR SIZE=1>
  <B>Do You Yahoo!?</B><BR>Kick off your party with <A

Received on Fri Aug 11 2000 - 19:23:08 CDT