Sunday, July 20, 2014

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

1.Error while enabling the fast start failover
 dgmgrl -echo 'sys/sys123@orcl_uk'
DGMGRL for Linux: Version 12.1.0.1.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> show configuration
show configuration

Configuration - broker1

  Protection Mode: MaxPerformance
  Databases:
  orcl_in - Primary database
    orcl_uk - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> enable fast_start failover
enable fast_start failover
Error: ORA-16693: requirements not met for enabling fast-start failover


2.Checked the dataguard logfile for any more detail on the error message
/u03/app/oracle/diag/rdbms/orcl_in/orcl1/trace
[oracle@ol6-112-rac1 trace]$ tail -100f drcorcl1.log
.............
ENABLE FAST_START FAILOVER
MaxPerformance FSFO requires LogXptMode=ASYNC for primary and target standby databases, and no Far Sync is allowed between primary andtarget standby databases.
..................

3.Checked and changed the logxptmode from the sync to async, enabled the fsfo
dgmgrl sys/sys123@orcl_in
DGMGRL for Linux: Version 12.1.0.1.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.
Connected as SYSDBA.
DGMGRL> show database 'orcl_in' logxptmode
  LogXptMode = 'sync'
DGMGRL> show database 'orcl_uk' logxptmode
  LogXptMode = 'sync'
DGMGRL> edit database 'orcl_uk' set property logxptmode='async';
Property "logxptmode" updated
DGMGRL> edit database 'orcl_in' set property logxptmode='async';
Property "logxptmode" updated
DGMGRL> enable fast_start failover
Enabled.


No comments: