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

Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)

Answer options

• A. A rolling release upgrade can be performed with the Data Guard environment in any protection mode.
• B. The transient logical standby database used for the rolling release upgrade can run with a newer version of the Oracle software than the primary database.
• C. The transient logical standby database used for the rolling release upgrade must have the same DBID as the primary database.
• D. The original primary database can ship redo to any standby database that is part of the Data Guard configuration during the rolling release upgrade process.
• E. SELECT GUARD_STATUS FROM V$DATABASE; must return NONE as a prerequisite for the rolling release upgrade with a transient logical standby database.

Correct answer: B, D, E

Explanation

Option B is correct because the transient logical standby database can indeed run a newer version of Oracle software, which is essential for the upgrade. Option D is correct as the primary database can continue to ship redo logs to other standby databases during the upgrade. Option E is also correct since the prerequisite for the upgrade is that the GUARD_STATUS must return NONE. Options A and C are incorrect; the upgrade can be performed in specific protection modes and the transient logical standby database does not need to have the same DBID as the primary database.