alter system set UTL_FILE_DIR='*' scope=spfile;
startup force
BEGIN
dbms_logmnr_d.build(dictionary_filename=>'dict.ora',dictionary_location=>'/orabak/0329');
END;
/
create table test.t_logmnr_contents as select * from v$logmnr_contents where 1=2;
--下面好像不用啊
sqlplus “/ as sysdba”
shutdown immediate
startup mount
BEGIN
dbms_logmnr.add_logfile(options=>dbms_logmnr.new
,logfilename=>'/orabak/0329/1_46967.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46966.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46965.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46964.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46963.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46962.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46961.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46960.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46959.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46958.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46957.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46956.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46955.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46954.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46953.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46952.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46951.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46950.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46949.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46948.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46947.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46946.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46945.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46944.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46943.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46942.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46941.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46940.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46939.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46938.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46937.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46936.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46935.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46934.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46933.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46932.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46931.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46930.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46929.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46928.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46927.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46926.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46925.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46924.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46923.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46922.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46921.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46920.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46919.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46918.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46917.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46916.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46915.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46914.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46913.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46912.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46911.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46910.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46909.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46908.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46907.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46906.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46905.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46904.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46903.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46902.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46901.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46900.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46899.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46898.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46897.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46896.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46895.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46894.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46893.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46892.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46891.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46890.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46889.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46888.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46887.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46886.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46885.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46884.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46883.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46882.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46881.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46880.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46879.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46878.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46877.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46876.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46875.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46874.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46873.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46872.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46871.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46870.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46869.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46868.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46867.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46866.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46865.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46864.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46863.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46862.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46861.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46860.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46859.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46858.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46857.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46856.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46855.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46854.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46853.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46852.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46851.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46850.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46849.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46848.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46847.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46846.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46845.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46844.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46843.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46842.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46841.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46840.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46839.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46838.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46837.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46836.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46835.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46834.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46833.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46832.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46831.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46830.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46829.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46828.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46827.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46826.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46825.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46824.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46823.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46822.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46821.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46820.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46819.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46818.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46817.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46816.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46815.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46814.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46813.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46812.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46811.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46810.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46809.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46808.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46807.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46806.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46805.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46804.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46803.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46802.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46801.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46800.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46799.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46798.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46797.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46796.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46795.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46794.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46793.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46792.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46791.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46790.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46789.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46788.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46787.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46786.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46785.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46784.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46783.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46782.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46781.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46780.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46779.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46778.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46777.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46776.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46775.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46774.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46773.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46772.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46771.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46770.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46769.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46768.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46767.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46766.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46765.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46764.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46763.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46762.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46761.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46760.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46759.dbf');
dbms_logmnr.add_logfile(options=>dbms_logmnr.addfile ,logfilename=>'/orabak/0329/1_46758.dbf');
END;
/
set line 4000
col filename for a25
col info for a5
select * from v$logmnr_logs;
BEGIN
dbms_logmnr.start_logmnr(
dictfilename=>'/orabak/0329/dict.ora',
starttime=>to_date('2018-03-29:08:58:00','YYYY-MM-DD:HH24:MI:SS'),
endtime=>to_date('2018-04-29:01:12:00','YYYY-MM-DD:HH24:MI:SS'));
END;
/
execute dbms_logmnr.start_logmnr(dictfilename =>'F:/ORACLE/ORA90/LOGMINER/sqltrace.ora'）
alter database open
create table test.t_logmnr_contents as select * from v$logmnr_contents where 1=2;
insert into test.t_logmnr_contents20180329
select * from v$logmnr_contents where seg_owner='LZSI' and seg_name ='KC21' and sql_redo like '%081726%';
SELECT timestamp,sql_redo FROM v$logmnr_contents WHERE sql_redo like '%create%';
execute dbms_logmnr.end_logmnr;
七、与LogMiner相关的数据字典
1、v$loglist 它用于显示历史日志文件的一些信息
2、v$logmnr_dictionary 因logmnr可以有多个字典文件，该视图用于显示这方面信息
3、v$logmnr_parameters 它用于显示logmnr的参数
4、v$logmnr_logs 它用于显示用于分析的日志列表信息