What four migration methods can be used?

You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle
Database Cloud Service (Database as a Service) that provides a pre-created Oracle
Database 12.1.0.2 database.
What four migration methods can be used?

A.
conventional export/import

B.
Transportable Tablespace (TTS) with RMAN conversion

C.
Transportable Tablespace (TTS) by using Oracle Data Pump

D.
SQL *Loader

E.
RMAN image restore

F.
Data Pump Transportable Database (TDB) export/import

Explanation:
You load data into an Oracle database on Oracle Database Cloud Service using the same
tools you would use for an Oracle database on another system.
* (D) Using SQL*Loader to Load Data into the Database
*Using Oracle DataPump Import to Load Data into the Database
* (BC)Using Transportable Tablespaces to Load Data into the Database
There are two ways to transport a tablespace:
Manually,involvingissuing commands to SQL*Plus, RMAN, and Data Pump.

Using the TransportTablespaces Wizard in Enterprise Manager
* Using Pluggable Databases (PDBs) to Load Data into the Database
* Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets
* (F) Full transportable export/import, is available to make migration toOracle Database 12c
faster, easier, and more efficient than ever before. Full transportable export is available
starting with Oracle Database 11g Release 2 (11.2.0.3).
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-datadb.html
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395
http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-
1973971.pdf

Show Hint

← Previous question

Next question →

Tina

A,B,C,F
You can migrate Oracle Database 11g databases from on-premises to Oracle Database
12c databases in Oracle Database Cloud using several different methods.

If you have not already done so, determine the database version and database
character set of your on-premises database, and determine the endian format of theplatform your on-premises database resides on. Use this information to help you
choose an appropriate method.
• Data Pump Conventional Export/Import
This method can be used regardless of the endian format and database character
set of the on-premises database.
For the steps this method entails, see Data Pump Conventional Export/Import.
• Data Pump Transportable Tablespace
This method can be used only if the on-premises platform is little endian, and the
database character sets of your on-premises database and Oracle Database Cloud
Service database are compatible.
For the steps this method entails, see Data Pump Transportable Tablespace.
• RMAN Transportable Tablespace with Data Pump
This method can be used only if the on-premises platform is little endian, and the
database character sets of your on-premises database and Oracle Database Cloud
Service database are compatible.
For the steps this method entails, see RMAN Transportable Tablespace with Data
Pump.
• RMAN CONVERT Transportable Tablespace with Data Pump
This method can be used only if the database character sets of your on-premises
database and Oracle Database Cloud Service database are compatible.
This method is similar to the Data Pump Transportable Tablespace method, with
the addition of the RMAN CONVERT command to enable transport between
platforms with different endianness. Query V$TRANSPORTABLE_PLATFORM to
determine if the on-premises database platform supports cross-platform
tablespace transport and to determine the endian format of the platform. The
Oracle Database Cloud platform is little-endian format.
For the steps this method entails, see RMAN CONVERT Transportable Tablespace
with Data Pump.
• Data Pump Full Transportable
This method can be used only if the source database release version is 11.2.0.3 or
later, and the database character sets of your on-premises database and Oracle
Database Cloud Service database are compatible.
For the steps this method entails, see Data Pump Full Transportable.