Message-Id: <10487.104959@fatcity.com> From: Brian MacLean Date: Thu, 4 May 2000 11:31:15 -0700 Subject: RE: Automated standby database This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB5F6.EE641282 Content-Type: text/plain; charset="windows-1252" Different SID: I haven't tried it but I would say no because the standby control file (contains the SID) is generated on the primary DB. Current Redo Log: This is a SOL scenario. The current redo log is lost for all time if you activate the standby. I researched into this question several months ago to include all Oracle documentation and by finally calling Oracle support. This is why a standby is only meant for catastrophic fail over and hot high availability. See http://sitelicense.arizona.edu/~oradoc/DOC/server.815/a67773/standby.htm#168 30 for the following references that support my answers above: If you place your production and standby databases on the same host, some operating systems will not allow you to mount two instances with the same database name on the same machine simultaneously. The redo logs that you apply to the standby database must be either archived or non-current redo logs. PS: We run a standby v8.1.5 at our company. Brian P. Mac Lean Senior Oracle Database Administrator OCPv8/Oracle Master HomeBid.Com 8700 N. Gainey Center Drive Scottsdale, AZ 85258 Tel:480.609.4624 Cel:602.617.6075 Fax:480.609.4646 Net:brian.maclean@homebid.com -----Original Message----- From: CHUCK_HAMILTON@qvc.com [mailto:CHUCK_HAMILTON@qvc.com] Sent: Thursday, May 04, 2000 10:57 AM To: Multiple recipients of list ORACLE-L Subject: Automated standby database Can an ASD have a different SID name than the primary database? Also, when the ASB is activated, how is the current online log from the primary database applied? -- Chuck Hamilton QVC Inc. Enterprise Technical Services Oracle DBA -- Author: INET: CHUCK_HAMILTON@qvc.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). ------_=_NextPart_001_01BFB5F6.EE641282 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable RE: Automated standby database

Different SID:     = I haven't tried it but I would say no because the standby control file = (contains the SID) is generated on the primary DB.

Current Redo = Log:      This is a SOL scenario.  The = current redo log is lost for all time if you activate the = standby.  I researched into this question several months ago to = include all Oracle documentation and by finally calling Oracle = support.  This is why a standby is only meant for catastrophic = fail over and hot high availability.



See http://sitelicense.arizona.edu/~oradoc/DOC/server.815/= a67773/standby.htm#16830 for the following references that support = my answers above:

If you place your production and = standby databases on the same host, some operating systems will not = allow you to mount two instances with the same database name on the = same machine simultaneously.

The redo logs that you apply to the = standby database must be either archived or non-current redo = logs.



PS: We run a standby v8.1.5 at our = company.

Brian P. Mac = Lean
Senior = Oracle Database Administrator
OCPv8/Oracle Master
HomeBid.Com
8700 N. = Gainey Center Drive
Scottsdale, = AZ  85258
Tel:480.609.4624
Cel:602.617.6075
Fax:480.609.4646
Net:brian.maclean@homebid.com


-----Original Message-----
From: CHUCK_HAMILTON@qvc.com [mailto:CHUCK_HAMILTON@qvc.com= ]
Sent: Thursday, May 04, 2000 10:57 = AM
To: Multiple recipients of list = ORACLE-L
Subject: Automated standby = database


Can an ASD have a different SID name = than the primary database? Also, when
the ASB is activated, how is the = current online log from the primary
database applied?
--
Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

--
Author:
  INET: = CHUCK_HAMILTON@qvc.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