ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 54 discussion

Actual exam question from Oracle's 1z0-062
Question #: 54
Topic #: 1
[All 1z0-062 Questions]

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
Character set: AL32UTF8
National character set: AL16UTF16
O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character Set: AL32UTF8
National character set: AL16UTF16
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

  • A. Transportable database
  • B. Transportable tablespace
  • C. Data Pump full export/import
  • D. The DBMS_PDB package
  • E. RMAN
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
* Overview, example:
- Log into ncdb12c as sys
- Get the database in a consistent state by shutting it down cleanly.
- Open the database in read only mode
- Run DBMS_PDB.DESCRIBE to create an XML file describing the database.
- Shut down ncdb12c
- Connect to target CDB (CDB2)
- Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)
- Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).
- Access the PDB and run the noncdb_to_pdb.sql script.
- Open the new PDB in read/write mode.
* You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.
* Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.
by TuxBingo at July 21, 2020, 3:40 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
TuxBingo
Highly Voted 4 years, 10 months ago
I agree with the answer is B. Why-- http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf TABLE 2 . DATABASE UPGRADE AND MIGRATION METHODS – PAGE 7
upvoted 7 times
soniat
4 years, 2 months ago
cis the correct answer
upvoted 1 times
soniat
4 years, 2 months ago
i meant d
upvoted 2 times
...
...
...
Ray520
Most Recent 3 years, 2 months ago
The key here is "minimize downtime". Transportable tablespaces (starts from db version 11.2.0.3) is the fastest way to upgrade.
upvoted 1 times
...
Kotek___3
3 years, 3 months ago
Selected Answer: D
I think that the answer is D as there is no need for transport and dbms_pdb describe allows to use datafiles of a non-CDB db, therefore less downtime
upvoted 1 times
Ray520
2 years, 10 months ago
version has to be 12c for both to plug non-CDB into an CDB using DBMS_PDB package. Here versions are different
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel