| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k
Right. Stand-by is exactly what you are trying to simulate. The archive logs
will reproduce 99% of what happens in the production environment. In
addition, it will provide for a quicker recovery.
AT
>From: "Miller, Jay" <JayMiller_at_TDWaterhouse.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k
>Date: Thu, 07 Nov 2002 13:23:58 -0800
>MIME-Version: 1.0
>Received: from newsfeed.cts.com ([209.68.248.164]) by
>mc4-f38.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 7 Nov
>2002 13:59:00 -0800
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id NAA59309;Thu, 7 Nov 2002 13:58:01 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004FE57A;
>Thu, 07 Nov 2002 13:23:58 -0800
>Message-ID: <F001.004FE57A.20021107132358_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Miller, Jay" <JayMiller_at_TDWaterhouse.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>Return-Path: root_at_fatcity.cts.com
>X-OriginalArrivalTime: 07 Nov 2002 21:59:00.0266 (UTC)
>FILETIME=[E0B940A0:01C286A8]
>
>You don't need to rebuild when a datafile is added. Once the recovery
>fails
>you just issue the create datafile command on the standby.
>
>Jay Miller
>
>-----Original Message-----
>Sent: Tuesday, November 05, 2002 12:34 PM
>To: Multiple recipients of list ORACLE-L
>2k
>
>
>First off, your process is doing a lot of unnecessary work.
>
>Standby databases are available in 7.3.4. I believe that
>would be somewhat simpler than your current procedure.
>
>I haven't tried it though, so I could be wrong.
>
>Even with your current procedure, you don't need to copy
>all of the files, most of the time anyway.
>
>Build your standby database, put it in recovery mode, and
>just keep applying archive log files to it.
>
>You may need to rebuild when a datafile is added to a
>tablespace, not sure.
>
>In 8i, why not just use standby database?
>
>Jared
>
>
>
>
>
>"Arif Khan (GWL)" <Arif.Khan_at_Weston.ca>
>Sent by: root_at_fatcity.com
> 11/05/2002 06:53 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
> cc:
> Subject: Clone Production Server to Stand by Server on
>8.1.7
>on Win 2k
>
>
>Hello
>
>We currently have two Identical servers (identical in terms of both
>Hardware
>and SW).
>We run Oracle 7.3.4.0 (Workgroup server) on Win NT 4 on both the servers.
>We
>call them as Production Server and Stand by server. The Stand by server is
>passive in nature (i.e. does not do anything). Every night a batch process
>shuts down Oracle instance on both the machines and copies over all the
>files (Data, log, ctl etc) from Production Server to the Stand by server
>(Drive to drive, directory to directory...)
>
>In case the Production Server fails, we simply switch over the users (with
>a
>different alias to the stand by server) and they are back in business.
>
>Now, we are thinking of migrating to 8.1.7, however while trying to
>install
>this version, one needs to specify a Global name which I believe has to be
>unique on the network. So will the same process that I used to run (i.e.
>copy all files over from production to stand by ) work??? I guess both my
>servers will now have to have separate/unique Global Names.
>
>Is there any other approach that any of you can suggest???
>
>TIA
>Arif
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Arif Khan (GWL)
> INET: Arif.Khan_at_Weston.ca
>
>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).
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: Jared.Still_at_radisys.com
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mr Tomasino INET: mr_tomasino_at_hotmail.com 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 07 2002 - 16:03:43 CST
 |
 |