List RMAN backup command for particular time period
Checked list of archive backup between time range
RMAN> list backup of archivelog time between "to_date('20-MAR-2013 00:00:00','DD-MON-YYYY HH24:MI:SS')" and "to_date('25-MAR-2013 00:00:00','DD-MON-YYYY HH24:MI:SS')";
Checked list of database backup
RMAN> LIST BACKUP OF DATABASE COMPLETED AFTER '(SYSDATE-2)';
Checked list of archivelog backup
RMAN>LIST BACKUP OF ARCHIVELOG BETWEEN '20-MAR-2013' AND '25-MAR-2013';
List of backup of one datafile:
RMAN>LIST BACKUP OF DATAFILE 1 COMPLETED BETWEEN '06-OCT-2008' and '25-DEC-2008';
Other user full commands:
LIST BACKUP: list all backup sets, copies, and proxy copies of a database, tablespace, data file, archived redo log, control file, or server parameter file.
LIST COPY: list all the images copy of database files and archive log files
LIST archivelog: list all archive log files
List incarnation: list all incarnations of the database (incarnation is created when open database with resetlogs)
List script names: list the name of recovery catalog created.
List failure: it is part of data recovery advisory which list the failure present in database.
LIST BACKUP SUMMARY: provide one line summary for backup Status.
LIST BACKUP BY FILE: List backup of each datafile, archive, control file by file wise