Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 62

A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows.
As a result of this, you decide that an upgrade may not use logical standby databases.
Which three are true about upgrading Data Guard environments consisting of one physical standby database running on a separate host from the primary?

Answer options

• A. The upgrade requires downtime until the upgrade of the standby is completed.
• B. The broker must be disabled during the upgrade.
• C. With manual upgrade, catupgrd.sq1 can be executed on the primary and standby databases simultaneously.
• D. The upgrade requires downtime until the upgrade of the primary is completed.
• E. The new release of the Oracle Software must be installed on both the primary and standby database hosts.
• F. Redo Apply on the standby database must be stopped while the primary database is upgraded.
• G. Fast-Start Failover can be used to protect the primary database during the upgrade.

Correct answer: B, D, E

Explanation

The correct answers B, D, and E are true because the broker must indeed be disabled during the upgrade to prevent conflicts, the primary database requires downtime until its upgrade is completed, and both the primary and standby hosts need the new Oracle Software version installed. Options A, C, F, and G are incorrect as they do not accurately reflect the requirements or processes involved in upgrading a Data Guard environment with a physical standby database.