| 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: STANDBY DB - 2 questions
This is a multi-part message in MIME format.
------=_NextPart_000_000F_01C06756.500977A0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
Well uptil now we have been working here from 7.3.4.3 to 8.1.7 we = havent faced in probs when we activated the standby without the online = redologfiles
ARUN K C wrote:
Well,=20
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. =
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. :)
Buddy please check it out u do not need the logfiles when the = database is in mount mode and getting recovered once u activate the = database the logfiles will be recreated if the logfiles are not there.=20
Well u will have to experiment a little more on the standby = databases.
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. :)
------=_NextPart_000_000F_01C06756.500977A0 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>One more thing i forgot if i u can =
really can get=20
your online redologs when the database crashed across to the standby =
database=20
then u do not have to activate the standby at all and u can open that =
database=20
without activating it by just creating the controlfile with =
norestogs I=20
hope u knew this</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=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=3Darun_k_c_at_hotmail.com =
href=3D"mailto:arun_k_c_at_hotmail.com">arun</A>=20
</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 5:50=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: STANDBY DB - 2=20
questions</DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Well uptil now we have been working =
here from=20
7.3.4.3 to 8.1.7 we havent faced in probs when we activated the =
standby=20
without the online redologfiles</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
<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> Friday, December 15, =
2000 8:45=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: STANDBY DB - 2=20
questions</DIV>
<DIV><BR></DIV>ARUN K C wrote:<BR>
<BLOCKQUOTE type=3D"cite"=20
cite=3D"mid:F001.00282693.20001215120531_at_fatcity.com">Well, <BR>If =
you have=20
worked on standby database and activated the standby database what = do u=20
think will happen, do u think the logfile are needed. =
</BLOCKQUOTE><BR>If my=20
primary didn't have time to archive the last online redo prior to = crashing,=20
then YES I would need the archive logs.You see I have this silly = habit of=20
trying to recover as much data as possible. :)<BR><BR>
<BLOCKQUOTE type=3D"cite"=20
cite=3D"mid:F001.00282693.20001215120531_at_fatcity.com">Buddy please =
check it=20
out u do not need the logfiles when the database is in mount = mode=20
and getting recovered once u activate the database the = logfiles will=20
be recreated if the logfiles are not there. <BR>Well u will have = to =20
experiment a little more on the standby databases.</BLOCKQUOTE>
<BLOCKQUOTE type=3D"cite"=20
=
cite=3D"mid:F001.00282693.20001215120531_at_fatcity.com"></BLOCKQUOTE>Buddy,=
I=20
can't speak for 8.1.6 or later, but in early 8i releases (8.1.4, = 8.1.5) if=20
you tried to use RESETLOGS during standby activation and there = wasn't SOME=20
type of file representing the online redos in as placeholders, the = database=20
would crash with an ORA-600. Silly me, I guess it just made sense to = copy a=20
few extra MB and play it safe then have to spend time putzing around = while=20
my users were waiting for the database to resurface. But, you're = right, I=20
guess I need to experiment a little more, because clearly I don't = know what=20
I'm talking about. :)<BR><BR><BR><BR>-- Please see the official =
ORACLE-L=20
FAQ: http://www.orafaq.com -- Author: Roby Sherman INET:=20
rxsherm_at_interealm.com Fat City Network Services -- (858) 538-5051 =
FAX: (858)=20
538-5051 San Diego, California -- Public Internet access / Mailing =
Lists=20
 |
 |