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

Last updated on JULY 20, 2024

Applies to:

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

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