单独备份PDB
关键词为pluggable database PDB1_WHS
RMAN> backup as compressed backupset incremental level=0 pluggable database PDB1_WHS format '/rmanbackup/rman0_%d_%s_%T' tag='level0' plus archivelog;
Starting backup at 02-MAY-05
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=395 instance=whs11 device type=DISK
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=2 sequence=1 RECID=1 STAMP=557258812
input archived log thread=1 sequence=16 RECID=3 STAMP=557259632
input archived log thread=2 sequence=2 RECID=2 STAMP=557258827
channel ORA_DISK_1: starting piece 1 at 02-MAY-05
channel ORA_DISK_1: finished piece 1 at 02-MAY-05
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/01gje6rg_1_1 tag=TAG20050502T182032 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-MAY-05
Starting backup at 02-MAY-05
using channel ORA_DISK_1
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=00011 name=+DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/sysaux.275.1057318911
input datafile file number=00010 name=+DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/system.274.1057318911
input datafile file number=00012 name=+DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/undotbs1.273.1057318911
input datafile file number=00013 name=+DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/undo_2.277.1057318927
input datafile file number=00014 name=+DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/users.278.1057318927
channel ORA_DISK_1: starting piece 1 at 02-MAY-05
channel ORA_DISK_1: finished piece 1 at 02-MAY-05
piece handle=/rmanbackup/rman0_WHS1_2_20050502 tag=LEVEL0 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 02-MAY-05
Starting backup at 02-MAY-05
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=17 RECID=4 STAMP=557259651
channel ORA_DISK_1: starting piece 1 at 02-MAY-05
channel ORA_DISK_1: finished piece 1 at 02-MAY-05
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/03gje6s3_1_1 tag=TAG20050502T182051 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-MAY-05
Starting Control File and SPFILE Autobackup at 02-MAY-05
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/c-2406852607-20050502-00 comment=NONE
Finished Control File and SPFILE Autobackup at 02-MAY-05
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 6.88M DISK 00:00:01 02-MAY-05
BP Key: 1 Status: AVAILABLE Compressed: YES Tag: TAG20050502T182032
Piece Name: /u01/app/oracle/product/19.3.0/db_1/dbs/01gje6rg_1_1
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 16 49683875 01-MAY-05 49786269 02-MAY-05
2 1 2149681 24-NOV-20 49784912 02-MAY-05
2 2 49784912 02-MAY-05 49785026 02-MAY-05
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Incr 0 97.85M DISK 00:00:11 02-MAY-05
BP Key: 2 Status: AVAILABLE Compressed: YES Tag: LEVEL0
Piece Name: /rmanbackup/rman0_WHS1_2_20050502
List of Datafiles in backup set 2
Container ID: 3, PDB Name: PDB1_WHS
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- --------- ----------- ------ ----
10 0 Incr 49786295 02-MAY-05 NO +DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/system.274.1057318911
11 0 Incr 49786295 02-MAY-05 NO +DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/sysaux.275.1057318911
12 0 Incr 49786295 02-MAY-05 NO +DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/undotbs1.273.1057318911
13 0 Incr 49786295 02-MAY-05 NO +DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/undo_2.277.1057318927
14 0 Incr 49786295 02-MAY-05 NO +DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/users.278.1057318927
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 7.50K DISK 00:00:00 02-MAY-05
BP Key: 3 Status: AVAILABLE Compressed: YES Tag: TAG20050502T182051
Piece Name: /u01/app/oracle/product/19.3.0/db_1/dbs/03gje6s3_1_1
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 17 49786269 02-MAY-05 49786309 02-MAY-05
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 18.89M DISK 00:00:02 02-MAY-05
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20050502T182052
Piece Name: /u01/app/oracle/product/19.3.0/db_1/dbs/c-2406852607-20050502-00
SPFILE Included: Modification time: 02-MAY-05
SPFILE db_unique_name: WHS1
Control File Included: Ckp SCN: 49786322 Ckp time: 02-MAY-05单独备份PDB的表空间
RMAN> backup tablespace PDB1_WHS:users format '/rmanbackup/rmantbs_%d_%s_%T';
Starting backup at 02-MAY-05
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=00014 name=+DATA1/WHS1/B4D31742116320ECE0532900A8C025DC/DATAFILE/users.278.1057318927
channel ORA_DISK_1: starting piece 1 at 02-MAY-05
channel ORA_DISK_1: finished piece 1 at 02-MAY-05
piece handle=/rmanbackup/rmantbs_WHS1_7_20050502 tag=TAG20050502T183011 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-MAY-05
Starting Control File and SPFILE Autobackup at 02-MAY-05
piece handle=/u01/app/oracle/product/19.3.0/db_1/dbs/c-2406852607-20050502-02 comment=NONE
Finished Control File and SPFILE Autobackup at 02-MAY-05