Which two statements are true about dropping a pluggable database (PDB)?
A.
A PDB must be in mount state or it must be unplugged.
B.
The data files associated with a PDB are automatically removed from disk.
C.
A dropped and unplugged PDB can be plugged back into the same multitenant container
database (CDB) or other CDBs.
D.
A PDB must be in closed state.
E.
The backups associated with a PDB are removed.
F.
A PDB must have been opened at least once after creation.
Explanation:
Reference:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13858
A and C
a is incorrect:
NAME OPEN_MODE RES
—————————— ———- —
OPEN_TIME
—————————————————————————
CREATE_SCN TOTAL_SIZE BLOCK_SIZE RECOVERY SNAPSHOT_PARENT_CON_ID
———- ———- ———- ——– ———————-
3 3811480127 3811480127 13761505684DE840E055020C294BDFFC
PDBORCL MOUNTED
1743900 0 8192 ENABLED 0
SQL> drop pluggable database pdborcl;
drop pluggable database pdborcl
*
ERROR at line 1:
ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged
Oracle:
The PDB must be in mounted mode, or it must be unplugged.
–> A
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.
To completely remove the PDB from the CDB, you can drop the PDB. The only operation supported on an unplugged PDB is dropping the PDB.
–> D
A is ok
and
F is correct, too
Prerequisites
Before unplugging and dropping a PDB, ensure that you meet the following prerequisites:
Oracle Software Library (Software Library) must be set up in Cloud Control.
For information on how to set up Software Library in Cloud Control, see Oracle Enterprise Manager Lifecycle Management Administrator’s Guide.
The PDB that you want to unplug and drop must have been opened at least once.
The target host user must be the owner of the Oracle Home that the CDB (containing the PDB that you want to unplug and drop) belongs to.
— http://docs.oracle.com/database/121/ADMIN/cdb_plug_em.htm#CHDCIIDJ
D and F
…
The following prerequisites must be met:
…
-> The PDB must have been opened at least once.
-> The PDB must be closed. In an Oracle Real Application Clusters (Oracle RAC) environment, the PDB must be closed on all instances.
Its A and F, I dont see a reason why it would be D
Tricky one…
I think it’s A and C but I have doubts…
F Appears to be true only to unplug a pdb not droping it…
So maybe it’s A and C ?
Read carefull
Unplugging a PDB
The following prerequisites must be met:
The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS SYSDBA or AS SYSOPER at connect time.
The PDB must have been opened at least once.
The PDB must be closed. In an Oracle Real Application Clusters (Oracle RAC) environment, the PDB must be closed on all instances.
Dropping a PDB
The DROP PLUGGABLE DATABASE statement drops a PDB. You can drop a PDB when you want to move the PDB from one CDB to another or when you no longer need the PDB. – C
When you drop a PDB, the control file of the CDB is modified to eliminate all references to the dropped PDB. Archived redo log files and backups associated with the PDB are not removed, but you can use Oracle Recovery Manager (RMAN) to remove them.
When dropping a PDB, you can either keep or delete the PDB’s data files by using one of the following clauses:
KEEP DATAFILES, the default, retains the data files.
The PDB’s temp file is removed even when KEEP DATAFILES is specified because the temp file is no longer needed.
INCLUDING DATAFILES removes the data files from disk.
If a PDB was created with the SNAPSHOT COPY clause, then you must specify INCLUDING DATAFILES when you drop the PDB.
The following prerequisites must be met:
The PDB must be in mounted mode, or it must be unplugged. – A
See “Modifying the Open Mode of PDBs”.
See “Unplugging a PDB from a CDB”.
The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS SYSDBA or AS SYSOPER at connect time.
A and C is the correct answer. If you really want to pass this exam, make sure you study study study.
A and C based on
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#BAJEFEHI
Thanks OCP_L!
F is just for unplugging only.
Unplugging a PDB
The following prerequisites must be met:
The PDB must have been opened at least once.
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13858
A, C
AC
AC link from OCP_L is very useful!
It’s very much A and C.
One can scan through below links for more information,
https://docs.oracle.com/database/121/SQLRF/statements_8028.htm#SQLRF55699
http://dbaharrison.blogspot.in/2013/08/oracle-12c-database-plggable-database.html
AC
https://docs.oracle.com/cd/E49329_01/server.121/b71278/statements_2007.htm#BGBICFGF
AC
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658
Dropping a PDB
The DROP PLUGGABLE DATABASE statement drops a PDB. You can drop a PDB when you want to move the PDB from one CDB to another or when you no longer need the PDB.
. . .
The following prerequisites must be met:
* The PDB must be in mounted mode, or it must be unplugged.
* The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS SYSDBA or AS SYSOPER at connect time.
A,C
A right
from docs: The PDB must be in mounted mode, or it must be unplugged
B wrong
KEEP DATAFILES, the default, retains the data files.
C right
The PDB must be dropped from the CDB before it can be plugged back into the same CDB
D incorrect
If A is correct then this must be false. Despite Greg’s answer – i haven’t found any evidence
for D in docs
E incorrect
Archived logs and backups associated with the dropped PDB are not deleted.
F incorrect
If Tri is right 🙂 – then this is needed only for unplugging database.
someone tested this?
Puntano – i think that A is right – you should use “INCLUDING DATAFILES” option
http://askdba.org/weblog/oracle12c/oracle-12c-multitenant-database/
C
ac