Oracle-L: Re: Safe Database Environment

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Thu, 21 Nov 2002 01:03:48 -0800
Message-ID: <F001.00508A30.20021121010348@fatcity.com>

Safe Database EnvironmentHello Hussain

We are working with oracle 8.1.6 on wintel machines.

We had the same problem and we solved it using advance replication - synchronous. We have scripts ready that drop the replication on each computer if one become unavailable. The databases have the same sid.

So if one computer goes down we do the following:

Drop replication on the remaining server.
If main server is down: remove the backup server from the domain rename the backup server name and tcp/ip address to the main server name and tcp/ip address. start up the backup server as main server. IMPORTANT - run a script that update the values of sequences, since they are not replicated.
Start the application again.

Elapsed time about 5-10 minutes and ALL the data is in.

Yechiel Adar
Mehish

Original Message ----- From: Hussain Ahmed Qadri To: Multiple recipients of list ORACLE-L Sent: Thursday, November 21, 2002 10:13 AM Subject: Safe Database Environment

Hi all,

Can any of you suggest the configuration for a safe, fault proof, and minimum downtime Database environment? (In terms of how many servers, RAID or disk ARRAY or any combination. A minimum configuration is what I am looking for).

Right now we have one main server (Compaq proliant) and one standby database. But since the log switch takes place after about 10-15 minutes in the peak time and 30-40 minutes in not so peak time, plus our environment is 24x7, so if anything goes wrong with the production DB, it will take sometime to get back live and then some further time to catch up or redoing those entries which were lost because of no log witch. Hence even a downtime of few minutes brings the work to a halt plus any loss of data in between the archiving time is costly too.

So I want to suggest to our management a solution, which is as close to being fool-proof, if one server is down the other system can take its place in matters of minutes or seconds, and better if it is transparent to the user, or close.

Thanks & regards,
Hussain

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yechiel Adar
INET: adar76_at_inter.net.il

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Thu Nov 21 2002 - 03:03:48 CST