Q: 9
You created the PRODSBY1 physical standby database for the PROD primary database using gql and
RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:
Which three statements are true regarding the execution of the command?
Which three statements are true regarding the execution of the command?Options
Discussion
A is wrong, F. Had something like this in a mock and needed connectivity to both.
Its F. I remember a similar question where it required Net connectivity to both PROD and PRODSBY1 before creating the Data Guard Broker config. Maybe I'm mixing up the step, but I think F makes sense here even if others say just PROD is needed. Open to being wrong!
Option F
A is wrong, A, D, E. You need DG_BROKER_START on the primary and Net connectivity for PROD specifically. The config files part (E) happens automatically too. Think that's it unless something changed in a new release. Agree?
Its A, D, E. You need DG_BROKER_START enabled on the primary, and Oracle Net set up for PROD so the broker can talk to it. The config files are created automatically with those parameters. Feel like that's right but happy if someone spots a catch.
Check the official Oracle Data Guard docs and practice questions for this-A, D, E.
I don’t think it’s B. A, D, E. The standby isn’t auto-added just because DG_BROKER_START is TRUE on PRODSBY1, it’s more about the broker config and connectivity for the primary. Seen similar wording in Oracle docs but I could be missing something small.
I don't think it's F. A, D, and E fit better since you only need DG_BROKER_START=TRUE on the primary, Net config to PROD, and the broker config files get auto-created. Pretty sure you don’t need connectivity to standby at this step but let me know if I missed something.
D imo
I don't think option F is right here, since you only need Oracle Net connectivity to the PROD instance when creating the config, not both PROD and PRODSBY1. Config files do get created automatically (E) and DG_BROKER_START has to be TRUE on the primary for this (A). D makes sense too, but B is a bit of a distractor because adding the standby isn't automatic. Pretty sure it's A, D, E unless Oracle changed something I missed. Anyone see it another way?
Be respectful. No spam.
