| prod_standby [message #455385] |
Tue, 11 May 2010 07:05  |
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 #455481 is a reply to message #455391] |
Tue, 11 May 2010 15:03  |
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 #455563 is a reply to message #455515] |
Wed, 12 May 2010 03:29 |
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 #455637 is a reply to message #455617] |
Wed, 12 May 2010 05:56 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
