RMAN catalog resync fails ORA-06502 (Doc ID 1058920.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 - Release: 11.1
Information in this document applies to any platform.

Symptoms


RMAN resync catalog fails:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync command on default channel at 01/26/2010 17:17:58
ORA-06502: PL/SQL: numeric or value error

RMAN debug trace shows:

DBGRCVCAT: beginRmanOutputResync - input instance start time=708859650
DBGRCVCAT: beginRmanOutputResync - last_inst_startup_stamp=708356040,last_rout_stamp=709374566
DBGPLSQL: channel default: RMAN output last RMAN output 0 [09:00:06.146] (resync)
DBGRCVCAT: checkRmanOutput - Find rsr_ key
DBGRCVCAT: checkRmanOutput - Find session key
DBGRCVCAT: cancelCkpt - rollback, released all locks
DBGPLSQL: EXITED resync with status ORA--6502 [09:00:06.206]

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