Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default
permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you
connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
A.
Place the root container in ARHCHIVELOG mode.
B.
Take the user data tablespace offline.
C.
Place the root container in the nomount stage.
D.
Ensure that HR_PDB is open.
Explanation:
To back up tablespaces or data files:
Start RMAN and connect to a target database and a recovery catalog (if used).
If the database instance is not started, then either mount or open the database.
Run the BACKUP TABLESPACE command or BACKUP DATAFILE command at the RMAN
prompt.
Dull question!
No words about that we are in archivelog mode already.
Pluggable Database cannot be backed up in NOARCHIVELOG mode.
So me for A!
Yes, A is right.
When connect to CDB using RMAN. You can backup pdb even pdb in mount stat.
Answer is : A
SQL> select con_id , name, open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
———- —————————— ———-
2 PDB$SEED READ ONLY
3 CDB1PDB1 MOUNTED
4 CDB1PDB2 MOUNTED
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@nonrac12c-oel6u5 Desktop]$ rman target /
Recovery Manager: Release 12.1.0.1.0 – Production on Sun Mar 15 22:52:12 2015
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=826297813)
RMAN> backup tablespace cdb1pdb1:users;
Starting backup at 15-MAR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=367 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/oradata/CDB1/CDB1PDB1/CDB1PDB1_users01.dbf
channel ORA_DISK_1: starting piece 1 at 15-MAR-15
channel ORA_DISK_1: finished piece 1 at 15-MAR-15
piece handle=/app/oracle/fast_recovery_area/CDB1/FDD8AC7366903EA7E0436502A8C0829A/backupset/2015_03_15/o1_mf_nnndf_TAG20150315T225225_bjchyl04_.bkp tag=TAG20150315T225225 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-MAR-15
Starting Control File and SPFILE Autobackup at 15-MAR-15
piece handle=/app/oracle/fast_recovery_area/CDB1/autobackup/2015_03_15/o1_mf_s_874450347_bjchym7v_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 15-MAR-15
RMAN> exit
Recovery Manager complete.
[oracle@nonrac12c-oel6u5 Desktop]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Mar 15 22:53:56 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut immediate
startup mount
alter dataDatabase closed.
Database dismounted.
base noarchORACLE instance shut down.
ivelogSQL> ;
ORACLE instance started.
Total System Global Area 3845812224 bytes
Fixed Size 2328288 bytes
Variable Size 847251744 bytes
Database Buffers 2990538752 bytes
Redo Buffers 5693440 bytes
Database mounted.
SQL>
Database altered.
SQL> alter database open;
Database altered.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@nonrac12c-oel6u5 Desktop]$ rman target /
Recovery Manager: Release 12.1.0.1.0 – Production on Sun Mar 15 22:54:34 2015
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=826297813)
RMAN> backup tablespace cdb1pdb1:users;
Starting backup at 15-MAR-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 03/15/2015 22:54:46
RMAN-06817: Pluggable Database CDB1PDB1 cannot be backed up in NOARCHIVELOG mode.
RMAN>
B for sure
A for sure
A