数据库升级后rman备份遇到ORA-01031: insufficient privileges ORA-04045 RMAN.VPC...

刘泽宇

现象：
rman备份以及连接到rman因为以下错误而失败：

ORA-12012: error on auto execute of job "SYSMAN"."EM_TASK_WORKER_10"
ORA-04045: errors during recompilation/revalidation of RMAN.VPC_CONTEXT_TRG
ORA-01031: insufficient privileges



原因：
数据库从11.2.0.4 升级到12.2.0.1. 数据库中包含RMAN catalog


RMAN用户缺乏"ADMINISTER DATABASE TRIGGER" 权限所导致的问题：

ORA-04045: errors during recompilation/revalidation of RMAN.VPC_CONTEXT_TRG

SQL> select * from dba_sys_privs where PRIVILEGE='ADMINISTER DATABASE TRIGGER' and grantee='RMAN';

no rows selected


解决方案：
给rman用户赋予此权限：

GRANT ADMINISTER DATABASE TRIGGER to <rman_user>;

赋权后，问题解决。