Hi Arif,
Please read the article Note: 76373.1 on Metalink about Standby database.
From: "Arif Khan (GWL)"
Reply-To: ORACLE-L@fatcity.com
To: Multiple recipients of list ORACLE-L
Subject: RE: Clone Production Server to Stand by Server on 8.1.7 on Win 2k
Date: Tue, 05 Nov 2002 12:28:36 -0800
Hello Jared
If I run the database in Standby mode, once my production server fails, can
the standby database be opened for users to make changes (i.e. read an
write) and how do I accomplish that.
Also, once my production server is back on line, how do you suggest I should
synchronize the production server with he standby server database?
Thanks
Arif
-----Original Message-----
Sent: Tuesday, November 05, 2002 12:29 PM
To: ORACLE-L@fatcity.com
Cc: Arif.Khan@Weston.ca
2k
Importance: High
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)"
Sent by: root@fatcity.com
11/05/2002 06:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
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@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@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: Arif Khan (GWL)
INET: Arif.Khan@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@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).
Unlimited Internet access for only $21.95/month. Try MSN!
Click Here
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Quamrul Polash
INET: quapol@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@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 - 15:24:29 CST
