Databroker and Fast Start Failover : Configuration

create configuration 'orcldgb' as primary database is 'orcl' connect identifier is orcl;
--enable configuration;
add database 'alpha' as connect identifier is 'alpha' maintained as physical;
show configuration;
edit database orcl set property staticconnectidentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1522)(HOST=192.168.56.101)) (CONNECT_DATA=(SERVICE_NAME=orcl)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))';
edit database alpha set property staticconnectidentifier='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1522)(HOST=192.168.56.102))(CONNECT_DATA=(SERVICE_NAME=alpha)(INSTANCE_NAME=orcl)(SERVER=DEDICATED)))';
edit database orcl set property ApplyLagThreshold=0;
edit database orcl set property TransportLagThreshold=0;
edit database alpha set property ApplyLagThreshold=0;
edit database alpha set property TransportLagThreshold=0;
enable configuration;
show configuration;

=======================================================================================================
DGMGRL> show configuration

Configuration - orcldgb

  Protection Mode: MaxPerformance
  Members:
  orcl  - Primary database
    alpha - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 59 seconds ago)


DGMGRL> switchover to 'alpha';
2024-10-02T12:10:02.179+05:30
Performing switchover NOW, please wait...

2024-10-02T12:10:03.278+05:30
Operation requires a connection to database "alpha"
Connecting ...
Connected to "ALPHA"
Connected as SYSDBA.

2024-10-02T12:10:03.609+05:30
Continuing with the switchover...

2024-10-02T12:10:24.768+05:30
New primary database "alpha" is opening...

2024-10-02T12:10:24.768+05:30
Operation requires start up of instance "orcl" on database "orcl"
Starting instance "orcl"...
Connected to an idle instance.

Connected to "orcl"
ORACLE instance started.
Connected to "orcl"
Database mounted.

Database opened.

Connected to "orcl"
2024-10-02T12:11:37.140+05:30
Switchover succeeded, new primary is "alpha"

2024-10-02T12:11:37.150+05:30
Switchover processing complete, broker ready.


-------------------------------
DGMGRL> show configuration

Configuration - orcldgb

  Protection Mode: MaxPerformance
  Members:
  alpha - Primary database
    orcl  - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 29 seconds ago)

DGMGRL> show configuration verbose

Configuration - orcldgb

  Protection Mode: MaxPerformance
  Members:
  alpha - Primary database
    orcl  - Physical standby database

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    TraceLevel                      = 'USER'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    ObserverReconnect               = '0'
    ObserverPingInterval            = '0'
    ObserverPingRetry               = '0'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'
    ObserverOverride                = 'FALSE'
    ExternalDestination1            = ''
    ExternalDestination2            = ''
    PrimaryLostWriteAction          = 'CONTINUE'
    ConfigurationWideServiceName    = 'orcl_CFG'
    ConfigurationSimpleName         = 'orcldgb'
    DrainTimeout                    = '0'

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS


SELECT NAME, DB_UNIQUE_NAME, SWITCHOVER_STATUS, DATABASE_ROLE, OPEN_MODE FROM V$DATABASE;
ORCL    ALPHA    TO STANDBY    PRIMARY    READ WRITE

ORCL    orcl    NOT ALLOWED    PHYSICAL STANDBY    READ ONLY WITH APPLY


nohup dgmgrl sys/oracle123@orcl "start observer" &