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,D,E
B,D,E