基于日志挖掘的误操作不完全恢复思路(三)
1 1 9 52428800 512 1 YES
INACTIVE 1089570 31-JUL-13 1089575 31-JUL-13
2 1 10 52428800 512 1 NO
CURRENT 1089575 31-JUL-13 2.8147E+14
3 1 7 52428800 512 1 YES
INACTIVE 1089560 31-JUL-13 1089565 31-JUL-13
4 1 8 52428800 512 1 YES
INACTIVE 1089565 31-JUL-13 1089570 31-JUL-13
select * from v$logfile
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 ONLINE
/u01/app/oracle/oradata/mdnss/redo03.log
NO
2 ONLINE
/u01/app/oracle/oradata/mdnss/redo02.log
NO
所以在应用完所有归档日志文件之前 来试用输入在线日志 就 可以恢复到对应的SCN状态点
Specify log: {
=suggested | filename | AUTO | CANCEL}
/u01/app/oracle/oradata/mdnss/redo02.log
Log applied.
Media recovery complete.
Specify log: {=suggested | filename | AUTO | CANCEL}
/u01/app/oracle/oradata/mdnss/redo02.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
误删除的表已经回来了
SQL> select count(*) from scott.daodao;
COUNT(*)
----------
0