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: arun <arun_k_c_at_hotmail.com>
Date: Sat, 16 Dec 2000 16:55:19 -0500
Message-Id: <10712.124787@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0025_01C06780.F91A0240 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Well thats one thing which I have not tried give me a couple of days i = will let u know I think it might not work but lets see

  arun wrote:

    One more thing i forgot if i u can really can get your online = redologs when the database crashed across to the standby database then u = do not have to activate the standby at all and u can open that database = without activating it by just creating the controlfile with norestogs I = hope u knew this

  To be honest, this is one scenario that I have always wanted to try. = I'm assuming that you mean that you re-create the control file from a = "controlfile to trace" dump, adjusting paths where necessary, and then = starting the standby? If the directory layout structure is exact on both = systems, can you also achieve the same results by copying the primary = control file over? Just curious.

  --Roby

------=_NextPart_000_0025_01C06780.F91A0240 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Well thats one thing which I have not =
tried give me=20
a couple of days i will let u know I think it might not work but lets=20 see</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3Drxsherm_at_interealm.com =
href=3D"mailto:rxsherm_at_interealm.com">Roby=20   Sherman</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Saturday, December 16, = 2000 3:46=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: STANDBY DB - 2=20   questions</DIV>
  <DIV><BR></DIV>arun wrote:<BR>
  <BLOCKQUOTE cite=3D"mid:F001.00282B6A.20001216084522_at_fatcity.com" = type=3D"cite">

    <DIV><FONT face=3DArial size=3D2>One more thing i forgot if i u can = really can=20

    get your online redologs when the database crashed across to the = standby=20

    database then u do not have to activate the standby at all and u can = open=20

    that database without &nbsp;activating it by just creating the = controlfile=20

    with norestogs I hope u knew this</FONT></DIV>     <DIV>&nbsp;</DIV>
    <BLOCKQUOTE dir=3Dltr=20
    style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: = rgb(0,0,0) 2px solid; MARGIN-RIGHT: 0px; Ltrpadding-right: = 0px"></BLOCKQUOTE></BLOCKQUOTE>To=20
  be honest, this is one scenario that I have always wanted to try. I'm = assuming=20
  that you mean that you re-create the control file from a "controlfile = to=20
  trace" dump, adjusting paths where necessary, and then starting the = standby?=20
  If the directory layout structure is exact on both systems, can you = also=20
  achieve the same results by copying the primary control file over? = Just=20
  curious.<BR><BR>--Roby<BR>-- Please see the official ORACLE-L FAQ:=20   http://www.orafaq.com -- Author: Roby Sherman INET: = rxsherm_at_interealm.com Fat=20
  City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, =

  California -- Public Internet access / Mailing Lists=20

Received on Sat Dec 16 2000 - 15:55:19 CST

Original text of this message

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