Which two are true about the usage of DBMS_ROLLING?
A.
The leading group contains the original primary database.
B.
The trailing group contains the original primary database.
C.
The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
D.
At least one logical standby database must be part of the initial Data Guard configuration.
E.
The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
Explanation:
E: The trailing group contains the original primary database and standby databases that will protect the original primary during the rolling upgrade process.
D: Databases in the leading group are upgraded first; hence the name leading group. The leading group contains the designated future primary database, and the
physical standbys that you can configure to protect the designated future primary. The future primary is first converted into a logical standby database and then the
new database software is installed on it and the upgrade process is run. Other standby databases in the leading group also must have their software upgraded at
this point.
Note: To upgrade the database software in an Oracle Data Guard configuration in a rolling fashion, you first designate a physical standby as the future primary
database.
Conceptually, the rolling upgrade process splits the Oracle Data Guard configuration into two groups: the leading group (LG) and the trailing group (TG).Incorrect Answers:
A: The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary.https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm#SBYDB5431
BE
D is false, the rolling upgrade will convert the physical standby to a logical standby (LGM).
https://docs.oracle.com/cloud/latest/db121/ARPLS/d_rolling.htm#ARPLS74608
When the START_PLAN procedure is complete, the LGM (identified with the future_primary parameter in the INIT_PLAN procedure) will be converted into a fully configured transient logical standby database.
https://docs.oracle.com/database/121/SBYDB/dbms_rolling_upgrades.htm#SBYDB5431
Databases in the leading group are upgraded first; hence the name leading group. The leading group contains the designated future primary database, and the physical standbys that you can configure to protect the designated future primary. The future primary is first converted into a logical standby database and then the new database software is installed on it and the upgrade process is run.
The trailing group contains the original primary database and standby databases that will protect the original primary during the rolling upgrade process.
Correct:
B,E
B, E
B,E
Agree B adn E