| one primary and 2 physical standby databases [message #477156] |
Wed, 29 September 2010 02:00  |
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 #477187 is a reply to message #477158] |
Wed, 29 September 2010 04:34  |
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 #477192 is a reply to message #477191] |
Wed, 29 September 2010 04:59 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
