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

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?

--
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, 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).
---------------------------------
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
--0-846930886-966007532=:7186
Content-Type: text/html; charset=us-ascii
<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 Yahoo! Invites.