Find highest restore time or sequence or SCN from RMAN backup files
In this hypothetical situation:
I have a directory containing backup files for RAC database A. The original database A is no longer available. But I know that the rman backup uses the following naming convention
for level 0 backups, the files have this type of name
- database format '/backupdir/XXX_%T_lvl0_df_%U'
- current controlfile format '/backupdir/XXX_%T_lvl0_ctl_%U'
- spfile format '/backupdir/XXX_%T_lvl0_spf_%U'
- plus archivelog format '/backupdir/XXX_%T_lvl0_arc_%U'
For level 1 backups, the files have the same type of name except that lvl0 is replaced with lvl1
0