暂无图片
oracle 19c 怎么给pdb做logminer
我来答
分享
暂无图片 匿名用户
oracle 19c 怎么给pdb做logminer
暂无图片 5M

参考了一个12c的样例
https://ezdba.wordpress.com/2016/05/17/logminer-pluggable-database/

在19.23做以下操作还是报错:

SQL> alter session set container=pdb1;

Session altered.

SQL> create directory scripts as '/home/oracle/dba/scripts';

Directory created.

SQL>
SQL> exec dbms_logmnr_d.build('minerPDB1.dic', 'SCRIPTS', dbms_logmnr_d.store_in_flat_file);
BEGIN dbms_logmnr_d.build('minerPDB1.dic', 'SCRIPTS', dbms_logmnr_d.store_in_flat_file); END;

*
ERROR at line 1:
ORA-29282: invalid file ID
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8660
ORA-06512: at "SYS.UTL_FILE", line 1160
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8185
ORA-65040: operation not allowed from within a pluggable database
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8065
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8608
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8674
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 8822
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 55
ORA-06512: at line 1


请问19c怎么用logminer抓取pdb的信息,最好给个样例或者有样例的链接

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
风云飘

我自己来结束问题吧,参考MOS(Doc ID 2782791.1),该方式在19c已经不支持

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