determine redo logs that will be required for recovery
I need to delete some of my archived redo logs.
Suppose I had taken a backup few days back and only few archived logs will be required in this case i.e the ones that were generated at/or after the time backup was taken and others are not of any use.
Though there are alternate ways of knowing this like first list backup and then compare this time with the first_time in v$log_history.
But is there any view in Oracle that can provide one to one correspondence between a backup taken and start of archived log that will be required if we want to recover using this backup?
v$recovery_log will contain data only if some media failure actually occurs. So, it also can't help.