| 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_0015_01C06724.80ABCC00 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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_0015_01C06724.80ABCC00 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 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 =
without=20
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
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> 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 cite=3D"mid:F001.00282693.20001215120531_at_fatcity.com"=20
type=3D"cite">Well, <BR>If you have worked on standby database and =
activated=20
the standby database what do u think will happen, do u think the = logfile are=20
needed. </BLOCKQUOTE><BR>If my primary didn't have time to archive =
the last=20
online redo prior to crashing, then YES I would need the archive =
logs.You see=20
I have this silly habit of trying to recover as much data as possible. =
:)<BR><BR>
<BLOCKQUOTE cite=3D"mid:F001.00282693.20001215120531_at_fatcity.com"=20
type=3D"cite">Buddy please check it out u do not need the logfiles =
when the=20
database is in mount mode and getting recovered once u = activate the=20
database the logfiles will be recreated if the logfiles are = not there.=20
<BR>Well u will have to experiment a little more on the = standby=20
databases.</BLOCKQUOTE>
<BLOCKQUOTE cite=3D"mid:F001.00282693.20001215120531_at_fatcity.com"=20
type=3D"cite"></BLOCKQUOTE>Buddy, I can't speak for 8.1.6 or later, =
but in early=20
8i releases (8.1.4, 8.1.5) if you tried to use RESETLOGS during =
standby=20
activation and there wasn't SOME type of file representing the online =
redos in=20
as placeholders, the database would crash with an ORA-600. Silly me, I =
guess=20
it just made sense to copy a few extra MB and play it safe then have =
to spend=20
time putzing around while my users were waiting for the database to =
resurface.=20
But, you're right, I guess I need to experiment a little more, because =
clearly=20
I don't know what I'm talking about. :)<BR><BR><BR><BR>-- Please see =
the=20
official ORACLE-L 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
 |
 |