Free Preparation Discussions
MENU
Oracle Exam 1Z0-076 Topic 5 Question 18 Discussion
Topic #: 5
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: Max Availability
Databases:
dogs - Primary database sheep
- Physical standby database cats
- 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 three possible reasons for this error.
To increase the number of applier processes on a logical standby database, the following changes can be made:
C: Increasing the value for the MAX_SERVERS SQL apply parameter would allow for more applier processes to be initiated, assuming that system resources permit.
D: Increasing the PARALLEL_MAX_SERVERS initialization parameter would allow for more parallel execution processes, which can be used by SQL apply to increase the number of applier processes.
Option A is incorrect as decreasing the number of archiver processes will not necessarily increase the number of applier processes; these are unrelated components.
Option B is incorrect because the 'FREPARER' processes do not exist, it seems to be a typographical error, and the 'REPARER' is not a valid Oracle process or parameter.
Option E is incorrect because the RECOVERY_PARALLELISM parameter controls the number of processes used for instance recovery and media recovery, not for SQL apply.
Elina
2 months agoShannon
17 days agoJestine
26 days agoIvory
1 months agoBrice
2 months agoWillard
4 days agoDierdre
6 days agoAyesha
1 months agoElinore
1 months agoElke
2 months agoKimberely
2 months agoCarri
2 months agoJaime
2 months agoJeff
2 months agoBrittney
2 months agoFelice
19 days agoLeoma
2 months agoJaclyn
2 months agoAugustine
3 months ago