My Oracle Support Banner

RMAN RESYNC CATALOG is generating High amounts of Redo (Doc ID 1340991.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 9-Sep-2013***

Symptoms

The recovery Catalog is generating high redo logs in 11.2.0.2 due to many operation on RSR table.

11gr2 rman catalog produces very high redo, and lots of archive logs. although The rman catalog database has 2 small rman catalog owner schemas, using logminer to see exactly what is generating the redo, it all appears to be 3 sql statements:

INSERT into RSR
UPDATE RSR
DELETE from RSR


Looking at Resyncing trace and found an old job marked as running:

We see from rman.trc




Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.