| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Recovery question
--0-846930886-966007532=:7186
Content-Type: text/plain; charset=us-ascii
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.
-- 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> <B><I>"Thapliyal, Deepak" <DThapliyal_at_ea.com></I></B> wrote: <BR> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">>>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.Received on Fri Aug 11 2000 - 10:25:32 CDT
 |
 |