Oracle-L: RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Thu, 07 Nov 2002 13:23:58 -0800
Message-ID: <F001.004FE577.20021107132358@fatcity.com>

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

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