{"id":12803,"date":"2019-09-13T17:13:10","date_gmt":"2019-09-13T15:13:10","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/"},"modified":"2023-06-15T16:42:33","modified_gmt":"2023-06-15T14:42:33","slug":"rman-in-a-multitenant-environment","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/","title":{"rendered":"RMAN in a Multitenant Environment"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs)
\nIn this document we are trying to explain how to use RMAN backup and recovery in a multitenant environment for an oracle 19c database with 2 pluggable databases.
\nBelow the configuration we are using.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
SQL> show pdbs<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE <\/code>NO<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We will not use a recovery catalog, but the use of recovery is the same than in a non-CDB environment.
\nNote that starting with Oracle 19c, we can now connect to a recovery catalog when the target database is a PDB.<\/p>\n

Whole CDB Backups<\/h3>\n

Backin up a whole CDB is like backing up non-CDB database. We have to backup
\n-root pdb
\n-all pluggable databases
\n-archived logs
\nThe steps are:
\n1- Connect to the root container with a common user having SYSBACKUP or SYSDBA privileges<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>connect<\/code> target \/<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL (DBID=1546409981)<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Launch the backup<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
RMAN> BACKUP <\/code>DATABASE<\/code> PLUS ARCHIVELOG;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
current<\/code> log archived<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=279 device type=DISK<\/code><\/div>\n
channel ORA_DISK_1: starting archived log backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: specifying archived log(s) <\/code>in<\/code> backup <\/code>set<\/code><\/div>\n
input archived log thread=1 <\/code>sequence<\/code>=6 RECID=1 STAMP=1018632767<\/code><\/div>\n
input archived log thread=1 <\/code>sequence<\/code>=7 RECID=2 STAMP=1018690452<\/code><\/div>\n
input archived log thread=1 <\/code>sequence<\/code>=8 RECID=3 STAMP=1018691169<\/code><\/div>\n
input archived log thread=1 <\/code>sequence<\/code>=9 RECID=4 STAMP=1018693343<\/code><\/div>\n
channel ORA_DISK_1: starting piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
channel ORA_DISK_1: finished piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset\/2019_09_11\/o1_mf_annnn<\/code><\/div>\n
...<\/code><\/div>\n
...<\/code><\/div>\n
Finished backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
Starting Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/autobackup\/2019_09_11\/o1_mf_s_1018693411_gqkcr46z_.bkp comment=NONE<\/code><\/div>\n
Finished Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Oracle also recommends to backup sometimes the root container.
\nOnce connected to the root container with a common user, run the backup command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
RMAN> BACKUP <\/code>DATABASE<\/code> ROOT;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: starting <\/code>full<\/code> datafile backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>in<\/code> backup <\/code>set<\/code><\/div>\n
input datafile file number=00001 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/system01.dbf<\/code><\/div>\n
input datafile file number=00003 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/sysaux01.dbf<\/code><\/div>\n
input datafile file number=00004 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/undotbs01.dbf<\/code><\/div>\n
input datafile file number=00007 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: starting piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
channel ORA_DISK_1: finished piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T103019_gqkd4vxb_.bkp tag=TAG20190911T103019 comment=NONE<\/code><\/div>\n
channel ORA_DISK_1: backup <\/code>set<\/code> complete, elapsed <\/code>time<\/code>: 00:00:16<\/code><\/div>\n
Finished backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
Starting Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/autobackup\/2019_09_11\/o1_mf_s_1018693836_gqkd5d65_.bkp comment=NONE<\/code><\/div>\n
Finished Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

PDBSs Backups<\/h3>\n

