logmnr 不完全恢复数据库

logminer 分析oracle日志 redo log
rman 执行脚本：rman cmdfile=/oracle/common/backupdb/backup.rcv log=/oracle/common/backupdb/rman.log append
1.备份数据库
2.修改spfile:   alter system set utl_file_dir='/logmnr' scope=spfile;
3.创建数据字典: execute dbms_logmnr_d.build(dictionary_filename=>'dictionary.ora',dictionary_location=>'/oracle');
4.select * from v$logmnr.logs;
5.执行存储过程: execute dbms_logmnr.startlogmnr(dictfilename='/oracle/dictionary.ora');
6.select * from v$logmnr_contents;
7.create table logmnr_ramon as select * from v$logmnr_contents;
8.找到SCN,利用rman恢复数据库