oracle logminer

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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/309902/viewspace-1060209/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/309902/viewspace-1060209/