I'm using Oracle's Recovery Catalog to track my db's backups metadata (RC ver. is 12.01.00.02 )
I need to collect historical backup sizes but then I've realized there's no metadata information about completed backups beyond 60 days. (however, there's for FAILED and incompleted backups)
e.g. I'm trying to collect this data from
rc_rman_backup_job_details view. This RC's was used since Q1 2015, but only 60 days of completed backups are shown.
RMAN@SERESCATALOG> SELECT status, MIN(start_time) 2 FROM rc_rman_backup_job_details 3 GROUP BY status 4 ORDER by status; STATUS MIN(START_TIME) ----------- -------------------- COMPLETED 03-SEP-2016 01:31:34 FAILED 18-SEP-2015 09:03:50 RUNNING 28-MAY-2015 02:39:36
What controls this retention? There's any way to change it? Any documentation?