You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to 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 theexpdp 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.
A.
2, 1, 3, 4, 5, 6
B.
1, 3, 4, 5, 6, 7
C.
1, 4, 3, 5, 6, 7
D.
2, 1, 3, 4, 5, 6, 7
E.
1, 5, 6, 4, 3, 2
Explanation:
1. Set user tablespaces in the source database to READ ONLY.
2. 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 VER$ION=12 parameter is required only when exporting from an Oracle Database
llg Release 2 database:
3. Copy the tablespace data files from the source system to the destination system. Note that the log file from
the export operation will list the data files required to be moved.
4. Create a COB on the destination system, including a PDB into which you will import the source database.
5. In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file. The act
of importing the dump file will plug the tablespace data files into the destination PDB
Oracle White Paper – Upgrading to Oracle Database 12c -August 2013
Hi All,
Any once can sent me the 1Z0- 060(v.4) exam paper dump.
Thanks,
Sravan
If C is right, then why not B? There is no DBMS_PDS.SYNC_ODB function in any Oralce document(7). If eliminate any answers with (7), the only possible path is A
D
“Run the following procedure to synchronize the PDB:
EXECUTE DBMS_PDB.SYNC_PDB;” from https://docs.oracle.com/database/122/DVADM/dba-operations-in-an-oracle-database-vault-environment.htm#DVADM71239
A is correct. you can not plug an 11G database into a CDB without upgrading it to 12C.