ORA-01356: active logminer sessions found ORACLE 报错 故障修复 远程处理

文档解释

ORA-01356: active logminer sessions found

Cause: Logminer sessions are currently active.

Action: End all logminer sessions and retry.

ORA-01356错误是由oracle数据库的LogMiner功能引起的，它表示仍然有活动的LogMiner会话与基础架构仍处于初始化状态，而初始化尚未完成。

官方解释

ORA-01356: active logminer sessions found

Cause: Some LogMiner sessions are still active while LogMiner was being initialized.

Action: Commit or rollback the transactions from all active LogMiner sessions and retry.

常见案例

一般情况下，当开发人员尝试初始化LogMiner时，就会发生这种情况。

正常处理方法及步骤

1. 首先，查找所有活动的LogMiner会话：

select sid, serial# from v$session

where program like ‘%LogMiner%’;

2. 关闭此会话：

alter system kill session ‘SID,Serial#’;

3. 再次初始化LogMiner：

begin

dbms_logmnr.add_logfile();

dbms_logmnr.start_logmnr(

options=>dbms_logmnr.dict_from_online_catalog);

end;

/