Friday, May 16, 2014

List backup only with available status




List backup of database with available status in the rman repository

RMAN> list recoverable backup of database;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
125     Full    2.13M      DISK        00:00:03     16-MAY-2014 06:47:42
        BP Key: 154   Status: AVAILABLE  Compressed: NO  Tag: TAG20140516T064738
        Piece Name: +DATA/cvrman/backupset/2014_05_16/nnndf0_tag20140516t064738_0.297.847694861
  List of Datafiles in backup set 125
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3       Full 1178370    16-MAY-2014 06:47:39 +DATA/cvrman/datafile/undotbs1.258.847354795

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
127     Full    2.13M      DISK        00:00:02     16-MAY-2014 06:49:03
        BP Key: 156   Status: AVAILABLE  Compressed: NO  Tag: TAG20140516T064900
        Piece Name: +DATA/cvrman/backupset/2014_05_16/nnndf0_tag20140516t064900_0.321.847694943
  List of Datafiles in backup set 127
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  3       Full 1178426    16-MAY-2014 06:49:01 +DATA/cvrman/datafile/undotbs1.258.847354795

No comments: