FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL
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
- 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)
