ORA-39181: Only partial table data may be exported due to fine grain access control on

原创

已于 2023-11-29 17:59:25 修改 · 718 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #运维

于 2023-11-29 17:58:55 首次发布

文章描述了一次expdp全量备份过程中遇到的告警，原因是由于对ZF_MDS对象的细粒度访问控制导致部分数据无法导出。提供了两种解决方案：为备份用户授权或禁用VPD策略。

检查某个环境时发现expdp完全备份成功但有告警

Master table "USR_EXPDP"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for USR_EXPDP.SYS_EXPORT_FULL_01 is:
/backup/expdp/orcl_20231129_1629.dmp
Job "USR_EXPDP"."SYS_EXPORT_FULL_01" completed with 20 error(s) at Wed Nov 28 23:49:49 2023 elapsed 0 00:19:56

搜索ORA-关键字，发现是ORA-39181报错

ORA-39181: Only partial table data may be exported due to fine grain access control on "ZF_MDS"."ZF_ATTRIBUTES"
ORA-39181: Only partial table data may be exported due to fine grain access control on "ZF_MDS"."ZF_COMPONENTS"
ORA-39181: Only partial table data may be exported due to fine grain access control on "ZF_MDS"."ZF_DEPENDENCIES"
ORA-39181: Only partial table data may be exported due to fine g