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: STANDBY DB - 2 questions

Re: STANDBY DB - 2 questions

From: Roby Sherman <rxsherm_at_interealm.com>
Date: Fri, 15 Dec 2000 18:41:32 -0700
Message-Id: <10711.124764@fatcity.com>


<html><head></head><body>ARUN K C wrote:<br>
<blockquote type="cite" cite="mid:F001.00282693.20001215120531_at_fatcity.com">Well,
<br>

If you have worked on standby database and activated the standby database what do u think will happen, do u think the logfile are needed.
</blockquote>

  <br>
If my primary didn't have time to archive the last online redo prior to crashing, then YES I would need the archive logs.You see I have this silly habit of trying to recover as much data as possible. :)<br>   <br>
  <blockquote type="cite" cite="mid:F001.00282693.20001215120531_at_fatcity.com"> Buddy please check it out u do not need the logfiles when the database is in&nbsp; mount mode and getting recovered once u activate the database the logfiles&nbsp; will be recreated if the logfiles are not there. <br> Well u will have to&nbsp; experiment a little more on the standby databases.</blockquote>

    <blockquote type="cite" cite="mid:F001.00282693.20001215120531_at_fatcity.com"></blockquote> Buddy, I can't speak for 8.1.6 or later, but in early 8i releases (8.1.4, 8.1.5) if you tried to use RESETLOGS during standby activation and there wasn't SOME type of file representing the online redos in as placeholders, the database would crash with an ORA-600. Silly me, I guess it just made sense to copy a few extra MB and play it safe then have to spend time putzing around while my users were waiting for the database to resurface. But, you're right, I guess I need to experiment a little more, because clearly I don't know what I'm talking about. :)<br>

      <br>
      <br>
      <br>
Received on Fri Dec 15 2000 - 19:41:32 CST

Original text of this message

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