Home » Server Options » Data Guard » one primary and 2 physical standby databases (solaris 10 sparc)
one primary and 2 physical standby databases [message #477156] Wed, 29 September 2010 02:00 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

I have one primary database and one physical standby database on my data guard environment.

Now i want one more physical standby database in my data guard environment, meaning i wnat 2 physical standby. since this is a production environment, i need to take great care. However, downtime will be mandatory.

Please help how to proceed?

[u]init.ora for production:[/u]


pup2.__db_cache_size=6241124352
pup2.__java_pool_size=33554432
pup2.__large_pool_size=134217728
pup2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
pup2.__pga_aggregate_target=5771362304
pup2.__sga_target=7985954816
pup2.__shared_io_pool_size=0
pup2.__shared_pool_size=1476395008
pup2.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest='/oracle/app/oracle/admin/pup2/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data/pup2/control01.ctl','/oracle/pup2/control02.ctl','/orabku
p/pup2/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='pup2'
*.db_unique_name='pup2'
*.dg_broker_config_file1='/oracle/dgbroker1/dr1pup2.dat'
*.dg_broker_config_file2='/oracle/dgbroker2/dr2pup2.dat'
*.dg_broker_start=TRUE
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=pup2XDB)'
*.fal_client='pup2'
*.fal_server='pup2stdby'
*.job_queue_processes=1000
*.local_listener='LISTENER_PUP2'
*.log_archive_config='dg_config=(pup2,pup2stdby)'
*.log_archive_dest_1='LOCATION=/archivelog valid_for=(all_logfiles,all_roles) db
_unique_name=pup2'
*.log_archive_dest_2='service="pup2stdby"','LGWR ASYNC NOAFFIRM delay=0 optional
compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="
pup2stdby" net_timeout=30','valid_for=(all_logfiles,primary_role)'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
pup2.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=30
*.log_archive_min_succeed_dest=1
pup2.log_archive_trace=0
*.memory_target=13743685632
*.open_cursors=300
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=500
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'

-----------------

init.ora for my first primary standby


pup2.__db_cache_size=6509559808
pup2.__java_pool_size=33554432
pup2.__large_pool_size=67108864
pup2.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
pup2.__pga_aggregate_target=5502926848
pup2.__sga_target=8254390272
pup2.__shared_io_pool_size=0
pup2.__shared_pool_size=1543503872
pup2.__streams_pool_size=0
*.archive_lag_target=0
*.audit_file_dest='/oracle/app/oracle/admin/pup2/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data/pup2/control01.ctl','/oracle/pup2/control02.ctl','/orabku
p/pup2/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='pup2'
*.db_unique_name='pup2stdby'
*.dg_broker_config_file1='/oracle/dgbroker1/dr1pup2stdby.dat'
*.dg_broker_config_file2='/oracle/dgbroker2/dr2pup2stdby.dat'
*.dg_broker_start=TRUE
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=pup2XDB)'
*.fal_client='pup2stdby'
*.fal_server='pup2'
*.job_queue_processes=1000
*.local_listener='LISTENER_PUP2'
*.log_archive_config='dg_config=(pup2,pup2stdby)'
*.log_archive_dest_1='LOCATION=/archivelog valid_for=(all_logfiles,all_roles) db
_unique_name=pup2stdby'
*.log_archive_dest_2=''
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.dbf'
pup2.log_archive_format='%t_%s_%r.dbf'
*.log_archive_max_processes=30
*.log_archive_min_succeed_dest=1
pup2.log_archive_trace=0
*.memory_target=13743685632
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=300
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'




Thanks,


sailesh
Re: one primary and 2 physical standby databases [message #477158 is a reply to message #477156] Wed, 29 September 2010 02:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You do not need any downtime to add another standby database to the environment. All the steps are in the Data Guard Concepts and Admin guide, the easiest technique is to use RMAN.

[Updated on: Wed, 29 September 2010 02:33]

Report message to a moderator

Re: one primary and 2 physical standby databases [message #477187 is a reply to message #477158] Wed, 29 September 2010 04:34 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi John,

I have already one production and one physical standby in one building. Now my concern is that i have another server with oracle installed at DR site which is situated in another building 30 km apart.

i am currently using RMAN to back n restore my database. But according to my understanding, i have to put entry in my spfile. i will go to my DR site to restore the backup. In the admin guide, it is mentioned for one primary n one physical standby not 2 physical standby.

Please i have to take great care. I have 2000 users connected live on this db.

Sailesh
Re: one primary and 2 physical standby databases [message #477191 is a reply to message #477187] Wed, 29 September 2010 04:43 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What's the problem?
Re: one primary and 2 physical standby databases [message #477192 is a reply to message #477191] Wed, 29 September 2010 04:59 Go to previous messageGo to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

My problem is

1.what additional configurations i have to perform on my production server.

2.Both physical standby config should be identical with only the db_unique name different.

3.log_archive_config='dg_config=(pup2,pup2stdby)'
on this line i have to put entry for second standby

*.log_archive_dest_2='service="pup2stdby"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="pup2stdby" net_timeout=30','valid_for=(all_logfiles,primary_role)'

HERE I HAVE TO PUT LOG_ARCHIVE_DEST_3

*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='ENABLE'

4. what about FAL SERVER n FAL CLIENT

Thanks,

sailesh
Re: one primary and 2 physical standby databases [message #477193 is a reply to message #477192] Wed, 29 September 2010 05:03 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So what's the problem?
Previous Topic: prod_standby
Next Topic: Problem in Switch over
Goto Forum:
  


Current Time: Fri Mar 29 08:14:08 CDT 2024