Oracle Database 12c: Advanced Administration — Question 26

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2, both of which are open. RMAN is connected to the target pluggable database pdb2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

Answer options

• A. All data files belonging to pdb2_1 are backed up and all archive log files are deleted.
• B. All data files belonging to pdb2_1 are backed up along with the archive log files.
• C. Only the data files belonging to pdb2_ are backed up.
• D. This command gives an error because archive log files can be backed up only when RMAN is connected to the root database.

Correct answer: B

Explanation

The correct answer is B because the command 'BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT' backs up both the data files of pdb2_1 and the archive logs, while also deleting the archive logs after they are backed up. Option A is incorrect as it states that only archive logs are deleted without mentioning the backup of the data files, and option C is incorrect since it doesn't account for the backup of archive logs. Option D is wrong because RMAN can back up archive logs while connected to a PDB in archivelog mode.