RE: Automated standby database

different SID: I don't think so. maybe you could change it after you have opened the database

current redo log: not if you have failed over because of problems. BUT.... check Metalink for "Graceful Switchover" by Lawrence To... he talks about getting the last log over

(you archive it, send it over, and then apply it before opening)

>From: Brian MacLean <bmaclean_at_homebid.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Automated standby database
>Date: Thu, 04 May 2000 11:35:18 -0800
>
>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_at_homebid.com
>
>
>-----Original Message-----
>Sent: Thursday, May 04, 2000 10:57 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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_at_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_at_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).