DGMGRL> ENABLE FAST_START FAILOVER
Error: ORA-16651: requirements not met for enabling fast-start failover
Failed.
开启FAST_START FAILOVER如果遇到如上报错,可通过如下方式解决
其中最大性能要对应异步
MaxPerformance/async
只有最大可用才能对应同步
MaxAvailability/sync
-
DGMGRL> EDIT DATABASE <Physical standby> SET PROPERTY LogXptMode='async';
-
Property "logxptmode" updated
-
DGMGRL> EDIT DATABASE <Primary database> SET PROPERTY LogXptMode='async';
-
Property "logxptmode" updated
-
DGMGRL> show configuration
-
Configuration - configuration_name
-
-
Protection Mode: MaxPerformance
-
Databases:
-
- Primary database
-
- Physical standby database
-
-
-
Fast-Start Failover: DISABLED
-
-
Configuration Status:
-
SUCCESS
-
DGMGRL> ENABLE FAST_START FAILOVER
-
Enabled.
还有就要将主备库开启闪回数据库
-
sql> alter database flashback on;
备库开启闪回需要先停止应用日志,开启闪回后接着应用日志
-
sql> recover managed standby database cancel;
或
-
dgmgrl> edit database set state=APPLY-OFF;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30820196/viewspace-2141072/
,如需转载,请注明出处,否则将追究法律责任。