Missing RMAN backup information
Hi team,
I have strange situation. We are using CommVault software for taking incremental backups in our environment. I was able to go back and list first backup that was taken during December last year. Now when i list backups i can go back till April, but dates before are missing.
I use this query to list RMAN backups in our 12.1 database:
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,
to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,
elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS
order by start_time desc;