Oracle
1Z0-067 · Question #54
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the…
The correct answer is C. 1, 4, 3, 5, 6, 7. 1. Create a directory in source database to store the export dump files. 2. Set the user and application tablespace in the source database as READ ONLY 3. Export the source database using expdp with parameters version=12.0, transportable=always 4. Copy the dumpfile and…
Upgrading to Oracle Database 12c
Question
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). The following are the possible steps to accomplish this task: 1. Place all the user-defined tablespace in read-only mode on the source database. 2. Upgrade the source database to a 12c version. 3. Create a new PDB in the target container database. 4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility. 5. Copy the associated data files and export the dump file to the desired location in the target database. 6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.
Options
- A2, 1, 3, 4, 5, 6
- B1, 3, 4, 5, 6, 7
- C1, 4, 3, 5, 6, 7
- D2, 1, 3, 4, 5, 6, 7
- E1, 5, 6, 4, 3, 2
How the community answered
(67 responses)- A3% (2)
- B12% (8)
- C79% (53)
- D1% (1)
- E4% (3)
Explanation
- Create a directory in source database to store the export dump files. 2. Set the user and application tablespace in the source database as READ ONLY 3. Export the source database using expdp with parameters version=12.0, transportable=always 4. Copy the dumpfile and datafiles for tablespaces containing user /application data. 5. Create a new PDB in the destination CDB using create pluggable database command. 6. Create a directory in the destination PDB pointing to the folder containing the dump file or create a directory for dump file and move the dump file there. 7. Create an entry in tnsnames.ora for the new PDB. 8. Import in to the target using impdp with parameters FULL=Y and TRANSPORT_DATAFILES parameters. Make sure, the account is having IMP_FULL_DATABASE. 9. Restore the tablespaces to READ-WRITE in source database.
Topics
#PDB migration#full transportable export#Data Pump#11g to 12c upgrade
Community Discussion
No community discussion yet for this question.