在做数据库恢复时，都遇到过如下错误：
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
对于这个错误的处理方法很简单，相信大家都知道：(只要加上using backup controlfile就可以)
SQL> recover database using backup controlfile;
ORA-00279: change 314215629614 generated at 04/25/2015 12:50:28 needed for
hread 1
ORA-00289: suggestion : /archlog/recovertest1/recovertest1_48089_863551860.arc
ORA-00280: change 314215629614 for thread 1 is in sequence #48089
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
但是为什么会报这样的错误呢？下面我们就来说一下导致恢复时报ORA-00283，ORA-01610错误的原因
Error Text, Cause and Action from Message File/s for ORA-01610
Versions 10.2, 11.1, 11.2, 12.1Error: ORA-01610 recovery using the BACKUP CONTROLFILE option must be done
---------------------------------------------------------------------------Cause: Either an earlier database recovery session specified BACKUP
CONTROLFILE, or the control file was recreated with the RESETLOGS
option, or the control file being used is a backup control file. After
that only BACKUP CONTROLFILE recovery is allowed and it must be
followed by a log reset at the next database open.
>>>>>导致恢复报ORA-01610的原因有 ：
1.如果你在一次恢复中先是使用了recover database using backup controlfile命令，
那么再一次执行recover database时必须也加上backup controlfile
2.你所恢复的数据库曾经被resetlogs打开过
3.你恢复使用的控制文件比恢复出来的数据文件要老(比如你restore的控制文件是5月10号的，restore的数据文件是5月10号之后的)
Action: Perform recovery using the BACKUP CONTROFILE option.
Versions 9.2, 10.1Error: ORA-01610 recovery using the BACKUP CONTROLFILE option must be done
Cause: Either an earlier database recovery session specified BACKUP
CONTROLFILE, or the controlfile was recreated with the RESETLOGS
option, or the controlfile being used is a backup controlfile. After
that only BACKUP CONTROLFILE recovery is allowed and it must be
followed by a log reset at the next database open.
Action: Perform recovery using the BACKUP CONTROFILE option.
##上面这段截取自MOS的解释很清楚的说明了导致恢复时报ORA-01610的原因。
详情可参考 OERR: ORA-1610 "recovery using the BACKUP CONTROLFILE option must be done" Reference Note (Doc ID 19007.1)