Backing up PDBs is not difficult, there are just some mechanisms to know. When connecting with RMAN to the root container, we can back up one or more PDBs while directly connecting to a PDB, we can only back up this PDB.
\n1- Connect to the root container with a common user having SYSBACKUP or SYSDBA privileges<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>connect<\/code> target \/<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL (DBID=1546409981)<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And backup individual PDBs<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
RMAN> BACKUP PLUGGABLE <\/code>DATABASE<\/code> PDB1,PDB2;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: starting <\/code>full<\/code> datafile backup <\/code>set<\/code><\/div>\n
...<\/code><\/div>\n
...<\/code><\/div>\n
Starting Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/autobackup\/2019_09_11\/o1_mf_s_1018695111_gqkff85l_.bkp comment=NONE<\/code><\/div>\n
Finished Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Connecting to the PDBs with a local user having SYSBACKUP or SYSDBA privileges
\nPDB1<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>connect<\/code> target sys\/root@pdb1<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL:PDB1 (DBID=4178439423)<\/code><\/div>\n
<\/div>\n
RMAN> BACKUP <\/code>DATABASE<\/code>;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=279 device type=DISK<\/code><\/div>\n
channel ORA_DISK_1: starting <\/code>full<\/code> datafile backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>in<\/code> backup <\/code>set<\/code><\/div>\n
input datafile file number=00010 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/sysaux01.dbf<\/code><\/div>\n
input datafile file number=00009 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/system01.dbf<\/code><\/div>\n
input datafile file number=00011 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/undotbs01.dbf<\/code><\/div>\n
input datafile file number=00012 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: starting piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
channel ORA_DISK_1: finished piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359B0BEC8B4545E0531502A8C0F64E\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T110707_gqkg9w5n_.bkp tag=TAG20190911T110707 comment=NONE<\/code><\/div>\n
channel ORA_DISK_1: backup <\/code>set<\/code> complete, elapsed <\/code>time<\/code>: 00:00:07<\/code><\/div>\n
Finished backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

PDB2<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>connect<\/code> target sys\/root@pdb2<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL:PDB2 (DBID=3996013191)<\/code><\/div>\n
<\/div>\n
RMAN>\u00a0 BACKUP <\/code>DATABASE<\/code>;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=279 device type=DISK<\/code><\/div>\n
channel ORA_DISK_1: starting <\/code>full<\/code> datafile backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>in<\/code> backup <\/code>set<\/code><\/div>\n
input datafile file number=00014 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/sysaux01.dbf<\/code><\/div>\n
input datafile file number=00013 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/system01.dbf<\/code><\/div>\n
input datafile file number=00015 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/undotbs01.dbf<\/code><\/div>\n
input datafile file number=00016 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: starting piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
channel ORA_DISK_1: finished piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T110844_gqkgdwmm_.bkp tag=TAG20190911T110844 comment=NONE<\/code><\/div>\n
channel ORA_DISK_1: backup <\/code>set<\/code> complete, elapsed <\/code>time<\/code>: 00:00:07<\/code><\/div>\n
Finished backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Tablespace Backup in a PDB<\/h3>\n

Tablespaces in different PDBs can have the same name. So to eliminate ambiguity always connect to the PDB you want to back up tablespaces.
\n1- Connect to the PDB with a local user having SYSBACKUP or SYSDBA privilege<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver ~]$ rman target sys\/root@pdb1<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Wed Sep 11 11:35:53 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL:PDB1 (DBID=4178439423)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Issue the BACKUP TABLESPACE command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
RMAN> BACKUP TABLESPACE USERS;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=290 device type=DISK<\/code><\/div>\n
channel ORA_DISK_1: starting <\/code>full<\/code> datafile backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>in<\/code> backup <\/code>set<\/code><\/div>\n
input datafile file number=00012 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: starting piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
channel ORA_DISK_1: finished piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359B0BEC8B4545E0531502A8C0F64E\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T113623_gqkj0qxl_.bkp tag=TAG20190911T113623 comment=NONE<\/code><\/div>\n
channel ORA_DISK_1: backup <\/code>set<\/code> complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
Finished backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Data File Backup in a PDB<\/h3>\n

Data Files are identified by a unique number across the CDB. So for the Backup we can connect either to the root container or directly to the PDB.
\nNote that while directly connecting to the PDB, we can only backup files belonging to this PDB.<\/p>\n

