Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Physical standby databases gets disabled in dgbroker configuration when shuting down one physical da

BQ-OCMar 14 2014 — edited Mar 20 2014

Hi!

I have 8 physical standby and when i shutdown one the rest gets disabled in configuration.

DGMGRL> show configuration

Configuration - GESS1_BROKER

Protection Mode: MaxPerformance
Databases:

    GESS1 - Primary database
    GCOD1A - Physical standby database
    GCOD1B - Physical standby database
    GCOD2B - Physical standby database
    GCOD3A - Physical standby database
    GCOD3B - Physical standby database
    GCOD4A - Physical standby database
    GCOD4B - Physical standby database
    GCOD2A - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

then when i shutdown GCOD4A the other physical standby databases gets disabled one by one as you see below

Databases:
GESS1 - Primary database
Error: ORA-16778: redo transport error for one or more databases

    GCOD1A - Physical standby database (disabled)
    GCOD1B - Physical standby database
    GCOD2B - Physical standby database
    GCOD3A - Physical standby database
    GCOD3B - Physical standby database
    GCOD4A - Physical standby database
      Error: ORA-01034: ORACLE not available

GCOD4B - Physical standby database
GCOD2A - Physical standby database

GESS1 - Primary database
Error: ORA-16778: redo transport error for one or more databases

    GCOD1A - Physical standby database (disabled)
    GCOD1B - Physical standby database (disabled)
    GCOD2B - Physical standby database
    GCOD3A - Physical standby database
    GCOD3B - Physical standby database
    GCOD4A - Physical standby database
      Error: ORA-01034: ORACLE not available

GCOD4B - Physical standby database
GCOD2A - Physical standby database (disabled)

GESS1 - Primary database
Error: ORA-16778: redo transport error for one or more databases

    GCOD1A - Physical standby database (disabled)
    GCOD1B - Physical standby database (disabled)
    GCOD2B - Physical standby database (disabled)
    GCOD3A - Physical standby database (disabled)
    GCOD3B - Physical standby database
    GCOD4A - Physical standby database
      Error: ORA-01034: ORACLE not available

GCOD4B - Physical standby database
GCOD2A - Physical standby database (disabled)

Databases:

GESS1 - Primary database

GCOD1A - Physical standby database (disabled)

GCOD1B - Physical standby database (disabled)

GCOD2B - Physical standby database (disabled)

GCOD3A - Physical standby database (disabled)

GCOD3B - Physical standby database (disabled)

GCOD4A - Physical standby database (disabled)

GCOD4B - Physical standby database

GCOD2A - Physical standby database (disabled)

I also see that log_archive_dest_state for the physical standbys which are disabled in primary database GESS1 gets value RESET.

SQL> sho parameter log_archive_dest_state

log_archive_dest_state_2 string RESET

log_archive_dest_state_3 string RESET

log_archive_dest_state_4 string RESET

log_archive_dest_state_5 string RESET

log_archive_dest_state_6 string RESET

log_archive_dest_state_7 string RESET

log_archive_dest_state_8 string RESET

log_archive_dest_state_9 string ENABLE

Thankfull for some ideas on what could be wrong.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2014

Added on Mar 14 2014

#data-guard, #dataguard, #performance-availability

4 comments

6,293 views