Oracle FSFO Configuration with Observer setup - Fast-Start Fail Over

FSFO configuration


1. set the fast start failover target as below for both primary and standby

DGMGRL> EDIT DATABASE t1enb3d5 SET PROPERTY FastStartFailoverTarget='t2enb4d4';

Property "faststartfailovertarget" updated

DGMGRL> EDIT DATABASE t2enb4d4 SET PROPERTY FastStartFailoverTarget='t1enb3d5';

Property "faststartfailovertarget" updated



2. Please set protection mode to maximum availability or maximum protection


DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

OR

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;


3. set below parameters on primary

ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=1440 SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_recovery_file_dest_size=720G;

ALTER SYSTEM SET db_recovery_file_dest='+T1ENB3D5_ORAFLSH';

ALTER DATABASE FLASHBACK ON;



4. set below parameter on standby

ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=1440 SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_recovery_file_dest_size=720G SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_recovery_file_dest='+T2ENB4D4_ORAFLSH' SCOPE=BOTH SID='*';

ALTER DATABASE FLASHBACK ON;


Observer Configuration


5. Observer should run on different server from primary and standby

dgmgrl

DGMGRL> connect sys/Testing123@t1enb3d5.db.att.com

connected

DGMGRL> start observer file='/opt/app/t1enb3d2/oracle/local/observer/fsfo.dat'

Observer started


6. enable fast start failover from primary

DGMGRL> ENABLE FAST_START FAILOVER;

Enabled.

DGMGRL> show fast_start failover


7. show database status report (for error)

DGMGRL> show database t1enb3d5 statusreport;


8. create a script as below to start observer on reboot /opt/app/t1enb3d2/oracle/local/observer/start_observer.ksh


you may need to modify script as this is not tested.

#!/bin/ksh

export true=`dgmgrl sys/Testing123@t1enb3d5 "show configuration" |grep t1enb3d5| wc -l `

if [ $true -eq 0 ] then

dgmgrl sys/Testing123@t1enb3d5 "start observer file='/opt/app/t1enb3d2/oracle/local/observer/fsfo.dat'"

EOF


schedule in crontab as below 


00 01 * * *  /bin/ksh /opt/app/t1enb3d2/oracle/local/observer/start_observer.ksh >>/opt/app/t1enb3d2/oracle/local/observer/start_observer.log