Which two are true about the output of this DGMGRL command?

Prev Question
Next Question

You have a Data Guard Broker configuration called ‘Somewhere’ as shown:
DGMGRL> show configuration;
Configuration –Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby-Primary database
FS-Far Sync
Farout-Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
You then run this command:
DGMGRL> SHOW DATABASE ‘Nearby’ ‘InconsistentProperties’;
Which two are true about the output of this DGMGRL command?

A.
A far sync instance cannot have inconsistent properties because it has no database.

B.
It shows all properties whose broker configuration values for database Nearby are inconsistent with the
broker configuration values for database Farout.

C.
It shows all properties whose broker configuration values for database Nearby are inconsistent with thevalues in the corresponding server parameter file or the runtime values for database instance Nearby.

D.
Any inconsistency reported is on an instance-specific basis.

Explanation:
C: InconsistentProperties arises out of mismatch of parameter values between spfile, Data Guard Broker
configuration and the database.
D (not A): The InconsistentProperties monitorable property returns a table that shows all properties whose
values contained in the broker configuration file are inconsistent with the values in the corresponding server
parameter file or the runtime values.
Although the properties reported in this table are database-specific or far sync instance-specific properties, the
inconsistency is reported on an instance-specific basis.
https://docs.oracle.com/database/121/DGBKR/dbpropref.htm#DGBKR760

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *