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

From: Szecsy Tamas <tszecsy_at_GEOMETRIA.hu>
Date: Sat, 28 Apr 2001 04:05:17 -0700
Message-ID: <F001.002F4DE1.20010428035020@fatcity.com>

We did not use remote archival in case of a network failaure. (The customer had a pretty overloaded ATM network that crashed two three times a day.
What I ment by dedicated server is that we did not allow any other application of functionallity to be installed on the primary or secondary database host, apart from backup and recovery SW. No file server, only the database and the backup SW. Not even print server ( some years back we had our Windows NT server crash because an errorous Word file got stuck in the spool...).
Failing back to the primary site is not that difficult, since in our case we can offer an off time for the failing back to primary. In this case we make cold backup from the standby, move it to the primary site via LAN ( it's already a 256 Mbit LAN). After backing up the control files from the newly created primary site, life can go on. Failing back can be done when business is low i.e. on a weekend night.

I have got a question about Data Guard: Do you have to have Enterprise Edition for it to work? We did not use Managed Standby Database functionallity, because it needed Enterprise Edition licence - and it meens a huge extra cost.

Regards,

Tamas Szecsy

-----Original Message-----
Sent: 2001.04.27. 6:31 PM
To: Multiple recipients of list ORACLE-L

I have recently implemented it at Cox, San Diego. I faced lot of problems in switching between Read Only and sunstained recovery modes with 8.1.6.
I could not conclude anything about this, may be bug in 8.1.6. I am observing everyone mentioning about scheduling a job to transfer arch files
to secondary.Why not using the feature of remote archival. I have used it and I didn't have any problems. Only script I had to develop was the one to monitor errors on Primary and Standby sites to take care of Archival and recovery breaks.

Suren

-----Original Message-----
Sent: Friday, April 27, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L

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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------