Home » Server Options » Data Guard » Physical standby failover
Physical standby failover [message #210449] Wed, 20 December 2006 19:45 Go to next message
vipin_doshi
Messages: 7
Registered: November 2006
Location: Australia
Junior Member

Hi guys,

I have 2 database configured as primary and physical standby.
Both are configured using dataguard broker.In this configuration switchover works fine.

If i pull out network cable from primary.After that if i issue any command on DGMGRL prompt on standby it hangs for ever.
The commands I issue as 'show configuration verbose'.It hangs forever. and 'show site 'standby_site_name' status also hangs.
It does not comeup with success message.

is anybody have any idea whay is like that?



Regards,
Vipin Doshi
Re: Physical standby failover [message #210605 is a reply to message #210449] Thu, 21 December 2006 08:51 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
make sure your dr*.dat files in O_H/dbs directory on standby are intact and are in sync with primary with similar or later timestamp than primary

Sandeep
Re: Physical standby failover [message #210711 is a reply to message #210449] Thu, 21 December 2006 23:00 Go to previous message
vipin_doshi
Messages: 7
Registered: November 2006
Location: Australia
Junior Member

Hi all,
Thanks sandeep.
I am using these parameters for physical standby configuraiton on both servers.

*.archive_lag_target=0
*.background_dump_dest='/u01/app/oracle/products/9.2.0/admin/test/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/app/oracle/products/9.2.0/oradata/test/standby.ctl'
*.core_dump_dest='/u01/app/oracle/products/9.2.0/admin/test/cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert=' ',' '
*.db_name='test'
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.fal_client='test_192.168.1.4'
*.fal_server='test_192.168.1.1
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='test'
*.java_pool_size=33554432
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=/u01/app/oracle/products/9.2.0/oradata/test/archive MANDATORY'
*.log_archive_dest_2='service="test_192.168.1.1','ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0 reopen=300 register'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%d_%t_%s.arc'
*.log_archive_max_processes=10
*.log_archive_min_succeed_dest=1
*.log_archive_start=true
*.log_archive_trace=0
*.log_file_name_convert=' ',' '
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_archive_enable='true'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.standby_archive_dest='/u01/app/oracle/products/9.2.0/oradata/test/standbyarchive'
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/products/9.2.0/admin/test/udump'

I am running in max-performace mode.can any body tell me whats the problem in failover from these pararameters.I can switchover without any problems.

Thanks,
Vipin Doshi
Previous Topic: If production server goes down?
Next Topic: How to clear this Data Guard alert message in EM?
Goto Forum:
  


Current Time: Thu Mar 28 06:45:45 CDT 2024