To list an individual backup, any of the three alternatives bellow would be valid query using rman:
RMAN> list backup of archivelog logseq=120316;
RMAN> list backup of archivelog logseq 120316;
RMAN> list backup of archivelog sequence 120316;
To view backups of archivelog between two sequences:
RMAN> list backup of archivelog sequence between 120316 and 120317;
RMAN> list backup of archivelog from logseq 412593 until logseq 412656;
U
se the SUMMARY directive to view only the backupsets affected:
RMAN> list backup of archivelog from logseq 412593 until logseq 412656 summary;
RMAN> list backup of archivelog sequence between 120316 and 120317 summary;
To view backups completed before a specific date:
RMAN> list backup completed before "to_date( '18.12.2009 18:00:00', 'DD.MM.YYYY HH24:MI:SS')";
RMAN> list backup of archivelog all summary completed before "to_date( '18.12.2009 18:00:00', 'DD.MM.YYYY HH24:MI:SS')";
RMAN> list archivelog all completed before 'sysdate-2';:
To list archivelogs recognized by the controlfile between two sequnce numbers:
RMAN> list archivelog sequence between 110880 and 110881;
To list archivelogs recognized by the controlfile up until yesterday:
RMAN> list archivelog until time 'sysdate-1';
To list archivelogs recognized by the controlfile from two days ago, up until yesterday:
RMAN> list archivelog from time 'sysdate-2' until time 'sysdate-1';
To limit the list of archivelogs to the ones taken on a specific date, in this case, the last of January 2022:
RMAN> list archivelog from time '31.01.2022' until time '01.02.2022';
If you remove the "until time" clause, RMAN will list all the archivelogs from 31.01.2022 up until the latest ones:
RMAN> list archivelog from time '31.01.2022';
Remember, the value of sysdate is the time right now, sysdate-1 is 24hrs ago, sysdate-2 is 48 hours ago, etc.
select sysdate, sysdate-1, sysdate-2 from dual;
SYSDATE SYSDATE-1 SYSDATE-2
------------------- ------------------- -------------------
03.02.2022 12:24:12 02.02.2022 12:24:12 01.02.2022 12:24:12
