My customer uses Veeam server to backup windows oracle(11gr2) VM. The number of databases in the oracle vm is two.
Backup job was set with application-aware and archive logs over 15 GB option was set.
But, archive logs did not deleted even though the partition of the log was almost full(50GB).
So, I opened support case.
After remote session, Veeam Support told me that there are around 1,000 archived logs file in the partition.
But, in veeam logs, Veeam Found only around 400 archived logs by executing query.
The query is below.
Has anyone experienced this hidden archived log files?Exec oracle query: SELECT FIRST_CHANGE#, BLOCK_SIZE, RECID, STAMP, NAME, THREAD#, SEQUENCE#, RESETLOGS_CHANGE#, BLOCKS*BLOCK_SIZE, TO_CHAR(SYS_EXTRACT_UTC(CAST(FIRST_TIME AS TIMESTAMP)), 'yyyy/mm/dd hh24:mi:ss'), TO_CHAR(SYS_EXTRACT_UTC(CAST(NEXT_TIME AS TIMESTAMP)), 'yyyy/mm/dd hh24:mi:ss') FROM V$ARCHIVED_LOG WHERE STATUS != 'D' AND CREATOR != 'LGWR'