RMAN - List and Report

RMAN> list backup;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1       Full    281.02M    DISK        00:02:23     21-DEC-12     

        BP Key: 1   Status: AVAILABLE  Compressed: YES  Tag: TAG20121221T014321

        Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_12_21/o1_mf_nnndf_TAG20121221T014321_8f7d5blz_.bkp

  List of Datafiles in backup set 1

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1       Full 923674     21-DEC-12 /u01/app/oracle/oradata/orcl/system01.dbf

  2       Full 923674     21-DEC-12 /u01/app/oracle/oradata/orcl/sysaux01.dbf

  3       Full 923674     21-DEC-12 /u01/app/oracle/oradata/orcl/undotbs01.dbf

  4       Full 923674     21-DEC-12 /u01/app/oracle/oradata/orcl/users01.dbf

  5       Full 923674     21-DEC-12 /u01/app/oracle/oradata/orcl/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2       Full    1.03M      DISK        00:00:03     21-DEC-12     

        BP Key: 2   Status: AVAILABLE  Compressed: YES  Tag: TAG20121221T014321

        Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_12_21/o1_mf_ncsnf_TAG20121221T014321_8f7d9zkk_.bkp

  SPFILE Included: Modification time: 21-DEC-12

  SPFILE db_unique_name: ORCL

  Control File Included: Ckp SCN: 923743       Ckp time: 21-DEC-12

RMAN>