oracle logmnr 使用[@more@]

logminer oracle的小工具

logminer從redologfile裡讀取資訊到v$logmnr_contents，然後根據scn做不完全恢復。這樣恢復會導致該scn後發生的變化全部丟失。一般在

步驟：

1.建立/logmnr目錄，賦許可權

mkdir /logmnr chown -R oracle:dba /logmnr

2.備份資料庫

backup database

3.修改資料庫引數

modify spfile --alter system set utl_file_dir='/logmnr' scope=spfile sid='*';

restart database

模擬誤操作

switch logfile

4.使用logmnr

4.1.execute dbms_logmnr_d.build(dictionary_filename=>'dictionary.ora',dictionary_location=>'/logmnr');

4.2.commit;

4.3.begin

dbms_logmnr.add_logfile(logfilename=>'/arch/1_8_805784898.dbf',options=>dbms_logmnr.new);

end;

/

4.4.select * from v$logmnr_logs;

4.5.execute dbms_logmnr.start_logmnr(dictfilename=>'/logmnr/dictionary.ora');

4.6.select * from v$logmnr_contents where operation='DDL'; --找到drop操作的scn

5.incomplete recover database

5.1.shutdown immediate

5.2.startup mount

5.3.rman

RMAN> run {

2> allocate channel d1 device type disk;

3> set until scn 66250;

4> restore database;

5> recover database;

6> }

5.4.alter database open resetlogs;

Oracle LogMiner

相關文章