RMAN > LIST BACKUP;
- Displays all backup sets, proxy copies, and image copies.
RMAN > LIST BACKUP SUMMARY;
- Provides a concise, one-line summary per backup.
RMAN > LIST BACKUP BY FILE;
- Groups output by the database files (datafiles, control files, etc.) included in the backups.
RMAN > LIST BACKUP OF DATAFILE { file ID | 'File path'};
- Lists backups for all datafiles and the control file.
RMAN > LIST BACKUP OF TABLESPACE USERS;
- Filters for backups containing a specific tablespace.
RMAN > LIST BACKUP OF ARCHIVELOG ALL;
- Shows all archived redo log backups.
RMAN > LIST BACKUP OF CONTROLFILE;
- Displays all control file backups.
RMAN > LIST BACKUP OF SPFILE;
- Lists server parameter file backups.
RMAN > LIST BACKUP TAG 'tag_name';
or
RMAN > LIST BACKUP SUMMARY TAG 'tag_name';
- Filters results by a user-defined backup tag.
