How can I rebuild DBMS_BACKUP_RESTORE ?

Jun 13, 2017 2:22PM

Over the weekend, a PSU patch was applied. All seemed well, but now we cannot do RMAN backups of the database.

RMAN> connect target /

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

ORA-04063: package body "SYS.DBMS_BACKUP_RESTORE" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_BACKUP_RESTORE"

RMAN-04015: error setting target database character set to WE8ISO8859P1

That package is indeed invalid, but simply trying to recompile it does not help. The problem appears to be a mismatch between the spec and body:

LINE TEXT

---------- ----------------------------------------------------------------------------------------------------

8157 PLS-00323: subprogram or cursor 'BACKUPBACKUPPIECE' is declared in a package specification and must

Database Backup and Recovery (MOSC)