With LOGRETAIN selected ON does this parameter correctly show the log file that it is safe to delete to. For example
With online backups one needs to keep the logs around that were active during the backup to allow recovery. To do this the head and tail of the logs needs to be identified to cover the time of the backup. What happens if there is a long running transaction that spans log files
For example when log 00000010 is the active log file a transaction is begun but not completed.
Logs 00000011 00000012 00000013 all fill up and we are now on 00000014. What will the active log param show will it be 00000014, the current active log, or will it show 00000010, the log file with the start of the oldest running transaction ?