RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB
Posted by Mir Sayeed Hassan on June 25th, 2019
RMAN Backup of Container Database (CDB) & Pluggable Database (PDB), Partial PDB
Connect to the CDB Database
Connect to the RMAN Root Container Database (CDB) by using rman target sys/<password>@<dbname> or rman target / Example: rman target sys/******@ora18c or rman target / - The result will be same
Connect to RMAN Pluggable Database (PDB) by using rman target sys/<password>@<PDB_Name> Example: rman target=sys@pdb1 target database Password: ******
Note:
If you connect to CDB, It’s shows all the CDB & PDB Databases
If you connect to PDB, It’s shows only PDB data only.
Issue report schema to identify the CDB (ORA18C) & PDBS (PDB1)
Connect to CDB & check the cdb,pdb data contain init.
[oracle@oracle18cdb ~]$ rman target sys/ora18ctest$@ora18c Recovery Manager: Release 18.0.0.0.0 - Production on Tue Jun 25 01:28:54 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA18C (DBID=624054314) RMAN> report schema; --- Here you can see you CDB as well as number of PDB Created. using target database control file instead of recovery catalog Report of database schema for database with db_unique_name ORA18C List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 2048 SYSTEM YES /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_system_g7wofq7v_.dbf 3 3072 SYSAUX NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wohgf4_.dbf 4 500 UNDOTBS1 YES /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wojkpd_.dbf 5 270 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_system_g7wosthw_.dbf 6 350 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wosthp_.dbf 7 200 USERS NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_users_g7wojltf_.dbf 8 100 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wosthz_.dbf 14 500 PDB1:SYSTEM YES /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf 15 700 PDB1:SYSAUX NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf 16 505 PDB1:UNDOTBS1 YES /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf 17 5 PDB1:USERS NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf 18 100 PDB1:TEST NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf 19 2048 PDB_AVAND:SYSTEM YES /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_system_ghptpj95_.dbf 20 2048 PDB_AVAND:SYSAUX NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_sysaux_ghptpjb4_.dbf 21 500 PDB_AVAND:UNDOTBS1 YES /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_undotbs1_ghptpjb5_.dbf 22 200 PDB_AVAND:USERS NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_users_ghptq11g_.dbf 24 1024 PDB_AVAND:AVAND_TBS NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/avand_tbs.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 129 TEMP 32767 /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_temp_g7wol9v4_.tmp 2 62 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/ORA18C/datafile/temp012019-03-05_06-02-46-915-AM.dbf 3 129 PDB1:TEMP 32767 /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_temp_g8sx02ho_.dbf 4 130 PDB_AVAND:TEMP 32767 /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_temp_ghptpjb6_.dbf
Connect to PDB & take Complete CDB backup which include CDB$ROOT, PDB$SEED & ALL PDBS
Create a directory to place a backup in given location
[oracle@oracle18cdb ~]$ mkdir -p /u01/app/backup/rman/FULL_CDB_BKP
[oracle@oracle18cdb ~]$ rman target sys/ora18ctest$@ora18c
RMAN> run {
backup as compressed backupset incremental level 0 database tag full_cdb_bkp format '/u01/app/backup/rman/FULL_CDB_BKP/df_%d_%T_%s.bck';
backup as compressed backupset archivelog all format '/u01/app/backup/rman/FULL_CDB_BKP/arch_%d_%T_%s.bck' delete input;
}
Starting backup at 25-JUN-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=65 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wohgf4_.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_system_g7wofq7v_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wojkpd_.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_users_g7wojltf_.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUN-19
channel ORA_DISK_1: finished piece 1 at 25-JUN-19
piece handle=/u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_127.bck tag=FULL_CDB_BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00019 name=/u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_system_ghptpj95_.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_sysaux_ghptpjb4_.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/avand_tbs.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_undotbs1_ghptpjb5_.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_users_ghptq11g_.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUN-19
channel ORA_DISK_1: finished piece 1 at 25-JUN-19
piece handle=/u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_128.bck tag=FULL_CDB_BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUN-19
channel ORA_DISK_1: finished piece 1 at 25-JUN-19
piece handle=/u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_129.bck tag=FULL_CDB_BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wosthp_.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_system_g7wosthw_.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wosthz_.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUN-19
channel ORA_DISK_1: finished piece 1 at 25-JUN-19
piece handle=/u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_130.bck tag=FULL_CDB_BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 25-JUN-19
Starting backup at 25-JUN-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=186 RECID=147 STAMP=1011840277
channel ORA_DISK_1: starting piece 1 at 25-JUN-19
channel ORA_DISK_1: finished piece 1 at 25-JUN-19
piece handle=/u01/app/backup/rman/FULL_CDB_BKP/arch_ORA18C_20190625_131.bck tag=TAG20190625T024437 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/ORA18C/archivelog/2019_06_25/o1_mf_1_186_gk3jpnps_.arc RECID=147 STAMP=1011840277
Finished backup at 25-JUN-19
Starting Control File and SPFILE Autobackup at 25-JUN-19
piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/autobackup/2019_06_25/o1_mf_s_1011840280_gk3jproh_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 25-JUN-19
Verify the Backup Physically & RMAN
[oracle@oracle18cdb ~]$ cd /u01/app/backup/rman/FULL_CDB_BKP/ [oracle@oracle18cdb FULL_CDB_BKP]$ ls arch_ORA18C_20190625_131.bck df_ORA18C_20190625_127.bck df_ORA18C_20190625_128.bck df_ORA18C_20190625_129.bck df_ORA18C_20190625_130.bck
RMAN> list backup of database; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 109 Incr 1 17.95M DISK 00:00:12 25-JUN-19 BP Key: 109 Status: AVAILABLE Compressed: YES Tag: TUESDAY_LEVEL_1 Piece Name: /u01/app/backup/rman/tuesday_level_1/df_ORA18C_20190625_121.bck List of Datafiles in backup set 109 Container ID: 3, PDB Name: PDB1 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 14 1 Incr 8979443 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf 15 1 Incr 8979443 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf 16 1 Incr 8979443 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf 17 1 Incr 8979443 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf 18 1 Incr 8979443 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------ ---- -- ---------- ----------- ------------ --------------- 114 Incr 0 543.47M DISK 00:01:56 25-JUN-19 BP Key: 114 Status: AVAILABLE Compressed: YES Tag: FULL_CDB_BKP Piece Name: /u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_127.bck List of Datafiles in backup set 114 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 1 0 Incr 9006101 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_system_g7wofq7v_.dbf 3 0 Incr 9006101 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wohgf4_.dbf 4 0 Incr 9006101 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wojkpd_.dbf 7 0 Incr 9006101 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_users_g7wojltf_.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 115 Incr 0 199.10M DISK 00:00:44 25-JUN-19 BP Key: 115 Status: AVAILABLE Compressed: YES Tag: FULL_CDB_BKP Piece Name: /u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_128.bck List of Datafiles in backup set 115 Container ID: 4, PDB Name: PDB_AVAND File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 19 0 Incr 9006298 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_system_ghptpj95_.dbf 20 0 Incr 9006298 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_sysaux_ghptpjb4_.dbf 21 0 Incr 9006298 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_undotbs1_ghptpjb5_.dbf 22 0 Incr 9006298 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/o1_mf_users_ghptq11g_.dbf 24 0 Incr 9006298 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8ACC527FC25A7B2FE0538378A8C0927F/datafile/avand_tbs.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 116 Incr 0 206.40M DISK 00:00:47 25-JUN-19 BP Key: 116 Status: AVAILABLE Compressed: YES Tag: FULL_CDB_BKP Piece Name: /u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_129.bck List of Datafiles in backup set 116 Container ID: 3, PDB Name: PDB1 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 14 0 Incr 9006324 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf 15 0 Incr 9006324 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf 16 0 Incr 9006324 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf 17 0 Incr 9006324 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf 18 0 Incr 9006324 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 117 Incr 0 180.27M DISK 00:00:39 25-JUN-19 BP Key: 117 Status: AVAILABLE Compressed: YES Tag: FULL_CDB_BKP Piece Name: /u01/app/backup/rman/FULL_CDB_BKP/df_ORA18C_20190625_130.bck List of Datafiles in backup set 117 Container ID: 2, PDB Name: PDB$SEED File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 5 0 Incr 1554215 05-MAR-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_system_g7wosthw_.dbf 6 0 Incr 1554215 05-MAR-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wosthp_.dbf 8 0 Incr 1554215 05-MAR-19 NO /u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wosthz_.dbf
========Hence the Full backup of CDB is Completed Successfully, Tested & verified in our env========
Connect to PDB & take check the datafiles exist init
[oracle@oracle18cdb ]$ rman target=sys@pdb1 Recovery Manager: Release 18.0.0.0.0 - Production on Tue Jun 25 02:56:37 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: ORA18C:PDB1 (DBID=1378676247) RMAN> report schema; using target database control file instead of recovery catalog Report of database schema for database with db_unique_name ORA18C List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name --- -------- -------------------- ------- ------------------------ 14 500 SYSTEM NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf 15 700 SYSAUX NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf 16 505 UNDOTBS1 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf 17 5 USERS NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf 18 100 TEST NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 3 129 TEMP 32767 /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_temp_g8sx02ho_.dbf
Connect to PDB & take a backup
Create a directory to place a backup in given location
[oracle@oracle18cdb ~]$ mkdir -p /u01/app/backup/rman/FULL_SINGLE_PDB_BKP
[oracle@oracle18cdb ~]$ rman target sys/ora18ctest$@ora18c
RMAN> run {
backup as compressed backupset incremental level 0 database tag FULL_SINGLE_PDB_BKP format '/u01/app/backup/rman/FULL_SINGLE_PDB_BKP/df_%d_%T_%s.bck';
backup as compressed backupset archivelog all format '/u01/app/backup/rman/FULL_SINGLE_PDB_BKP/arch_%d_%T_%s.bck' delete input;
}
Starting backup at 25-JUN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=278 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf
channel ORA_DISK_1: starting piece 1 at 25-JUN-19
channel ORA_DISK_1: finished piece 1 at 25-JUN-19
piece handle=/u01/app/backup/rman/FULL_SINGLE_PDB_BKP/df_ORA18C_20190625_134.bck tag=FULL_SINGLE_PDB_BKP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 25-JUN-19
Starting backup at 25-JUN-19
using channel ORA_DISK_1
skipping archived logs when connected to a PDB
backup cancelled because there are no files to backup
Finished backup at 25-JUN-19
Verify the Backup Physically & RMAN
[oracle@oracle18cdb FULL_SINGLE_PDB_BKP]$ ls df_ORA18C_20190625_134.bck
RMAN> list backup of database; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 121 Incr 0 206.58M DISK 00:00:48 25-JUN-19 BP Key: 121 Status: AVAILABLE Compressed: YES Tag: FULL_SINGLE_PDB_BKP Piece Name: /u01/app/backup/rman/FULL_SINGLE_PDB_BKP/df_ORA18C_20190625_134.bck List of Datafiles in backup set 121 File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name ---- -- ---- ---------- --------- ----------- ------ ---- 14 0 Incr 9008122 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf 15 0 Incr 9008122 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf 16 0 Incr 9008122 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_undotbs1_g8sx02hn_.dbf 17 0 Incr 9008122 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_users_g8sx02hp_.dbf 18 0 Incr 9008122 25-JUN-19 NO /u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_test_g8sxpxts_.dbf
===Hence the Full backup of Single PDB is Completed Successfully, Tested & verified in our env===
Partial PDB backup in different scenario as shown below:
Backup system & sysaux tablespace from PDB1 which connected to CDB:
RMAN> backup tablespace pdb1:system, pdb1:sysaux; Starting backup at 25-JUN-19 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=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf input datafile file number=00014 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf channel ORA_DISK_1: starting piece 1 at 25-JUN-19 channel ORA_DISK_1: finished piece 1 at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/backupset/2019_06_25/o1_mf_nnndf_TAG20190625T032541_gk3m3p83_.bkp tag=TAG20190625T032541 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15 Finished backup at 25-JUN-19 Starting Control File and SPFILE Autobackup at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/autobackup/2019_06_25/o1_mf_s_1011842757_gk3m45ph_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 25-JUN-19
Backup system tablespace from pluggable database PDB1 & SYSAUX tablespace from CDB:
Note: If you connected to CDB then you do not specify the PDB prefix, the CDB container is assumed.
[oracle@oracle18cdb ~]$ rman target sys/ora18ctest$@ora18c Recovery Manager: Release 18.0.0.0.0 - Production on Tue Jun 25 03:36:45 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to target database: ORA18C (DBID=624054314) RMAN> backup tablespace pdb1:system, sysaux; Starting backup at 25-JUN-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=55 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=00003 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_sysaux_g7wohgf4_.dbf channel ORA_DISK_1: starting piece 1 at 25-JUN-19 channel ORA_DISK_1: finished piece 1 at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/backupset/2019_06_25/o1_mf_nnndf_TAG20190625T033724_gk3mso2n_.bkp tag=TAG20190625T033724 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00014 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_system_g8sx02h4_.dbf channel ORA_DISK_1: starting piece 1 at 25-JUN-19 channel ORA_DISK_1: finished piece 1 at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/backupset/2019_06_25/o1_mf_nnndf_TAG20190625T033724_gk3mtg8k_.bkp tag=TAG20190625T033724 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 25-JUN-19 Starting Control File and SPFILE Autobackup at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/autobackup/2019_06_25/o1_mf_s_1011843473_gk3mtl06_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 25-JUN-19
If you want to take a backup with the file#, however the file# is unique, you can take a backup of datafiles using the connection of CDB
Consider am taking a backup datafile 2 from CDB$ROOT & datafile 10 from PDB1
[oracle@oracle18cdb ~]$ rman target sys/ora18ctest$@ora18c Recovery Manager: Release 18.0.0.0.0 - Production on Tue Jun 25 06:08:20 2019 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA18C (DBID=624054314) RMAN> backup datafile 4,15; Starting backup at 25-JUN-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=21 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=00015 name=/u01/app/oracle/oradata/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/datafile/o1_mf_sysaux_g8sx02hl_.dbf channel ORA_DISK_1: starting piece 1 at 25-JUN-19 channel ORA_DISK_1: finished piece 1 at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/8357EF6595DF3749E0538378A8C0E2C5/backupset/2019_06_25/o1_mf_nnndf_TAG20190625T060837_gk3wo5j1_.bkp tag=TAG20190625T060837 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=00004 name=/u01/app/oracle/oradata/ORA18C/datafile/o1_mf_undotbs1_g7wojkpd_.dbf channel ORA_DISK_1: starting piece 1 at 25-JUN-19 channel ORA_DISK_1: finished piece 1 at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/backupset/2019_06_25/o1_mf_nnndf_TAG20190625T060837_gk3wodrb_.bkp tag=TAG20190625T060837 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 25-JUN-19 Starting Control File and SPFILE Autobackup at 25-JUN-19 piece handle=/u01/app/oracle/fast_recovery_area/ORA18C/autobackup/2019_06_25/o1_mf_s_1011852526_gk3wog8o_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 25-JUN-19