nerdexam
Oracle

1Z0-931-20 · Question #20

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug…

The correct answer is A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone. Explanation/Reference: 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. The main migration tool for migrating to ADB is Data Pump. You can export your schemas and…

Migrating to Autonomous Database

Question

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?

Options

  • APluggable databases cannot be migrated to ADB using plug, unplug or clone.
  • BCreate a database link from source database to the ADB environment and clone the PDB.
  • CUnplug to an xml file so database files and xml file can be uploaded to object storage.
  • DUnplug into a pdb archive which can be uploaded to object storage.

How the community answered

(24 responses)
  • A
    79% (19)
  • B
    13% (3)
  • C
    4% (1)
  • D
    4% (1)

Explanation

Explanation/Reference: 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. 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 In the current release you cannot use physical migration methods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to

Topics

#PDB migration#plug-unplug#on-premise migration#pluggable database

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice