Hi. Typically, we ask for log files based on some pattern of Cnnnnnnn_Smmmmmmm.LOG. n/m can be '*'. Cnnnnnnn represents a log chain. Smmmmmmm.LOG represents a log file number.We know what Smmmmmmm.LOG but we don't always know what Cnnnnnnn we need. We have internal logic that helps us narrow down most log chains, but sometimes we need to query vendor to find the log chain with the highest log file number and then that is what we use. High percentage of use cases this will match without problem. For the others, we have way to make it work but take on a case by case basis.Log retrieval falls into two classes:
- Runtime: like replication, include logs into backup image, recovery of older log files ... we normally know what log chain the database is on and can ask for an exact match as the files come from the past.
- Database recovery: we may needs files going forward blind, in which case we query for the highest log chain that contains the next log file to read.