HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to avoid Recovery Catalog's metadata being purged after 60 days?

Submitted by: @import:stackexchange-dba··
0
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 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?

Regards.

Solution

This is described in the note:

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.