1- Connect to the root container with a common user having SYSBACKUP or SYSDBA privileges<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver admin]$ rman target \/<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Wed Sep 11 11:54:42 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL (DBID=1546409981)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Backup the Data File<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
RMAN> BACKUP DATAFILE 10;<\/code><\/div>\n
<\/div>\n
Starting backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=274 device type=DISK<\/code><\/div>\n
channel ORA_DISK_1: starting <\/code>full<\/code> datafile backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>in<\/code> backup <\/code>set<\/code><\/div>\n
input datafile file number=00010 <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/sysaux01.dbf<\/code><\/div>\n
channel ORA_DISK_1: starting piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
channel ORA_DISK_1: finished piece 1 <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359B0BEC8B4545E0531502A8C0F64E\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T115504_gqkk3s44_.bkp tag=TAG20190911T115504 comment=NONE<\/code><\/div>\n
channel ORA_DISK_1: backup <\/code>set<\/code> complete, elapsed <\/code>time<\/code>: 00:00:03<\/code><\/div>\n
Finished backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
Starting Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/autobackup\/2019_09_11\/o1_mf_s_1018698908_gqkk3wwt_.bkp comment=NONE<\/code><\/div>\n
Finished Control File <\/code>and<\/code> SPFILE Autobackup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Whole CDB Complete Recovery<\/h3>\n

Suppose we lose all Data Files, Control Files and Redo Log Files of the whole container. We can restore with the following steps
\n1- Restore Control Files while connecting to the root container<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver ORCL]$ rman target \/<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Wed Sep 11 14:25:25 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code> (<\/code>not<\/code> started)<\/code><\/div>\n
<\/div>\n
RMAN> startup nomount<\/code><\/div>\n
<\/div>\n
Oracle instance started<\/code><\/div>\n
<\/div>\n
Total System <\/code>Global<\/code> Area\u00a0\u00a0\u00a0\u00a0 872413680 bytes<\/code><\/div>\n
<\/div>\n
Fixed <\/code>Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9140720 bytes<\/code><\/div>\n
Variable <\/code>Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 297795584 bytes<\/code><\/div>\n
Database<\/code> Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 557842432 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7634944 bytes<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n
<\/div>\n
RMAN> restore controlfile <\/code>FROM<\/code> AUTOBACKUP;<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=21 device type=DISK<\/code><\/div>\n
<\/div>\n
recovery area destination: \/u01\/app\/oracle\/fast_recovery_area<\/code><\/div>\n
database<\/code> name<\/code> (<\/code>or<\/code> database<\/code> unique<\/code> name<\/code>) used <\/code>for<\/code> search: ORCL<\/code><\/div>\n
channel ORA_DISK_1: AUTOBACKUP \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/autobackup\/2019_09_11\/o1_mf_s_1018698908_gqkk3wwt_.bkp found <\/code>in<\/code> the recovery area<\/code><\/div>\n
AUTOBACKUP search <\/code>with<\/code> format <\/code>\"%F\"<\/code> not<\/code> attempted because DBID was <\/code>not<\/code> set<\/code><\/div>\n
channel ORA_DISK_1: restoring control file <\/code>from<\/code> AUTOBACKUP \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/autobackup\/2019_09_11\/o1_mf_s_1018698908_gqkk3wwt_.bkp<\/code><\/div>\n
channel ORA_DISK_1: control file restore <\/code>from<\/code> AUTOBACKUP complete<\/code><\/div>\n
output<\/code> file <\/code>name<\/code>=\/u01\/app\/oracle\/oradata\/ORCL\/control01.ctl<\/code><\/div>\n
output<\/code> file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/control02.ctl<\/code><\/div>\n
Finished restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Mount the CDB<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>alter<\/code> database<\/code> mount;<\/code><\/div>\n
<\/div>\n
released channel: ORA_DISK_1<\/code><\/div>\n
Statement processed<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3- List Backup of archived logs<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n<\/td>\n
\n
\n
RMAN> list backup <\/code>of<\/code> archivelog <\/code>all<\/code>;<\/code><\/div>\n
<\/div>\n
<\/div>\n
List <\/code>of<\/code> Backup Sets<\/code><\/div>\n
===================<\/code><\/div>\n
<\/div>\n
<\/div>\n
BS <\/code>Key<\/code>\u00a0 Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Device Type Elapsed <\/code>Time<\/code> Completion <\/code>Time<\/code><\/div>\n
------- ---------- ----------- ------------ ---------------<\/code><\/div>\n
2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 397.52M\u00a0\u00a0\u00a0 DISK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:04\u00a0\u00a0\u00a0\u00a0 11-SEP-19<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>BP <\/code>Key<\/code>: 2\u00a0\u00a0 Status: AVAILABLE\u00a0 Compressed: <\/code>NO<\/code>\u00a0 Tag: TAG20190911T102225<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Piece <\/code>Name<\/code>: \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset\/2019_09_11\/o1_mf_annnn_TAG20190911T102225_gqkcp1k9_.bkp<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>List <\/code>of<\/code> Archived Logs <\/code>in<\/code> backup <\/code>set<\/code> 2<\/code><\/div>\n
\u00a0\u00a0<\/code>Thrd Seq\u00a0\u00a0\u00a0\u00a0 Low SCN\u00a0\u00a0\u00a0 Low <\/code>Time<\/code>\u00a0 Next<\/code> SCN\u00a0\u00a0 <\/code>Next<\/code> Time<\/code><\/div>\n
\u00a0\u00a0<\/code>---- ------- ---------- --------- ---------- ---------<\/code><\/div>\n
\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2120330\u00a0\u00a0\u00a0 10-SEP-19 2155559\u00a0\u00a0\u00a0 10-SEP-19<\/code><\/div>\n
\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2155559\u00a0\u00a0\u00a0 10-SEP-19 2257139\u00a0\u00a0\u00a0 11-SEP-19<\/code><\/div>\n
\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2257139\u00a0\u00a0\u00a0 11-SEP-19 2327294\u00a0\u00a0\u00a0 11-SEP-19<\/code><\/div>\n
\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0 9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2327294\u00a0\u00a0\u00a0 11-SEP-19 2342937\u00a0\u00a0\u00a0 11-SEP-19<\/code><\/div>\n
<\/div>\n
BS <\/code>Key<\/code>\u00a0 Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Device Type Elapsed <\/code>Time<\/code> Completion <\/code>Time<\/code><\/div>\n
------- ---------- ----------- ------------ ---------------<\/code><\/div>\n
7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.00K\u00a0\u00a0\u00a0\u00a0\u00a0 DISK\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00\u00a0\u00a0\u00a0\u00a0 11-SEP-19<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>BP <\/code>Key<\/code>: 7\u00a0\u00a0 Status: AVAILABLE\u00a0 Compressed: <\/code>NO<\/code>\u00a0 Tag: TAG20190911T102330<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Piece <\/code>Name<\/code>: \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/backupset\/2019_09_11\/o1_mf_annnn_TAG20190911T102330_gqkcr2n1_.bkp<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>List <\/code>of<\/code> Archived Logs <\/code>in<\/code> backup <\/code>set<\/code> 7<\/code><\/div>\n
\u00a0\u00a0<\/code>Thrd Seq\u00a0\u00a0\u00a0\u00a0 Low SCN\u00a0\u00a0\u00a0 Low <\/code>Time<\/code>\u00a0 Next<\/code> SCN\u00a0\u00a0 <\/code>Next<\/code> Time<\/code><\/div>\n
\u00a0\u00a0<\/code>---- ------- ---------- --------- ---------- ---------<\/code><\/div>\n
\u00a0\u00a0<\/code>1\u00a0\u00a0\u00a0 10\u00a0\u00a0\u00a0\u00a0\u00a0 2342937\u00a0\u00a0\u00a0 11-SEP-19 2342996\u00a0\u00a0\u00a0 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Restore the database according to the sequence<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
RMAN> restore <\/code>database<\/code> until <\/code>sequence<\/code> 11;<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
Starting implicit crosscheck backup <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=24 device type=DISK<\/code><\/div>\n
Crosschecked 18 objects<\/code><\/div>\n
...<\/code><\/div>\n
...<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:07<\/code><\/div>\n
Finished restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

