1.Error while enabling the fast start failover
2.Checked the dataguard logfile for any more detail on the error message
3.Checked and changed the logxptmode from the sync to async, enabled the fsfo
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:
Post a Comment