RMAN catalog resync fails ORA-01403: No Data Found

(Doc ID 1901097.1)

Last updated on APRIL 02, 2018

Applies to:

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

Symptoms

RMAN resync fails:


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 06/13/2014 07:48:33
ORA-01403: no data found

10046 trace on the catalog session shows ORa-1403 is being raised by this SQL statement:

SELECT CONF#, NAME, VALUE FROM RC_RMAN_CONFIGURATION RM WHERE DB_KEY = :B4 AND (:B3 IS NULL OR UPPER(:B3 ) = UPPER(RM.NAME)) AND (:B2 IS NULL OR UPPER(:B2 ) = UPPER(RM.VALUE)) AND ((NVL(:B1 , RM.DB_UNIQUE_NAME) = RM.DB_UNIQUE_NAME) OR RM.DB_UNIQUE_NAME IS NULL)

There is no Data Guard configured.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms