ORA-4062 During the Backup of FRA

刘泽宇

现象：
The backup of the recovery area is failing with the following error :

RMAN>  BACKUP RECOVERY AREA to destination '/<path>/';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 03/31/2015 14:39:42                                                            
ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed

This error is being reported only in the databases created with DBCA.

原因：
The DBCA is not recompiling objects which is required after database creation and/or patch is applied.  

处理方法：
Run scripts, such as catproc.sql, manually as sys user.

Ensure the script(catproc) is run with db started in Startup restrict or Startup upgrade mode

SQL> connect sys/<password> as sysdba

SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

or run the datapatch as is recommended in Note: 1585822.1.   Datapatch is the patching tool to complete the post-patch SQL actions for RDBMS Patches.