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

dbLjy2015發表於2017-06-21
UIREMASTAI

DGMGRL> ENABLE FAST_START FAILOVER
Error: ORA-16651: requirements not met for enabling fast-start failover
Failed.

                    開啟FAST_START FAILOVER如果遇到如上報錯，可通過如下方式解決

其中最大效能要對應非同步
MaxPerformance/async
只有最大可用才能對應同步
MaxAvailability/sync

  1. DGMGRL> EDIT DATABASE <Physical standby> SET PROPERTY LogXptMode='async';
  2. Property "logxptmode" updated
  3. DGMGRL> EDIT DATABASE <Primary database> SET PROPERTY LogXptMode='async';
  4. Property "logxptmode" updated
  1. DGMGRL> show configuration
  2. Configuration - configuration_name
  4. Protection Mode: MaxPerformance
  5. Databases:
  6. - Primary database
  7. - Physical standby database
  10. Fast-Start Failover: DISABLED
  12. Configuration Status:
  13. SUCCESS
  1. DGMGRL> ENABLE FAST_START FAILOVER
  2. Enabled.
還有就要將主備庫開啟閃回資料庫

  1. sql> alter database flashback on;
備庫開啟閃回需要先停止應用日誌，開啟閃回後接著應用日誌

  1. sql> recover managed standby database cancel;
或
  1. dgmgrl> edit database set state=APPLY-OFF;


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30820196/viewspace-2141072/，如需轉載，請註明出處，否則將追究法律責任。

相關文章