1Z0-076 practice question 24 of 25

You have a Data Guard Broker configuration called 'Somewhere' as shown: DGMGRL> SHOW CONFIGURATION; Configuration - Somewhere Protection Mode…

Full set: 107 questions
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?
Answer options
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: Any inconsistency reported is on an instance-specific basis. Correct answer
D: It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby. Correct answer
Correct Answer:
C. Any inconsistency reported is on an instance-specific basis.; D. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
Explanation

The SHOW DATABASE ... 'InconsistentProperties' command in DGMGRL is a diagnostic tool. It compares the property settings stored in the Data Guard broker configuration file against the current values in the database's server parameter file (SPFILE) or the running instance's memory. This check is performed for the specific database named in the command ('Nearby'). For Oracle RAC databases, any reported inconsistencies are shown on a per-instance basis, making the report instance-specific. The command does not compare properties between different databases in the configuration.

Why Incorrect

A: A far sync instance is managed by the broker and has configurable properties. It can have inconsistent properties if its settings differ from the broker configuration. B: This command does not compare properties between two different databases (e.g., 'Nearby' and 'Farout'); it checks for internal consistency within a single database's configuration.

References

1. Oracle Database 19c, Data Guard Broker, Chapter 4, "SHOW DATABASE". The documentation states, "The InconsistentProperties property shows any properties whose values are not consistent between the broker and the database... For an Oracle RAC database, the broker displays any instance-specific properties that have inconsistent values."

Scroll to Top