My Oracle Support Banner

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

Last updated on OCTOBER 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
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

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