Rman Connect Target Fails With ORA-06508 RMAN-04015 (Doc ID 1317517.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2014***

Symptoms

rman connect target fails with


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-04063: package body "APPS.DBMS_BACKUP_RESTORE" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.DBMS_BACKUP_RESTORE"
ORA-06512: at line 1
RMAN-04015: error setting target database character set to UTF8



The packages  DBMS_BACKUP_RESTORE are in Valid state but the error still occurs



sql> Select object_name,object_type,owner,status from dba_objects
       where object_name like '%DBMS_BACKUP%' ;
    
OBJECT_NAME          OBJECT_TYPE               OWNER        STATUS
-------------------  -------------------          -----------         -------
DBMS_BACKUP_RESTORE  PACKAGE                   SYS          VALID
DBMS_BACKUP_RESTORE  PACKAGE BODY          SYS          VALID


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