暂无图片
为啥logmier挖归档日志挖出来的数据里面session_info显示为unknown
我来答
分享
王语嫣
2021-09-29
为啥logmier挖归档日志挖出来的数据里面session_info显示为unknown
暂无图片 5M

为啥logmier挖归档日志挖出来的数据里面session_info显示为unknown

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

Column USERNAME and SESSION_INFO are UNKNOWN or NULL in V$LOGMNR_CONTENTS [ID 110301.1]
You have just built the LogMiner dictionary and started LogMiner.  You query V$LOGMNR_CONTENTS expecting to see the USERNAME and SESSION_INFO for some particular redo or undo operation. However, the USERNAME field is NULL.  This is NOT a recursive operation, and the USERNAME column is expected to contain a non-null value.
Solution:=========This can result from your database parameter settings and also from the methodyou are using to mine redo logs using LogMiner.
1. Ensure that database was in minimum supplemental logging at the time that   the redo information was created.  
2. Ensure that all archive redo logs containing the necessary redo   information have been added to the LogMiner session.
1.也就是需要添加supplemental log;
sql>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; #11g建议是alter database add supplemental log data (primary key,unique index) columns;
10.2.0.1有可以ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; 时可能会报ora-600或hang住,一般启动到mount下就可解决.
STARTUP MOUNT
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE OPEN;

暂无图片 评论
暂无图片 有用 1
暂无图片
王语嫣
题主
2021-09-29
感谢
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