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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] 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)" <[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: 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).