Use the RESTORE … PREVIEW command to list the backups and archive redo log files that RMAN will use to restore and recover database data files.

The RESTORE … PREVIEW command does not actually restore any files. Rather, it lists the backup files that will beused for a restore operation.

This example previews in detail the backups required for restore and recovery for the entire database:

RMAN> restore database preview;

You can also preview required backup files at a summarized level of detail:

RMAN> restore database preview summary;

You can also preview required backup files at a summarized level of detail:

RMAN> restore database preview summary;

Here is a snippet of the output:

List of Backups

Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

9207     B F A DISK          05-JUL-23  1      1            NO                          TAG20230705T010705

9232     B 1 A SBT_TAPE 05-JUL-23          1        1        YES 9359     B 1 A SBT_TAPE 06-JUL-23          1        1        YES

DBTREGULAR-L11688534102946HLS

DBTREGULAR-L11688620533112ORN

List of Archived Log Copies for database with db_unique_name MMDB23C_MMDB23C

Key           Thrd Seq           S Low Time

1778   1           1779         A 05-JUL-23

Name: +RECO/MMDB23C_MMDB23C/ARCHIVELOG/2023_07_05/thread_1_ seq_1779.1254.11413512471779   1         1780    A 05-JUL-23

Name: +RECO/MMDB23C_MMDB23C/ARCHIVELOG/2023_07_05/thread_1_ seq_1780.1255.1141354861

recovery will be done up to SCN 42403694 Media recovery start SCN is 39020785

Recovery must be done beyond SCN 40884072 to clear datafile fuzziness validation succeeded for backup piece

Finished restore at 08-JUL-23

Here are some more examples of how to preview backups required for restore and recovery:

RMAN> restore tablespace system preview;

RMAN> restore pluggable database mmpdb preview;

RMAN> restore archivelog from time ‘sysdate -1’ preview; RMAN> restore datafile 1, 2, 3 preview;