Message-Id: <10712.124775@fatcity.com> From: "arun" Date: Sat, 16 Dec 2000 05:53:24 -0500 Subject: 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 ----- Original Message -----=20 From: Roby Sherman=20 To: Multiple recipients of list ORACLE-L=20 Sent: Friday, December 15, 2000 8:45 PM Subject: Re: STANDBY DB - 2 questions 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. :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- = Author: Roby Sherman INET: rxsherm@interealm.com Fat City Network = Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- = Public Internet access / Mailing Lists = -------------------------------------------------------------------- To = REMOVE yourself from this mailing list, send an E-Mail message to: = ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the = message BODY, include a line containing: UNSUB ORACLE-L (or the name of = mailing list you want to be removed from). You may also send the HELP = command for other information (like subscribing).=20 ------=_NextPart_000_0015_01C06724.80ABCC00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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
----- Original Message -----
From:=20 Roby=20 Sherman
To: Multiple recipients of list = ORACLE-L=20
Sent: Friday, December 15, 2000 = 8:45=20 PM
Subject: Re: STANDBY DB - 2=20 questions

ARUN K C wrote:
Well,
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.

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. = :)

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
Well u will have to  experiment a little more on the = standby=20 databases.
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. :)



-- Please see = the=20 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roby Sherman = INET:=20 rxsherm@interealm.com Fat City Network Services -- (858) 538-5051 FAX: = (858)=20 538-5051 San Diego, California -- Public Internet access / Mailing = Lists=20 -------------------------------------------------------------------- = To REMOVE=20 yourself from this mailing list, send an E-Mail message to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the = message=20 BODY, include a line containing: UNSUB ORACLE-L (or the name of = mailing list=20 you want to be removed from). You may also send the HELP command for =