ORA-00279O，RA-00289，ORA-00280在recover database的时候问题解决

当进行恢复数据库执行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日志，直接输入文件名即可。