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-13
Listing 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 TAG20130215T171219
Listing 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.dbf
Listing 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 blocks
Also See: