标题: ORA-4062 During the Backup of FRA [打印本页] 作者: 刘泽宇 时间: 2023-10-15 12:50 标题: 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.