Message-Id: <10712.124776@fatcity.com> From: "arun" Date: Sat, 16 Dec 2000 11:49:57 -0500 Subject: 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 ----- Original Message -----=20 From: arun=20 To: Multiple recipients of list ORACLE-L=20 Sent: Saturday, December 16, 2000 5:50 AM Subject: Re: STANDBY DB - 2 questions 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_000F_01C06756.500977A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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
 
----- Original Message -----
From:=20 arun=20
To: Multiple recipients of list = ORACLE-L=20
Sent: Saturday, December 16, = 2000 5:50=20 AM
Subject: Re: STANDBY DB - 2=20 questions

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
----- Original Message -----
From:=20 Roby=20 Sherman
Sent: Friday, December 15, = 2000 8:45=20 PM
Subject: Re: STANDBY DB - 2=20 questions

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

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

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



-- Please see the official = ORACLE-L=20 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=20 REMOVE 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 =