oracle 突然产出大量归档日志导致磁盘空间满了

查看是什么在写归档：

@?/rdbms/admin/dbmslm.sql;
@?/rdbms/admin/dbmslmd.sql;
--执行要分析的归档日志
exec sys.dbms_logmnr.add_logfile(logfilename => ‘/dbfile/archivelog/1_607438_963928319.arc‘,options => dbms_logmnr.new);
exec sys.dbms_logmnr.start_logmnr(options => sys.dbms_logmnr.dict_from_online_catalog);
--查询 归档日志的内容
select seg_owner,count(*) from v$logmnr_contents group by seg_owner;
select count(1),substr(sql_redo,1,60) from v$logmnr_contents group by substr(sql_redo,1,60) order by count(1) desc ;
--增加别的日志文件
exec sys.dbms_logmnr.add_logfile(logfilename=>‘/dbfile/archivelog/1_607439_963928319.arc‘);

将记录写入临时表
create table logmnr_tab as select * from V$LOGMNR_CONTENTS;

--结束分析归档日志
exec sys.dbms_logmnr.end_logmnr;