Free Preparation Discussions
MENU
Oracle Exam 1Z0-066 Topic 2 Question 16 Discussion
Topic #: 2
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
dogsfs1 Far Sync
sheep Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
An attempt to enable fast-start failover raises an error:
DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover
Failed.
Identify two possible reasons for this error. (Choose two.)
D: Ensure that the LogXptMode property for both the primary database and the Fast-Start Failover target standby database are SYNC.
A: If more than one physical or logical standby database exists, in this case it is the sheep database, you must specify the FastStartFailoverTarget value explicitly, prior to enabling fast-start failover. The indicated target is verified when fast-start failover is enabled.
Note: DGMGRL> enable fast_start failover;
Error: ORA-16651: requirements not met for enabling fast-start failover
Failed.
SOLUTION
1) Check whether the flashback database is enabled on primary & standby database
Select flashback_on from gv$database;
2) Check whether you have set the FastStartFailoverTarget parameter.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR862
http://psoug.org/oraerror/ORA-16651.htm
Currently there are no comments in this discussion, be the first to comment!