Which two methods are supported for migrating your on-premises Oracle database to an Oracle Autonomous Transaction Processing (ATP) database in Oracle Cloud Infrastructure? (Choose two.)
A.
Load text files into ATP using SQL Developer.
B.
Use RMAN duplicate.
C.
Use Oracle Data Pump.
D.
Transfer the physical database files and re-create the database.
IT is A and C.
REF:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#MIGRATION-BOOKMARK
It is clearly written that RMAN is NOT supported and "Data Pump" is the official way to go.
AC are correct.
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-sqldeveloper-web.html#GUID-C06A4E05-CCD1-4241-A8FB-76A19F5F727F
The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB using Data Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.
In the current release you cannot use physical migration methods like backup/restore, Data Guard, database clones, and transportable tablespaces to move your existing database to ADB.
A,C correct
How can I migrate my existing Oracle Database to Oracle Autonomous Database?
: Since an ADB database has some restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.
B and C maybe
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/mig-rman-duplicate-active-database.htm
This topic explains how to migrate an entire, active container database (CDB) or non-CDB database to Oracle Cloud Infrastructure by using RMAN Active Duplication. The database to be migrated can reside on-premises or in Oracle Cloud Infrastructure Classic.
B and C
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/migrating.htm
Migration Methods
Many methods exist to migrate Oracle databases to the Oracle Cloud Infrastructure Database service. Which of these methods apply to a given migration scenario depends on several factors, including the version, character set, and platform endian format of the source and target databases.
Data Pump Conventional Export/Import
Data Pump Full Transportable
Data Pump Transportable Tablespace
Remote Cloning a PDB
Remote Cloning Non-CDB
RMAN Cross-Platform Transportable PDB
RMAN Cross-Platform Transportable Tablespace Backup Sets
RMAN Transportable Tablespace with Data Pump
RMAN DUPLICATE from an Active Database
RMAN CONVERT Transportable Tablespace with Data Pump
SQL Developer and INSERT Statements to Migrate Selected Objects
SQL Developer and SQL*Loader to Migrate Selected Objects
Unplugging/Plugging a PDB
Unplugging/Plugging Non-CDB
Zero Downtime Migration Service
i think A & C are the most proper ways. RMAN is not supported for migration and any backup/ or physical DB files should have the same file / DB structure in order to migrate directly
I think it's AC. RMAN, or physical migration methods like backup/restore are not supported (https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html)
RMAN and Data pump makes more sense in migration, since there is no data volume in question
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
KAYSERSOZE
Highly Voted 3 years, 10 months agoCarminetor
Highly Voted 4 years, 1 month agoabhijitviktor
Most Recent 2 years, 1 month ago_Ahmed_Hassan_
3 years agoYeanka
2 years, 11 months agoSherifci
3 years, 2 months agoDylan3160
3 years, 2 months agoethylyn
3 years, 2 months agoJavierV
3 years, 10 months agobriansbums
3 years, 10 months agovlad_74
3 years, 8 months agoJoe_Qu
2 years, 8 months agoabhijitviktor
2 years, 1 month agosatyalanka
3 years, 10 months agod5a865u
4 years agoAmrWaly
4 years agodreadsi3
4 years agoriso51
4 years, 1 month agopattabi
4 years, 2 months ago