Friday, April 15, 2016

12c multitenant database backupset location

Organize  a chart based on below full list of backup information.



Note that if BACKUP OPTIMIZATION is turned on , the seeds files then are backed up once only.


Appendix




RMAN> list backupset;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
133     Full    4.34M      DISK        00:00:02     2016-APR-12 10:06:04
        BP Key: 133   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp0bls_.bkp
  List of Datafiles in backup set 133
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  5       Full 4542086    2016-APR-12 10:06:02 /rman001/oradata/RCATT/undotbs01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
134     Full    189.24M    DISK        00:00:57     2016-APR-12 10:07:02
        BP Key: 134   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp0ftk_.bkp
  List of Datafiles in backup set 134
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 4542088    2016-APR-12 10:06:05 /rman001/oradata/RCATT/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
135     Full    200.26M    DISK        00:01:08     2016-APR-12 10:07:10
        BP Key: 135   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp0blb_.bkp
  List of Datafiles in backup set 135
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3       Full 4542084    2016-APR-12 10:06:02 /rman001/oradata/RCATT/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
136     Full    102.60M    DISK        00:00:34     2016-APR-12 10:07:45
        BP Key: 136   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D960D0F8745635EE05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp2hj0_.bkp
  List of Datafiles in backup set 136
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  4       Full 2043027    2016-MAR-09 14:26:29 /rman001/oradata/RCATT/pdbseed/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
137     Full    110.38M    DISK        00:00:37     2016-APR-12 10:07:48
        BP Key: 137   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp2h52_.bkp
  List of Datafiles in backup set 137
  Container ID: 3, PDB Name: RCATPDB1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  8       Full 4542112    2016-APR-12 10:07:11 /rman001/oradata/RCATT/RCATPDB1/sysaux01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
138     Full    47.09M     DISK        00:00:16     2016-APR-12 10:08:02
        BP Key: 138   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp3lw2_.bkp
  List of Datafiles in backup set 138
  Container ID: 3, PDB Name: RCATPDB1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  7       Full 4542130    2016-APR-12 10:07:46 /rman001/oradata/RCATT/RCATPDB1/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
139     Full    43.30M     DISK        00:00:14     2016-APR-12 10:08:04
        BP Key: 139   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D960D0F8745635EE05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp3p2s_.bkp
  List of Datafiles in backup set 139
  Container ID: 2, PDB Name: PDB$SEED
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  2       Full 2043027    2016-MAR-09 14:26:29 /rman001/oradata/RCATT/pdbseed/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
140     Full    1.06M      DISK        00:00:00     2016-APR-12 10:08:05
        BP Key: 140   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp45tc_.bkp
  List of Datafiles in backup set 140
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  6       Full 4542138    2016-APR-12 10:08:05 /rman001/oradata/RCATT/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
141     Full    9.34M      DISK        00:00:03     2016-APR-12 10:08:08
        BP Key: 141   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100602
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/2D98C99BF6722388E05400144FF8A527/backupset/2016_04_12/o1_mf_nnndf_TAG20160412T100602_cjrp45cf_.bkp
  List of Datafiles in backup set 141
  Container ID: 3, PDB Name: RCATPDB1
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  9       Full 4542137    2016-APR-12 10:08:05 /rman001/oradata/RCATT/RCATPDB1/RCATPDB1_users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
143     2.50K      DISK        00:00:00     2016-APR-12 10:08:11
        BP Key: 143   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100811
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_annnn_TAG20160412T100811_cjrp4cmh_.bkp

  List of Archived Logs in backup set 143
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    442     4542164    2016-APR-12 10:08:10 4542172    2016-APR-12 10:08:11

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
144     1.70M      DISK        00:00:00     2016-APR-12 10:08:11
        BP Key: 144   Status: AVAILABLE  Compressed: YES  Tag: TAG20160412T100811
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/backupset/2016_04_12/o1_mf_annnn_TAG20160412T100811_cjrp4cl8_.bkp

  List of Archived Logs in backup set 144
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    441     4541226    2016-APR-12 09:56:17 4542164    2016-APR-12 10:08:10

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
145     Full    17.30M     DISK        00:00:01     2016-APR-12 10:08:13
        BP Key: 145   Status: AVAILABLE  Compressed: NO  Tag: TAG20160412T100812
        Piece Name: /rman001/oradata/fast_recovery_area/RCATT/autobackup/2016_04_12/o1_mf_s_908964492_cjrp4f6j_.bkp
  SPFILE Included: Modification time: 2016-APR-09 07:07:00
  SPFILE db_unique_name: RCATT
  Control File Included: Ckp SCN: 4542190      Ckp time: 2016-APR-12 10:08:12