My Oracle Support Banner

Backups Keep Failing with RMAN-03009 ORA-01422 (Doc ID 2579153.1)

Last updated on SEPTEMBER 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 Backups Keep failing with :

starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 08/12/2019 09:51:41
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/12/2019 09:51:41
ORA-01422: exact fetch returns more than requested number of rows

 

Trace file shows :

RMAN-03009: failure of resync command on default channel at 08/15/2019 09:27:50
RMAN-10032: unhandled exception during execution of job step 1:
ORA-06512: at line 3401
RMAN-10035: exception raised in RPC:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "<recovery catalog owner>.DBMS_RCVCAT", line 10191
RMAN-10031: RPC Error: ORA-01422 occurred during call to DBMS_RCVCAT.CHECKBLOCKCORRUPTION

Changes

 None

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
Changes
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.