2.6. Using LIST Commands

The LIST commands are used to query the RMAN repository and get the data regarding the BACKUP command, COPY command and database incarnations. A database incarnation is a separate version of a physical database. The output of the LIST command displays the files that the CHANGE, CROSSCHECK, and DELETE commands have used.

The LIST command displays backup information by using the BY BACKUP and BY FILE options. There are also SUMMARY and VERBOSE options to condense or expand the output. Let's look at the LIST BACKUPSET with the BY BACKUP and SUMMARY options:

RMAN> LIST BACKUPSET BY BACKUP SUMMARY; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag 1 B F A DISK 31-MAY-04 ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.