Hi all,

One of the RMAN scripts that I inherited is doing a backup of the archivelogs as
follows:

backup
filesperset 20
format '${ORACLE_SID}_a${TSM_LEVEL}s%sp%p'
archivelog all
delete input;

Am "guessing" what this means is to backup all the archivelogs and then delete
them and each backupset will contain 20 archived logs and the backupsets are
named as per the format, am I guessing it correctly so far?

Now my question is how do I query the RMAN catalog to tell me what archived logs
are on which backupset? BTW, Oracle version is, unfortunately, still on 8.1.7.4.
Am currently browing via the web for answers but if someone around here know the
answer straight out of their head, please post it please ...

Thanks in advance ...




Oracle LazyDBA home page