RE: Real-life Stand-by DB implementation stories?

That auto fail over feature is called Data Guard, and its out now (at least the docs are). It will work with 8.1.5 or higher on UNIX OS in a non parallel server environment. Basically as far as I can tell, it runs agents on both primary and standby servers, and will auto fail over to the standby if needed. Another cool function is that it will "switch" your primary and standby database if you want, then switch them back. Server maintenance options arise with switching feature. I hope to test this during the coming months, so I may have some real insight later.

Anyone use this yet?

Mike   

> -----Original Message-----
> From: Szecsy Tamas [SMTP:tszecsy_at_GEOMETRIA.hu]
> Sent: Friday, April 27, 2001 9:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Real-life Stand-by DB implementation stories?
>
> Yes we did.
>
> It's on windows NT. We have implemented manually managed standby database,
> with a db job on the primary database archiving online redo log files
> every
> five minutes to minimize data loss in case of a crash of the primary
> database. The standby database server ftps *iwth a windows nt scheduled
> job,
> running every 15 minutes) new archive log files to it's local drive and
> applies them to the standby database if it's not in read-only mode for
> reporting.
>
> It's working since a more than a year, never had any problems with it. If
> Windows NT server is kept away from frequent install/deinstall of various
> applications then within my experience it is a stable solution. By the
> way,
> if Oracle Technet can be believed, Oracle 9i will have an automatic fail
> over feature for the standby database.
>
> My view is that you should use Oracle 8.1.7. Oracle 8.1.6 has some
> problems
> with read-only mode combined with managed standby database - or so I
> heard.
>
> Regards,
>
> Tamas Szecsy
>
> ===========================================
>
>
> Anyone implemented SBDBs recenetly? A client is comparing them to a
> cluster
> solution involving Fail-Safe. We are recommending SBDB and trying to go to
> 817 also (on 80521 now).
>
> Also this is NT if that makes a difference.
>
> Thanks,
>
>
> Earl
>
>
> Get 250 color business cards for FREE!
> http://businesscards.lycos.com/vp/fastpath/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: The Oracle DBA
> INET: theoracledba_at_lycos.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Martin Kendall
> INET: Martin.Kendall_at_Rubus.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Szecsy Tamas
> INET: tszecsy_at_GEOMETRIA.hu
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lanteigne, Mike
  INET: MLanteigne_at_edc-see.ca

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