Which data files will be backed up?

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect
to the CDB RMAN. Examine the following command and its output: You execute the
following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files
will be backed up?

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect
to the CDB RMAN. Examine the following command and its output: You execute the
following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files
will be backed up?

A.
Data files that belong to only the root container

B.
Data files that belong to the root container and all the pluggable databases (PDBs)

C.
Data files that belong to only the root container and PDB$SEED

D.
Data files that belong to the root container and all the PDBs excluding PDB$SEED

Show Hint

Leave a Reply 2

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

Patty

Patty

B is the one.

Reply

Dilli Raj Maharjan

Dilli Raj Maharjan

Verified: B is the Correct Answer.

[oracle@ora12c cdb2]$ rman target /

Recovery Manager: Release 12.1.0.1.0 – Production on Thu Mar 24 21:05:07 2016

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

connected to target database: CDB2 (DBID=651124905)

RMAN> backup database plus archivelog;

Starting backup at 24-MAR-16
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=245 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=224 RECID=52 STAMP=907362109
input archived log thread=1 sequence=225 RECID=53 STAMP=907362173
input archived log thread=1 sequence=226 RECID=54 STAMP=907362215
input archived log thread=1 sequence=227 RECID=55 STAMP=907362326
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/backupset/2016_03_24/o1_mf_annnn_TAG20160324T210526_ch81ftsp_.bkp tag=TAG20160324T210526 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-MAR-16

Starting backup at 24-MAR-16
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=00004 name=/u01/app/oracle/oradata/cdb2/undotbs01.dbf
input datafile file number=00034 name=/u02/app/oracle/oradata/cdb2/users02.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/cdb2/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/cdb2/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/backupset/2016_03_24/o1_mf_nnndf_TAG20160324T210527_ch81fw2h_.bkp tag=TAG20160324T210527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/cdb2/pdb2_1/sysaux01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/cdb2/pdb2_1/system01.dbf
input datafile file number=00029 name=/u01/app/oracle/oradata/cdb2/pdb2_1/ldata_01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/2BFA04FE8181102DE0536801A8C0E555/backupset/2016_03_24/o1_mf_nnndf_TAG20160324T210527_ch81gz59_.bkp tag=TAG20160324T210527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00040 name=/home/oracle/cdb2/pdb2_2/sysaux01.dbf
input datafile file number=00039 name=/home/oracle/cdb2/pdb2_2/system01.dbf
input datafile file number=00045 name=/home/oracle/cdb2/pdb2_2/userdata.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/2ECD10871F0C4B90E0530E01A8C08953/backupset/2016_03_24/o1_mf_nnndf_TAG20160324T210527_ch81hg97_.bkp tag=TAG20160324T210527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/cdb2/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/cdb2/pdbseed/system01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/2BF980DC759D0B18E0536801A8C0B695/backupset/2016_03_24/o1_mf_nnndf_TAG20160324T210527_ch81hod0_.bkp tag=TAG20160324T210527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00042 name=/home/oracle/cdb2/pdb2_3/sysaux01.dbf
input datafile file number=00041 name=/home/oracle/cdb2/pdb2_3/system01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/2ECD10871F0D4B90E0530E01A8C08953/backupset/2016_03_24/o1_mf_nnndf_TAG20160324T210527_ch81hwhz_.bkp tag=TAG20160324T210527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00028 name=/u01/app/oracle/oradata/cdb2/cdata_01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/cdb2/users01.dbf
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/backupset/2016_03_24/o1_mf_nnndf_TAG20160324T210527_ch81j3lp_.bkp tag=TAG20160324T210527 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-MAR-16

Starting backup at 24-MAR-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=228 RECID=56 STAMP=907362400
channel ORA_DISK_1: starting piece 1 at 24-MAR-16
channel ORA_DISK_1: finished piece 1 at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/backupset/2016_03_24/o1_mf_annnn_TAG20160324T210640_ch81j4s1_.bkp tag=TAG20160324T210640 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-MAR-16

Starting Control File and SPFILE Autobackup at 24-MAR-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB2/autobackup/2016_03_24/o1_mf_s_907362401_ch81j68w_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 24-MAR-16

RMAN>

Reply