Oracle Cloud Infrastructure 2023 AI Foundations Associate — Question 2

When preparing for a migration using RMAN DUPLICATE from an active database, which two actions do you need to take if the on-premises database (DB) is Transparent Data Encryption (TDE) encrypted?

Answer options

• A. Perform an RMAN backup of the on-premises DB to OCI Cloud Storage.
• B. Make sure that the SYS user password is identical on both systems.
• C. Copy the encryption wallet from the on-premises DB to the Cloud DB System.
• D. Use the dbcli dbstorage command to identify the DATA, RECO, and REDO locations.

Correct answer: C

Explanation

The correct answer is C because the encryption wallet must be transferred to ensure that TDE remains functional in the Cloud Database System. Option A is incorrect as performing a backup does not directly relate to TDE; B is not required since the SYS user password does not affect TDE; and D, while useful for identifying storage locations, does not directly impact TDE migration.