5- Recover the database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
RMAN> recover <\/code>database<\/code> until <\/code>sequence<\/code> 11;<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
<\/div>\n
archived log <\/code>for<\/code> thread 1 <\/code>with<\/code> sequence<\/code> 10 <\/code>is<\/code> already <\/code>on<\/code> disk <\/code>as<\/code> file \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/archivelog\/2019_09_11\/o1_mf_1_10_gqkcr27d_.arc<\/code><\/div>\n
archived log file <\/code>name<\/code>=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/archivelog\/2019_09_11\/o1_mf_1_10_gqkcr27d_.arc thread=1 <\/code>sequence<\/code>=10<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:00<\/code><\/div>\n
Finished recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

6- Open database in Resetlogs mode<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>alter<\/code> database<\/code> open<\/code> resetlogs;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

PDBs Complete Recovery<\/h3>\n

To recover a PDB we can :
\n– Connect to the root and then use the RESTORE PLUGGABLE DATABASE and RECOVER PLUGGABLE DATABASE commands.
\n1- Close the PDB to recover<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>alter<\/code> pluggable <\/code>database<\/code> pdb1 <\/code>close<\/code>;<\/code><\/div>\n
<\/div>\n
Pluggable <\/code>database<\/code> altered.<\/code><\/div>\n
<\/div>\n
SQL> show pdbs;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE <\/code>NO<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Connect to rman on the root container and issue the restore command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n<\/td>\n
\n
\n
RMAN> RESTORE PLUGGABLE <\/code>DATABASE<\/code>\u00a0 PDB1;<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=56 device type=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>to<\/code> restore <\/code>from<\/code> backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00009 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/system01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00010 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/sysaux01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00011 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/undotbs01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00012 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb1\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: reading <\/code>from<\/code> backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359B0BEC8B4545E0531502A8C0F64E\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T144816_gqkv9btm_.bkp<\/code><\/div>\n
channel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359B0BEC8B4545E0531502A8C0F64E\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T144816_gqkv9btm_.bkp tag=TAG20190911T144816<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:07<\/code><\/div>\n
Finished restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3- Recover the pluggable database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
RMAN> RECOVER PLUGGABLE <\/code>DATABASE<\/code>\u00a0 PDB1;<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
<\/div>\n
Finished recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Open the pluggable database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>alter<\/code> pluggable <\/code>database<\/code> PDB1 <\/code>open<\/code>;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

– Connect to the PDB and use the RESTORE DATABASE and RECOVER DATABASE commands.
\n1- Close the PDB to recover<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
SQL> show pdbs;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> ONLY<\/code>\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>READ<\/code> WRITE <\/code>NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Connect to the PDB and issue the RESTORE DATABASE command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver pdb1]$ rman target sys\/root@pdb2<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Wed Sep 11 15:19:03 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL:PDB2 (DBID=3996013191, <\/code>not<\/code> open<\/code>)<\/code><\/div>\n
<\/div>\n
RMAN> RESTORE <\/code>DATABASE<\/code>;<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=45 device type=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>to<\/code> restore <\/code>from<\/code> backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00013 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/system01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00014 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/sysaux01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00015 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/undotbs01.dbf<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00016 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/users01.dbf<\/code><\/div>\n
channel ORA_DISK_1: reading <\/code>from<\/code> backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T144816_gqkv9tfq_.bkp<\/code><\/div>\n
channel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T144816_gqkv9tfq_.bkp tag=TAG20190911T144816<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:07<\/code><\/div>\n
Finished restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3- Recover the pluggable database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
RMAN> recover <\/code>database<\/code>;<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
<\/div>\n
Finished recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Open the database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>alter<\/code> database<\/code> open<\/code> ;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Complete Tablespace Recovery in a PDB<\/h3>\n

