RMAN LIST Command uses the information in the RMAN repository to provide lists of backups and other objects.
Listing Backups
This RMAN LIST Command example lists all backups. The output shows two backup sets on disk: one containing data files and the other containing autobackups. The output also shows one SBT backup containing archived redo log files.
RMAN> LIST BACKUP;
CopyList of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
200 Full 509.78M DISK 00:01:03 15-FEB-13
BP Key: 202 Status: AVAILABLE Compressed: NO Tag: TAG20130215T171219
Piece Name: /disk2/PROD/backupset/2013_02_15/o1_mf_nnndf_TAG20130215T171219_2xb17nbb_.bkp
List of Datafiles in backup set 200
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 421946 15-FEB-13 /disk1/oradata/prod/system01.dbf
2 Full 421946 15-FEB-13 /disk1/oradata/prod/sysaux01.dbf
3 Full 421946 15-FEB-13 /disk1/oradata/prod/undotbs01.dbf
4 Full 421946 15-FEB-13 /disk1/oradata/prod/cwmlite01.dbf
5 Full 421946 15-FEB-13 /disk1/oradata/prod/drsys01.dbf
6 Full 421946 15-FEB-13 /disk1/oradata/prod/example01.dbf
7 Full 421946 15-FEB-13 /disk1/oradata/prod/indx01.dbf
8 Full 421946 15-FEB-13 /disk1/oradata/prod/tools01.dbf
9 Full 421946 15-FEB-13 /disk1/oradata/prod/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
201 Full 7.98M DISK 00:00:03 15-FEB-13
BP Key: 203 Status: AVAILABLE Compressed: NO Tag: TAG20130215T171219
Piece Name: /disk2/PROD/backupset/2013_02_15/o1_mf_ncsnf_TAG20130215T171219_2xb19prg_.bkp
SPFILE Included: Modification time: 15-FEB-13
SPFILE db_unique_name: PROD
Control File Included: Ckp SCN: 421968 Ckp time: 15-FEB-13
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
227 30.50M SBT_TAPE 00:00:11 15-FEB-13
BP Key: 230 Status: AVAILABLE Compressed: NO Tag: TAG20130215T171334
Handle: 0bia4rtv_1_1 Media:
List of Archived Logs in backup set 227
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 5 389156 15-FEB-13 411006 15-FEB-13
1 6 411006 15-FEB-13 412972 15-FEB-13
1 7 412972 15-FEB-13 417086 15-FEB-13
1 8 417086 15-FEB-13 417114 15-FEB-13
1 9 417114 15-FEB-13 417853 15-FEB-13
1 10 417853 15-FEB-13 421698 15-FEB-13
1 11 421698 15-FEB-13 421988 15-FEB-13Listing a Summary of Backups
RMAN> LIST BACKUP SUMMARY; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag ------- -- -- - ----------- --------------- ------- ------- ---------- --- 200 B F A DISK 15-FEB-13 1 1 NO TAG20130215T171219 201 B F A DISK 15-FEB-13 1 1 NO TAG20130215T171219 227 B A A SBT_TAPE 15-FEB-13 1 1 NO TAG20130215T171334
Listing Backups by File
This example groups all backups by file. The tag column of the data file backup indicates that one backup set contains backup pieces with different tags. The status column of the archived log backup indicates that the backup set is unavailable.
RMAN> LIST BACKUP BY FILE;
List of Datafile Backups
========================
File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag
---- ------- - -- - ---------- --------- ------- ------- ---------- ---
1 329 B F A 454959 16-FEB-13 1 1 NO DF1
2 349 B F A 454997 16-FEB-13 1 1 NO DF2
3 527 B F A 455218 16-FEB-13 1 1 NO FRI_BKP
368 B F A 455022 16-FEB-13 1 1 NO DF3
4 387 B F X 455042 16-FEB-13 1 1 NO DF4
5 407 B F A 455063 16-FEB-13 1 1 NO DF5
6 428 B F A 455083 16-FEB-13 1 2 NO *
7 450 B F X 455103 16-FEB-13 1 1 NO DF7
8 473 B F A 455123 16-FEB-13 1 1 NO DF8
9 497 B F A 455143 16-FEB-13 1 1 NO DF9
List of Archived Log Backups
============================
Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag
---- ------- ---------- --------- ------- - ------- ------- ---------- ---
1 5 389156 15-FEB-13 227 U 1 1 NO TAG20130215T171334
1 6 411006 15-FEB-13 227 U 1 1 NO TAG20130215T171334
1 7 412972 15-FEB-13 227 U 1 1 NO TAG20130215T171334
1 8 417086 15-FEB-13 227 U 1 1 NO TAG20130215T171334
1 9 417114 15-FEB-13 227 U 1 1 NO TAG20130215T171334
1 10 417853 15-FEB-13 227 U 1 1 NO TAG20130215T171334
1 11 421698 15-FEB-13 227 U 1 1 NO TAG20130215T171334
List of Control File Backups
============================
CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag
---------- --------- ------- - ------- ------- ---------- ---
454974 16-FEB-13 330 A 1 1 NO DF1
421968 15-FEB-13 201 A 1 1 NO TAG20130215T171219
List of SPFILE Backups
======================
Modification Time BS Key S #Pieces #Copies Compressed Tag
----------------- ------- - ------- ------- ---------- ---
15-FEB-13 330 A 1 1 NO DF1
15-FEB-13 201 A 1 1 NO TAG20130215T171219Listing Image Copies
The following example lists all data file, control file, and archived redo log copies known to RMAN:
RMAN> LIST COPY;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - --------------- ---------- ---------------
618 1 A 16-FEB-13 461057 16-FEB-13
Name: /disk2/PROD/datafile/o1_mf_system_2xdbrg13_.dbf
Tag: TAG20130216T140706
631 2 A 16-FEB-13 461163 16-FEB-13
Name: /disk2/PROD/datafile/o1_mf_sysaux_2xdbzybx_.dbf
Tag: TAG20130216T141109
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
619 A 16-FEB-13 461133 16-FEB-13
Name: /disk2/PROD/controlfile/o1_mf_TAG20130216T140706_2xdbz5tb_.ctl
Tag: TAG20130216T140706
594 A 16-FEB-13 460650 16-FEB-13
Name: /disk2/PROD/controlfile/o1_mf_TAG20130216T135954_2xdbbz99_.ctl
Tag: TAG20130216T135954
List of Archived Log Copies for database with db_unique_name PROD
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
105 1 5 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_5_614616887.dbf
122 1 6 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_6_614616887.dbf
123 1 7 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_7_614616887.dbf
124 1 8 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_8_614616887.dbf
125 1 9 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_9_614616887.dbf
185 1 10 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_10_614616887.dbf
221 1 11 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_11_614616887.dbf
262 1 12 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_12_614616887.dbf
263 1 13 A 15-FEB-13
Name: /disk1/oradata/prod/arch/archive1_13_614616887.dbfListing Database Incarnations
This example lists all database incarnations recorded in the recovery catalog.
RMAN> LIST INCARNATION; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 78 94 PROD 1619073740 PARENT 1 14-FEB-13 78 79 PROD 1619073740 CURRENT 388003 15-FEB-13
Listing Failures
This example lists all failures regardless of their priority. If you do not specify ALL, then LIST FAILURE output does not include failures with LOW priority.
RMAN> LIST FAILURE ALL;
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
---------- -------- --------- ------------- -------
142 HIGH OPEN 23-APR-13 One or more non-system datafiles are missing
101 HIGH OPEN 23-APR-13 Datafile 1: '/disk1/oradata/prod/system01.dbf'
contains one or more corrupt blocksAlso See: