Which statement is true about the execution of this command?

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains
two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target
database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains
two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target
database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

A.
It fails because archive log files cannot be backed up using a connection to a PDB.

B.
It succeeds but only the data files belonging to the pdb2_i pluggable database are backed
up.

C.
It succeeds and all data files belonging to PD32_i are backed up along with the archive log
files.

D.
It fails because the pluggable clause is missing.

Show Hint

Leave a Reply 7

Your email address will not be published. Required fields are marked *

puntano

puntano

C. it is fine:

[oracle@sumatra ~]$ rman target sys/oracle1@localhost:1521/pdbmax.oracle.com

Recovery Manager: Release 12.1.0.2.0 – Production on Sat Aug 29 16:05:22 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1404492468)

RMAN> backup database plus archivelog;

Starting backup at 29-AUG-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=48 device type=DISK
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 29-AUG-15

Starting backup at 29-AUG-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/opt/oracle/oradata/orcl/pdbmax/sysaux01.dbf
input datafile file number=00014 name=/opt/oracle/oradata/orcl/pdbmax/system01.dbf
channel ORA_DISK_1: starting piece 1 at 29-AUG-15

Reply

vijay

vijay

@Puntano,
your above example supports option B.
As it is a PDB, there are no archive logs to backup. Hence, option C is wrong and B is right.

Reply