Home » Server Options » Data Guard » prod_standby (oracle 10.2.0.1.0,Redhat Linux 4)
prod_standby [message #455385] Tue, 11 May 2010 07:05 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Hi All

i m going to have Production, Standby in seperate server
Sid,instance_name,db_name,directory,files_location all are same
but IP only different

give me advantage,disadvantage
thanks
Re: prod_standby [message #455391 is a reply to message #455385] Tue, 11 May 2010 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still unable to read the documentation?

By the way, advantages and disadvantages of what? compare to what?

Regards
Michel

[Updated on: Tue, 11 May 2010 07:21]

Report message to a moderator

Re: prod_standby [message #455481 is a reply to message #455391] Tue, 11 May 2010 15:03 Go to previous messageGo to next message
Sahba1969
Messages: 14
Registered: March 2009
Location: Austria
Junior Member
Hello,
the main principle of Data Guard Configuration is to set it up using separate Servers for Primary DB and Standby DB site.
DB_name ist same on both db servers
DB_unique_name is different on primary than on standby
Data and log Directories can be configured to be the same,in this case, you would save yourself some Admin work, and avoid using db_file_name_convert and log_file_name_convert. Be sure, you configure your disks with the same name on both servers. This is also true for log_archive_dest
the IP address must be different, since you have two different server on the network. The two servers should be able to communicate with each other
You need to configure the tnsnames.ora on each server. The connect string is used to transfer the archived redolog files from primary server to standby server.
EG. on Primary server:
ARC_TRANSFER=........ (HOST=standby server)(port=port number of listening process)..

on Standby Server:
ARC_TRANSFER=........ (HOST=primary server)(port=port number of listening process)..

Please consider going through the steps to setup dataguard (e.g. physical standby) from Oracle 10g/11g documentation.
all the steps you need to setup primary and standby are documented.

good luck
regards
sahba
Re: prod_standby [message #455515 is a reply to message #455481] Wed, 12 May 2010 00:20 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thanks Shaba

so, please clarify

db_unique_name=instance_name=sid ????

Regards.
Re: prod_standby [message #455563 is a reply to message #455515] Wed, 12 May 2010 03:29 Go to previous messageGo to next message
Sahba1969
Messages: 14
Registered: March 2009
Location: Austria
Junior Member
hi,
yes, different on primary than on standby:
primary:
db_name=prod
db_unique_name=prod
instance_name=prod
ORACLE_SID=prod

standby:
db_name=prod
db_unique_name=stb
instance_name=stb
ORACLE_SID=stb

regards
sahba
Re: prod_standby [message #455609 is a reply to message #455563] Wed, 12 May 2010 04:43 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Thanks Mr.sahba
Re: prod_standby [message #455617 is a reply to message #455609] Wed, 12 May 2010 05:06 Go to previous messageGo to next message
Sahba1969
Messages: 14
Registered: March 2009
Location: Austria
Junior Member

I'm a Woman.
Sahba is not my sure name.
you're welcome.
Re: prod_standby [message #455637 is a reply to message #455617] Wed, 12 May 2010 05:56 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Sorry

Anyway a woman being a DBA is exellent, i mean DBA is 24/7 so it little unfair for a woman.

this is my openion, but lady DBA's are there in the world.

Regards
Re: prod_standby [message #476216 is a reply to message #455385] Wed, 22 September 2010 02:33 Go to previous message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Hi,
Can you share steps of configuring with same sid?
I have configured using different SID.

Thanks in advance.

Bye
Previous Topic: FAL[client]: Error fetching gap sequence, no FAL server specified
Next Topic: one primary and 2 physical standby databases
Goto Forum:
  


Current Time: Fri Mar 29 08:48:31 CDT 2024