RMAN catalog resync fails ORA-01403: No Data Found (Doc ID 1901097.1)

Last updated on OCTOBER 09, 2019

Applies to:

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

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