Which statement is true about the execution of this command to back up the database?

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 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?

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 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?

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.

Show Hint

Leave a Reply 5

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

yogui

yogui

D – In a CDB, archived redo logs can be backed up only when you connect to the root as a common user with the SYSDBA or SYSBACKUP privilege. When you connect to a PDB as a local user with SYSDBA or SYSBACKUP privilege, you cannot back up or delete archived redo logs.

Reply

Oracle

Oracle

can any one let me know ,how come it is D when you are connected to the local user to a PDB you can still backup the database but PDB ignores the archivelog backup command and backup of the database files of PDB and produces the below message –Agree ?

[oracle@rac1 ~]$ rman target sys@salespdb

Recovery Manager: Release 12.1.0.2.0 – Production on Wed Mar 16 02:27:05 2016

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

target database Password:
connected to target database: CDB12C (DBID=4104776697)

RMAN> BACKUP DATABASE PLUS
ARCHIVELOG DELETE INPUT;2>

Starting backup at 16-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=33 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=19 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=255 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 16-MAR-16

Reply

Oracle

Oracle

In this case the answer is C

Reply

srks

srks

C

archivelogs will be ignored when connected to pdb

Reply