Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and
PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?
A.
BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
B.
BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
C.
BACKUP DATABASE while connected to the PDB1 container
D.
BACKUP DATABASE while connected to the boot container
E.
BACKUP PLUGGABLE database PDB1 while connected to PDB2
Explanation:
To perform operations on a single PDB, you can connect as target either to the root
or directly to the PDB.
* (A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN
commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE
command.
* (C)If instead you connect directly to a PDB, you can use the same commands that you would
use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP
DATABASE command.
Reference: Oracle Database Backup and Recovery User’s Guide 12c, About Backup and
Recovery of CDBs
A and C are correct.
we cannot give the pluggable qualifier when connected to the pluggable database.
so both B and E are wrong..
RMAN> BACKUP PLUGGABLE DATABASE ora12p1 format ‘/appl/rbackup/ora12p2_%U’;
Starting backup at 30-MAR-14
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/30/2014 23:23:49
RMAN-07538: Pluggable Database qualifier not allowed when connected to a Pluggable Database
Answer D is wrong since it will backup all the pdbs and root container but our question is to backup only pdbs.
A – OK
B – FALSE – in PDB we dont write “BACKUP PLUGGABLE DATABASE ”
C – OK – in PDB we execute command in RMAN like no-PDB
D – FALSE – no boot container
E – FALSE – we cant backup PDB1 from PDB2 !
correct answer AC
AC are correct, but 3 answers are required for this question. I makred also B.
AC and – D, D is ok assuming BACKUP DATABASE XXX, and a typo in answer boot=root.
AC
AC
B and E are wrong for sure. Tested.
A and C are correct for sure. Tested.
D as the third option may be correct too as Ever says. Tested.
A and C.
D wrong : The command will backup CDB and all PDBs and the question is looking for the command to back up only the PDB1 pluggable database.