Home » Server Options » Data Guard » enable configuration in data guard borker (merged)
enable configuration in data guard borker (merged) [message #355554] Sat, 25 October 2008 03:37 Go to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear friends
i configured standby and primary server on oracle 10gR2. it works fine log are applied perfectly even manual switchover is also done perfectly the only issue is with dataguard borker. I have created configuration and add standby databse but as soon as i try to enab le configuration with dgmgrl> enable configuration it hangs no thing happen. please help me out
thank you
rajnish
data guard broker [message #355661 is a reply to message #355554] Sun, 26 October 2008 23:15 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Dear friends

i configured standby and primary server on oracle 10gR2. it works fine log are applied perfectly even manual switchover is also done perfectly the only issue is with dataguard borker. I have created configuration and add standby databse but as soon as i try to enab le configuration with dgmgrl> enable configuration it hangs no thing happen. please help me out

thank you

rajnish



primary side config



db_unique_name=’PRIMARY’

FAL_Client=’to_primary’

FAL_Server=’to_standby’

Log_archive_config=’DG_CONFIG=(primary,standby)’

Log_archive_dest_1=’Location=c:\oracle\backup

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

db_unique_name=primary’

Log_archive_dest_2=’Service=to_standby lgwr async

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

db_unique_name=standby’

Log_archive_dest_state_1=ENABLE

Log_archive_dest_state_2=DEFER

Service_names=’primary’

Standby_File_Management=’AUTO’



standby config



db_unique_name=’STANDBY’

FAL_Client=’to_standby’

FAL_Server=’to_primary’

Log_archive_config=’DG_CONFIG=(primary,standby)’

Log_archive_dest_1=’Location=c:\oracle\backup

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

db_unique_name=standby’

Log_archive_dest_2=’Service=to_primary

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

db_unique_name=primary’

Log_archive_dest_state_1=ENABLE

Log_archive_dest_state_2=ENABLE

Service_names=’STANDBY’

Standby_File_Management=’AUTO’





Data gurad broker config



DGMGRL> connect sys/oracle@to_primary

Connected.



DGMGRL> create configuration ‘broker1’ as

> primary database is ‘primary’

> connect identifier is to_primary;



DGMGRL> Add database ‘standby’ as

> connect identifier is to_standby

> maintained as physical;



DGMGRL> show configuration

Configuration

Name: broker1

Enabled: NO

Protection Mode: MaxPerformance

Fast-Start Failover: DISABLE

Databases:

primary - Physical standby database

standby - Primary database



Current status for "broker1":

DISABLE



DGMGRL> enable configuration; ----- Here it goes hangs kindly help me out
Re: data guard broker [message #355667 is a reply to message #355661] Mon, 27 October 2008 00:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't start a new topic for the same question.
Don't rate your own topic before there is no answer.
You think you will have more or faster answer doing so, you are wrong, you just irritate.

In addition, remove the useless empty lines, they just turn your post harder to read, one more reason to NOT have answers.

Regards
Michel

[Updated on: Mon, 27 October 2008 00:12]

Report message to a moderator

Previous Topic: switchback to primary database
Next Topic: Starting DB with standby controlfile.
Goto Forum:
  


Current Time: Thu Mar 28 19:18:15 CDT 2024