exec sys.dbms_logmnr.add_logfile(LogFileName => 'F:\oracle\arch\aadbd\ARC04814.001',Options =>sys.dbms_logmnr.NEW);
exec sys.dbms_logmnr.add_logfile(LogFileName=>'F:\oracle\arch\aadbd\ARC04815.001');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'F:\oracle\arch\aadbd\ARC04816.001');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'F:\oracle\arch\aadbd\ARC04817.001');
select * from v$logmnr_logs;
exec sys.dbms_logmnr.start_logmnr(Options => sys.dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
create table t_logmnr tablespace users as select * from v$logmnr_contents;
exec sys.dbms_logmnr.end_logmnr
select t.SCN,
t.TIMESTAMP,
t.SEG_OWNER,
t.OPERATION,
t.SQL_REDO,
t.SQL_UNDO
from v$logmnr_contents t
where t.SEG_NAME = 'T';
select * from t_logmnr;
--
exec sys.dbms_logmnr.add_logfile(LogFileName => '/home/aadbdata1/aadbb/arch/arch_15720.arc',Options =>sys.dbms_logmnr.NEW);
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15721.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15722.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15723.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15724.arc');
--
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15737.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15738.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15739.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15740.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15741.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15742.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15743.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15760.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15759.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15758.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15757.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15756.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15755.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15754.arc');
--
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15724.arc');exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15725.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15726.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15727.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15728.arc');
exec sys.dbms_logmnr.add_logfile(LogFileName=>'/home/aadbdata1/aadbb/arch/arch_15729.arc');
-rw-r----- 1 oracle dba 104857088 Mar 14 03:09 arch_15760.arc
-rw-r----- 1 oracle dba 104857088 Mar 13 22:54 arch_15759.arc
-rw-r----- 1 oracle dba 104857088 Mar 13 21:11 arch_15758.arc
-rw-r----- 1 oracle dba 104857088 Mar 13 18:47 arch_15757.arc
-rw-r----- 1 oracle dba 104857088 Mar 13 13:46 arch_15756.arc
-rw-r----- 1 oracle dba 104857088 Mar 13 08:15 arch_15755.arc
-rw-r----- 1 oracle dba 104857088 Mar 13 06:07 arch_15754.arc
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8102208/viewspace-629571/ ,如需转载,请注明出处,否则将追究法律责任。