Re: Re: Clone Production Server to Stand by Server on 8.1.7 on Win 2k

Yechiel Adar,

		Use standby database, and you won't lost any transaction if your online redo log is there.
		To add a datafile, just add it in the standby database , no need to rebuild the standby database.
		Global name have nothing to do with standby, since you are on different nodes, even no need to use different sid and db_name, after your activate your standby database, just configure the IP that was on the production server to the new server and everything is ok.
		If you want to failover back to your production server after it is ready, you need to rebuild your standby database from the new production.(Though grace failover and failback is supported, it need some strict requirement).
	Good luck
		

Regards
zhu chao
Eachnet DBA
86-21-32174588-667
chao_ping_at_vip.163.com
www.happyit.net

• 2002-11-05 09:03:00 ,you wrote£º=======

>Hello
>
>You did not write if you bring both databases on every night or the backup
>is down until needed.
>If it is down you have no problem.
>If you bring both up you can change the global name :
>Alter database rename global_name to backupdb;
>
>BTW - I am not sure that 8.1.7 need global_name=true.
>We are on 8.1.6 on NT and we do not use global names = true.
>
>Yechiel Adar
>Mehish
>----- Original Message -----
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Sent: Tuesday, November 05, 2002 4:53 PM
>
>
>> 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: Yechiel Adar
> INET: adar76_at_inter.net.il
>
>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: chao_ping
  INET: chao_ping_at_vip.163.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).