ORA-01356: active logminer sessions found

文档解释

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;

/

你可能感兴趣的