-Non-SYSTEM Tablespace<\/p>\n

To recover a Non-SYSTEM Tablespace in a PDB we can do next steps
\n1-Put the tablespace offline while connecting to the PDB<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>ALTER<\/code> TABLESPACE MYTAB OFFLINE;<\/code><\/div>\n
<\/div>\n
Tablespace altered.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Connect to the PDB with RMAN and issue the RESTORE TABLESPACE command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver pdb2]$ rman target sys\/root@pdb2<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 19.0.0.0.0 - Production <\/code>on<\/code> Wed Sep 11 16:52:37 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle <\/code>and<\/code>\/<\/code>or<\/code> its affiliates.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
connected <\/code>to<\/code> target <\/code>database<\/code>: ORCL:PDB2 (DBID=3996013191)<\/code><\/div>\n
<\/div>\n
RMAN> RESTORE TABLESPACE MYTAB;<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using target <\/code>database<\/code> control file <\/code>instead<\/code> of<\/code> recovery catalog<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=274 device type=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>to<\/code> restore <\/code>from<\/code> backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00017 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/mytab01.dbf<\/code><\/div>\n
channel ORA_DISK_1: reading <\/code>from<\/code> backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T163708_gql1o4gx_.bkp<\/code><\/div>\n
channel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T163708_gql1o4gx_.bkp tag=TAG20190911T163708<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
Finished restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3- Issue the RECOVER TABLESPACE command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
RMAN> RECOVER TABLESPACE MYTAB;<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
<\/div>\n
Finished recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Put back the tablespace ONLINE<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>ALTER<\/code> TABLESPACE MYTAB ONLINE;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-SYSTEM Tablespace<\/p>\n

To recover a SYSTEM Tablespace in a PDB<\/p>\n

1- Shutdown the entire CDB and Mount it<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n<\/td>\n
\n
\n
[oracle@oraadserver pdb2]$ sqlplus \/ <\/code>as<\/code> sysdba<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 19.0.0.0.0 - Production <\/code>on<\/code> Wed Sep 11 17:09:33 2019<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2019, Oracle.\u00a0 <\/code>All<\/code> rights reserved.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Connected <\/code>to<\/code>:<\/code><\/div>\n
Oracle <\/code>Database<\/code> 19c Enterprise Edition Release 19.0.0.0.0 - Production<\/code><\/div>\n
Version 19.3.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> shut immediate<\/code><\/div>\n
ORA-01116: error <\/code>in<\/code> opening <\/code>database<\/code> file 13<\/code><\/div>\n
ORA-01110: data file 13: <\/code>'\/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/system01.dbf'<\/code><\/div>\n
ORA-27041: unable <\/code>to<\/code> open<\/code> file<\/code><\/div>\n
Linux-x86_64 Error: 2: <\/code>No<\/code> such file <\/code>or<\/code> directory<\/code><\/div>\n
Additional information: 3<\/code><\/div>\n
SQL> shut abort;<\/code><\/div>\n
ORACLE instance shut down.<\/code><\/div>\n
SQL><\/code><\/div>\n
<\/div>\n
SQL> startup mount<\/code><\/div>\n
ORACLE instance started.<\/code><\/div>\n
<\/div>\n
Total System <\/code>Global<\/code> Area\u00a0 872413680 bytes<\/code><\/div>\n
Fixed <\/code>Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9140720 bytes<\/code><\/div>\n
Variable <\/code>Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 310378496 bytes<\/code><\/div>\n
Database<\/code> Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 545259520 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7634944 bytes<\/code><\/div>\n
Database<\/code> mounted.<\/code><\/div>\n
SQL> show pdbs<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>OPEN<\/code> MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

