| 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
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). Received on Tue Nov 05 2002 - 11:34:08 CST
 |
 |