Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: STANDBY DB - 2 questions
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> </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 activating it by just creating the = controlfile=20
with norestogs I hope u knew this</FONT></DIV>
<DIV> </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
![]() |
![]() |