2- Connect to root container and restore the corresponding files (Files can be identified using command REPORT SCHEMA for example)<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
RMAN> RESTORE DATAFILE 13;<\/code><\/div>\n
<\/div>\n
Starting restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=26 device type=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: specifying datafile(s) <\/code>to<\/code> restore <\/code>from<\/code> backup <\/code>set<\/code><\/div>\n
channel ORA_DISK_1: restoring datafile 00013 <\/code>to<\/code> \/u01\/app\/oracle\/oradata\/ORCL\/pdb2\/system01.dbf<\/code><\/div>\n
channel ORA_DISK_1: reading <\/code>from<\/code> backup piece \/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T163708_gql1o4gx_.bkp<\/code><\/div>\n
channel ORA_DISK_1: piece handle=\/u01\/app\/oracle\/fast_recovery_area\/ORCL\/92359E387C754644E0531502A8C02C00\/backupset\/2019_09_11\/o1_mf_nnndf_TAG20190911T163708_gql1o4gx_.bkp tag=TAG20190911T163708<\/code><\/div>\n
channel ORA_DISK_1: restored backup piece 1<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:03<\/code><\/div>\n
Finished restore <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

3- Recover the Data File<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
RMAN> RECOVER DATAFILE 13;<\/code><\/div>\n
<\/div>\n
Starting recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:00<\/code><\/div>\n
<\/div>\n
Finished recover <\/code>at<\/code> 11-SEP-19<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

4- Open all containers<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
RMAN> <\/code>alter<\/code> database<\/code> open<\/code>;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN> <\/code>ALTER<\/code> PLUGGABLE <\/code>DATABASE<\/code> ALL<\/code> OPEN<\/code> READ<\/code> WRITE;<\/code><\/div>\n
<\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

In this blog we basically explain how to use RMAN in a multitenant environment. We did not talked about PITR recovery, we will do it in a coming blog.
\nNote also that we did not use RMAN commands like LIST FAILURE, ADVISE FAILURE and REPAIR FAILURE. But these commands also work.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[202,64,1171,226,270],"type_dbi":[],"class_list":["post-12803","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-backup","tag-multitenant","tag-oracle-19c","tag-recovery","tag-rman"],"acf":[],"yoast_head":"\nRMAN in a Multitenant Environment - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"RMAN in a Multitenant Environment\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-13T15:13:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:42:33+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"RMAN in a Multitenant Environment\",\"datePublished\":\"2019-09-13T15:13:10+00:00\",\"dateModified\":\"2023-06-15T14:42:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\"},\"wordCount\":701,\"commentCount\":2,\"keywords\":[\"Backup\",\"multitenant\",\"Oracle 19c\",\"Recovery\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\",\"name\":\"RMAN in a Multitenant Environment - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2019-09-13T15:13:10+00:00\",\"dateModified\":\"2023-06-15T14:42:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"RMAN in a Multitenant Environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"RMAN in a Multitenant Environment - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/","og_locale":"en_US","og_type":"article","og_title":"RMAN in a Multitenant Environment","og_description":"By Mouhamadou Diaw The Oracle Multitenant architecture came with Oracle 12c a few years ago. For people usually working with traditional Non-CDB database it might be confusing the first time to do Backup and Recovery with pluggable databases (PDBs) In this document we are trying to explain how to use RMAN backup and recovery in […]","og_url":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/","og_site_name":"dbi Blog","article_published_time":"2019-09-13T15:13:10+00:00","article_modified_time":"2023-06-15T14:42:33+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"RMAN in a Multitenant Environment","datePublished":"2019-09-13T15:13:10+00:00","dateModified":"2023-06-15T14:42:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/"},"wordCount":701,"commentCount":2,"keywords":["Backup","multitenant","Oracle 19c","Recovery","RMAN"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/","url":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/","name":"RMAN in a Multitenant Environment - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2019-09-13T15:13:10+00:00","dateModified":"2023-06-15T14:42:33+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/rman-in-a-multitenant-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"RMAN in a Multitenant Environment"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=12803"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12803\/revisions"}],"predecessor-version":[{"id":25962,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12803\/revisions\/25962"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12803"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}