Skip to Main Content

Database Software

DGMGRL - FSFO Configuration with Maximum Performance Mode

CloudDBOct 18 2016 — edited Jun 29 2017

Hi Oracle Gurus,

Our Environment:

Oracle12c 2-Node Grid/RAC with ASM on RHEL Platform

Exiting Database Deployment:

RAC to RAC Active Data guard

Solution we are looking for:

We want to configure Data guard - Data broker FSFO with Maximum Performance Mode.

We don't want to configure Flashback database on primary or standby.

We don't want to reinstate automatically.

DGMGRL> show configuration

Configuration - DGConfig

  Protection Mode: MaxPerformance

  Members:

  blrdb - Primary database

    blrdr - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 44 seconds ago)

DGMGRL> show fast_start failover;

Fast-Start Failover: DISABLED

  Threshold:          60 seconds

  Target:             (none)

  Observer:           csm-srv-130

  Lag Limit:          10 seconds

  Shutdown Primary:   TRUE

  Auto-reinstate:     TRUE

  Observer Reconnect: (none)

  Observer Override:  FALSE

Configurable Failover Conditions

  Health Conditions:

    Corrupted Controlfile          YES

    Corrupted Dictionary           YES

    Inaccessible Logfile            NO

    Stuck Archiver                  NO

    Datafile Offline               YES

  Oracle Error Conditions:

    (n

one)

DGMGRL> show configuration verbose

Configuration - DGConfig

  Protection Mode: MaxPerformance

  Members:

  blrdb - Primary database

    blrdr - Physical standby database

  Properties:

    FastStartFailoverThreshold      = '60'

    OperationTimeout                = '30'

    TraceLevel                      = 'SUPPORT'

    FastStartFailoverLagLimit       = '30'

    CommunicationTimeout            = '180'

    ObserverReconnect               = '0'

    FastStartFailoverAutoReinstate  = 'TRUE'

    FastStartFailoverPmyShutdown    = 'TRUE'

    BystandersFollowRoleChange      = 'ALL'

    ObserverOverride                = 'FALSE'

    ExternalDestination1            = ''

    ExternalDestination2            = ''

    PrimaryLostWriteAction          = 'CONTINUE'

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

DGMGRL> enable fast_start failover;

Error: ORA-16693: requirements not met for enabling fast-start failover

Regards,

Hitgon

This post has been answered by CKPT on Oct 19 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2017
Added on Oct 18 2016
17 comments
5,871 views