FAST START FAILOVER (FSFO) CONFIGURATION USING  FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL

 

1.For data guard DGMGRL configuration and Far Sync setup please follow below link:-

//clouddba.co/step-step-oracle-active-data-guard-far-sync-rac/

 

2.Please check current database status

DGMGRL> show database  ebilpd1;

 

Database – ebilpd1

 

Role:               PRIMARY

Intended State:     TRANSPORT-ON

Instance(s):

EBILPD11

EBILPD12

 

Database Status:

SUCCESS

 

DGMGRL> show database ebildr1;

Database – ebildr1

Role:               PHYSICAL STANDBY

Intended State:     APPLY-ON

Transport Lag:      0 seconds (computed 0 seconds ago)

Apply Lag:          0 seconds (computed 0 seconds ago)

Average Apply Rate: 5.00 KByte/s

Real Time Query:    OFF

Instance(s):

EBILDR11 (apply instance)

EBILDR12

 

Database Status:

SUCCESS

 

3. Enable SYNC transport between Primary and standby

 

EDIT DATABASE EBILDR1 SET PROPERTY RedoRoutes = ‘(LOCAL : EBILPD1 SYNC)’;

EDIT DATABASE EBILPD1 SET PROPERTY RedoRoutes = ‘(LOCAL : ORCLFS SYNC ALT =(EBILDR1 SYNC FALLBACK))’;

edit database EBILDR1 set property FastStartFailoverTarget=’EBILPD1′;

edit database EBILPD1 set property FastStartFailoverTarget=’EBILDR1′;

 

4.Enable flashback on Primary and Standby

SQL>alter database flashback on;

 

5.Now enable fast start failover from dgmgrl after login to Primary

 

export ORACLE_SID=EBILPD1

dgmgrl /

DGMGRL>  enable fast_start failover ;

Enabled.

 

6.But We will get below error as observer is not setup yet

DGMGRL> show configuration

 

Configuration – DGconfig

Protection Mode: MaxAvailability

Members:

ebilpd1 – Primary database

Error: ORA-16820: fast-start failover observer is no longer observing this database

orclfs  – Far sync instance

ebildr1 – (*) Physical standby database

Error: ORA-16820: fast-start failover observer is no longer observing this database

Fast-Start Failover: ENABLED

 

Configuration Status:

ERROR   (status updated 38 seconds ago)

 

7.Now please connect to Far Sync server from dgmgrl invoked from Primary and start Observer.

 

[oracle@EBILPD1 XXX trace]$ dgmgrl /

DGMGRL for Linux: Version 12.1.0.2.0 – 64bit Production

 

Copyright (c) 2000, 2013, Oracle. All rights reserved.

 

Welcome to DGMGRL, type “help” for information.

Connected as SYSDG.

DGMGRL> connect sys@orclfs

Password:

Connected as SYSDBA.

DGMGRL> START OBSERVER;

Observer started

 

 

8.From Another terminal, login to primary node and check the status of DGMGRL configuration.

[oracle@EBILPD1 xxx ~]$ dgmgrl /

DGMGRL for Linux: Version 12.1.0.2.0 – 64bit Production

 

Copyright (c) 2000, 2013, Oracle. All rights reserved.

 

Welcome to DGMGRL, type “help” for information.

Connected as SYSDG.

DGMGRL> show configuration;

 

Configuration – DGconfig

 

Protection Mode: MaxAvailability

Members:

ebilpd1 – Primary database

orclfs  – Far sync instance

ebildr1 – (*) Physical standby database

 

Fast-Start Failover: ENABLED

 

Configuration Status:

SUCCESS   (status updated 53 seconds ago)