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?
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.
Explanation:
B: Disable the broker’s management of the configuration and then stop the broker.
E: On the primary database install the newer release of the Oracle software, and on the logical standby database, install the newer release of the Oracle software.
Incorrect Answers:
C: Oracle Database 12c introduces a new command-line upgrade utility (catctl.pl). This utility replaces the catupgrd.sql script used to upgrade to previous releases
of Oracle Database. The new command-line upgrade utility enables parallel processing during the database upgrade, resulting in better upgrade performance and
reduced database downtime.
G: Disable fast-start failover if it is enabled.https://docs.oracle.com/database/121/SBYDB/upgrades.htm
https://docs.oracle.com/database/121/DGBKR/upgrade_appx.htm#DGBKR1212
B is true only in case of mayor release upgrades i.e. from 11g -> 12c.
In other cases it’s not necessary.
“If you are using the Oracle Data Guard broker to manage your configuration, follow the instructions in the Oracle Data Guard Broker manual for information about removing or disabling the broker configuration.”
https://docs.oracle.com/database/121/SBYDB/upgrades.htm#SBYDB4931
This is for upgrading, not for patching
https://docs.oracle.com/cd/B28359_01/server.111/b28294/upgrades.htm#CHDEGEBB
E,B,D
We did bunch of upgrades with our physical standby DG environments recently so sure about this.
Agree B,D and E