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