Free Preparation Discussions
MENU
Oracle Exam 1Z0-063 Topic 11 Question 27 Discussion
Topic #: 11
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
This example is a dumpfile-based full transportable export/import operation. In this case the metadata from the source database is exported to a dump file, and both the dump file and the tablespace data files are transferred to a new system. The steps would be as follows:
* (2) Set user tablespaces in the source database to READ ONLY.
* (5) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (1) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.
* (4) Copy the tablespace data files from the source system to the destination system.
* (7) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
References: http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11
Currently there are no comments in this discussion, be the first to comment!