当进行恢复数据库执行recover database的时候报
SQL> recover database
ORA-00279: change 981220327 generated at 11/09/2018 19:04:07 needed for thread
1
ORA-00289: suggestion :
/u01/apps/oracle/flash_recovery_area/ORCL/archivelog/2018_11_12/o1_mf_1_23242_fy
lp52rf_.arc
ORA-00280: change 981220327 for thread 1 is in sequence #23242
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
可以通过查找利用哪个redo.log来进行恢复
select v1.group#,member, sequence#, first_change# from v$log v1, v$logfile v2 where v1.group# =v2.group#;
得到正确的redo日志,直接输入文件名即可。