AT
From: "Miller, Jay" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: <[EMAIL PROTECTED]>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Miller, Jay" <[EMAIL PROTECTED]>
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/05/2002 06:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mr Tomasino
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
