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.)
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.)
The two methods supported for migrating an on-premises Oracle database to an Oracle Autonomous Transaction Processing (ATP) database in Oracle Cloud Infrastructure are using Oracle Data Pump and loading text files into ATP using SQL Developer. Oracle Data Pump is a well-established tool for exporting and importing database objects and is specifically designed for such migrations. Loading text files using SQL Developer is another supported method that allows data to be moved efficiently into ATP. Other methods like RMAN duplicate or transferring physical database files are not supported due to the specific limitations and requirements of the Autonomous Database environment.
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
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)
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
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
why this option can not be used? SQL Developer and INSERT Statements to Migrate Selected Objects
Because of the "selected objects" clause. You want to migrate the entire DB
Because of the "selected objects" clause. You want to migrate the entire DB
Thanks for this. As per Oracle official document RMAN/Data Pump are valid options. B,C are correct
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 and C are the correct answers
i think answers C & D
It should be CD
RMAN and Data pump makes more sense in migration, since there is no data volume in question
A and C
A nd C is the answer RMAN wont work and what we will do by copying data files to OCOI when RMAN is not supported
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. Already pass the ADB exam just like this is the question
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, C RMAN Duplicate is mentioned on ORacle Documentation https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/migrating.htm