Oracle Database 12c: Advanced Administration — Question 100

You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1. Place all user-defined tablespaces in read-only mode on the source database.
2. Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3. Perform a full transportable export on the source database with the parameters
VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

Answer options

• A. 1, 3, 5, 4, 2, and 6
• B. 1, 2, 4, 6, 5, 3, and 7
• C. 1, 2,4, and 7
• D. 2, 4, 5, 6, and 7

Correct answer: A

Explanation

The correct steps to successfully migrate the database are to first set the user-defined tablespaces to read-only, export the data using the specified parameters, and then transport both the data files and the export dump file before performing the import. Options B, C, and D either omit necessary steps or rearrange them in an incorrect order, which would prevent a successful migration.