RMAN LIST command produce detailed report against information recorded in the repository for most of the following:

  1. Backups and image copies
  2. Backups and copies of datafiles
  3. Specified archived logs, backup sets, backup pieces, control file copies, datafile copies, and proxy copies
  4. Stored scripts in the recovery catalog.

The RMAN LIST and REPORT commands, generate reports on backup activities based on the RMAN repository. Use SHOW ALL to display the current RMAN configuration.

Listing Backups

Run the LIST BACKUP and LIST COPY commands to display information.

RMAN> LIST BACKUP OF DATABASE; 
RMAN> LIST COPY OF DATAFILE 1,2,3;
RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
RMAN> LIST CONTROLFILECOPY "/tmp/cf.cpy";
RMAN> LIST BACKUPSET OF DATAFILE 1;

For backups, you can control the format of LIST output with these options:


Parameter

Example

Explanation

BY BACKUP

LIST BACKUP OF DATABASE BY BACKUP

Organizes the output by backup set. This is the default mode of presentation.

BY FILE

LIST BACKUP BY FILE

Lists the backups according to which file was backed up.

SUMMARY

LIST BACKUP SUMMARY

Displays summary output. By default, the output is VERBOSE.

For both backups and copies you have the following additional options:


Parameter

Example

Explanation

EXPIRED

LIST EXPIRED COPY

Lists backups that are recorded in the RMAN repository but that were not present at the expected location on disk or tape during the last CROSSCHECK command. Such backups may have been deleted outside of RMAN.

RECOVERABLE

LIST BACKUP RECOVERABLE

Specifies datafile backups or copies that are available and that can be restored and recovered in the current database incarnation.

Go to top
JSN Boot template designed by JoomlaShine.com