OraFAQ Forum: Data Guard » enable configuration in data guard borker (merged)

Home » Server Options » Data Guard » enable configuration in data guard borker (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

enable configuration in data guard borker (merged) [message #355554]

Sat, 25 October 2008 03:37

kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida

Member

Report message to a moderator

data guard broker [message #355661 is a reply to message #355554]

Sun, 26 October 2008 23:15

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

Report message to a moderator

Re: data guard broker [message #355667 is a reply to message #355661]

Mon, 27 October 2008 00:11

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:09:24 CDT 2025