I’ve checked some notes, there could be an issue if you have read through only tablespaces, then “”BACKUP OPTIMIZATION ON” results in skipping the backup of such datafiles when there is a backup obtainable. Should you, however, feel that creating a script is complicated, you could always turn to websites https://trentonihxlr.fare-blog.com/33090884/the-definitive-guide-to-list-expired-backup-of-archivelog