snippetMinor
How to avoid Recovery Catalog's metadata being purged after 60 days?
Viewed 0 times
afterpurgedavoidbeingrecoverycataloghowmetadatadays
Problem
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
What controls this retention? There's any way to change it? Any documentation?
Regards.
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:36What controls this retention? There's any way to change it? Any documentation?
Regards.
Solution
This is described in the note:
How to Clean up The information in EM Backup Report (Doc ID 430601.1)
Edit
When finished:
How to Clean up The information in EM Backup Report (Doc ID 430601.1)
Edit
recover.bsq, find the procedure cleanupRSR, change the default value 60 as needed:DELETE FROM rsr
WHERE rsr_end < nowTime-60
AND rsr.dbinc_key IN
(select dbinc_key from dbinc
where dbinc.db_key = this_db_key);When finished:
RMAN> upgrade catalog;Code Snippets
DELETE FROM rsr
WHERE rsr_end < nowTime-60
AND rsr.dbinc_key IN
(select dbinc_key from dbinc
where dbinc.db_key = this_db_key);RMAN> upgrade catalog;Context
StackExchange Database Administrators Q#154033, answer score: 4
Revisions (0)
No revisions yet.