Hello,
I am trying to write up a query on how to find out which backup set a datafile is in e.g. to be able to generate a RMAN recover command dynamically somehow. any idea if it is possible? I have looked into the V$BACKUP_SET, V$BACKUP_FILE but I just can't figure out how it ties together?
The command I am trying to produce looks something like this. Anything marker with <> is the parts I'd like to query:
restore from platform 'Solaris[tm] OE (64-bit)" foreign datafile <file #> format <datafile name> from backupset <backupset name>
Thanks
Andy