Databases Reference
In-Depth Information
List of Datafiles in backup set 152
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 1 Incr 2152892 12-SEP-12 /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 1 Incr 2152892 12-SEP-12 /u01/app/oracle/oradata/orcl/undotbs01.dbf
7 1 Incr 2152892 12-SEP-12 /u01/app/oracle/oradata/orcl/virt_catalog_01.dbf
...
---- -- ---- ---------- --------- ----
2 Full 2209483 21-SEP-12 /u01/app/oracle/oradata/orcl/example01.dbf
5 Full 2209483 21-SEP-12 /u01/app/oracle/oradata/orcl/cattbs_01.dbf
RMAN>
The basic
list
command shown in the previous example lists all backups in the RMAN repository for the
target database by serially listing each backup set (including the backup pieces information) and proxy copy. It also
identifies all the files that are part of the backup. If you would rather list the backups by just the backup files, you can
do so by using the
list backup by file
command, as shown in the following example:
RMAN> list backup by file;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 157 B 1 A 2153006 12-SEP-12 1 1 NO TAG20120912T105238
153 B 1 A 2152904 12-SEP-12 1 1 NO TAG20120912T105000
2 174 B F A 2209483 21-SEP-12 1 1 NO TAG20120921T140136
...
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 29 1925370 07-AUG-12 146 A 1 1 NO TAG20120912T104426
1 30 1925437 07-AUG-12 146 A 1 1 NO TAG20120912T104426
...
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
2196190 21-SEP-12 170 A 1 1 NO TAG20120921T095227
...
