You plan to migrate an Oracle database supporting an online transaction processing (OLTP) workload to an X5
Exadata Database Machine.
The database machine is running database version 12.1.0.2.
The source database has these attributes:
Database version: 12.1.0
Byte order: Big Endian
Database size: 24 TB
You have decided to perform physical migration using the Transportable Tablespace method.
Examine this list of possible steps to accomplish this task.
1. Create a new 12.1.0.2 Exadata –based database.
2. Export the source system metadata using transportable Tablespace (TTS).
3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the
little endian format.
4. Import the metadata into the target database.
5. Use the RMAN CONVERT to change the database files to the little endian format on the source system.
Identify the required steps in the correct order.
A.
1, 2, 4, 5
B.
1, 2, 5, 3, 4C. 1, 2, 3, 4, 5
D.
1, 2, 3, 4
E.
1, 2, 5, 4, 3
F.
1, 2, 5, 4
Explanation:
Step 1: 1. Create a new 12.1.0.2 Exadata –based database.
Step 2: 2. Export the source system metadata using transportable Tablespace (TTS).
Step 3: 3. Transfer the files to the Database Machine and use the RMAN CONVERT command to change them to the little endian format.
Step 4: 4. Import the metadata into the target database.
This method is often chosen when migrating between platforms with different endian formats, or in cases where physical re-organization is not necessary.
The transportable tablespace method is generally mu
References: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/mig-transportable-tablespace.html