Message-Id: <10586.114444@fatcity.com> From: "Thapliyal, Deepak" Date: Fri, 11 Aug 2000 17:23:08 -0700 Subject: RE: Database Recovery question 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@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" 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@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@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@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@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 . ------_=_NextPart_001_01C003F3.7DBC69D0 Content-Type: text/html; 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@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@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@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@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@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@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