Which three statements are true concerning unplugging a pluggable database (PDB)?
A.
The PDB must be open in read only mode.
B.
The PDB must be dosed.
C.
The unplugged PDB becomes a non-CDB.
D.
The unplugged PDB can be plugged into the same multitenant container database (CDB)
E.
The unplugged PDB can be plugged into another CDB.
F.
The PDB data files are automatically removed from disk.
Explanation:
B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode
information in an endianness-sensitive way. There is no supported way to handle the conversion
of such columns automatically. This means, quite simply, that an unplugged PDB cannot be
moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most
effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles
can remain in place.
Reference: Oracle White Paper, Oracle Multitenant
Answer: A,D,E
b,d,e
I think ‘B’ is the right Answer as
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13856
The PDB must be closed before it can be unplugged. When you unplug a PDB from a CDB, the unplugged PDB is in mounted mode. The unplug operation makes some changes in the PDB’s data files to record, for example, that the PDB was successfully unplugged. Because it is still part of the CDB, the unplugged PDB is included in an RMAN backup of the entire CDB. Such a backup provides a convenient way to archive the unplugged PDB in case it is needed in the future.
Not ‘A’
you are right…I have seen a training slide shows pluggable was put in read only before unplugging.
BDE
B D and E
B.
The PDB must be dosed.
D.
The unplugged PDB can be plugged into the same multitenant container database (CDB)
E.
The unplugged PDB can be plugged into another CDB.
ADE
BDE
BDE
If B. The PDB must be closed
B – OK
The PDB must be closed before it can be unplugged.
D – OK if first drop unpluged PDB
The only operation supported on an unplugged PDB is dropping the PDB. The PDB must be dropped from the CDB before it can be plugged back into the same CDB.
E – OK
You unplug a PDB when you want to move the PDB to a different CDB or when you no longer want the PDB to be available.
BDE
BDE
Yes. B, D, E are correct.
BDE
BDE
BDE
A,D,E
to clone an existing pdb in same CDB or another CDB.
first QUIESE it ( bring in read only mode).
SQL> create pluggable database test_china admin user china identified by china;
Pluggable database created.
SQL> select name,open_mode,open_time from v$pdbs;
NAME OPEN_MODE OPEN_TIME
—————————— ———- —————————————-
PDB$SEED READ ONLY 26-JAN-16 09.45.29.238 AM +08:00
TESTPDB1 MOUNTED
TEST_CHINA READ WRITE 26-JAN-16 10.29.45.104 AM +08:00
SQL> alter pluggable database all open;
Pluggable database altered.
SQL> alter pluggable database test_china unplug into ‘/home/oracle/unp.xml’;
alter pluggable database test_china unplug into ‘/home/oracle/unp.xml’
*
ERROR at line 1:
ORA-65025: Pluggable database TEST_CHINA is not closed on all instances.
SQL> alter pluggable database test_china close immediate;
Pluggable database altered.
SQL> alter pluggable database test_china unplug into ‘/home/oracle/test_china.xml’;
Pluggable database altered.
B， D， E is correct.
BDE