我是靠谱客的博主 靓丽黑夜,最近开发中收集的这篇文章主要介绍oracle 00283,oracle数据库恢复报ORA-00283,ORA-01610错误原因,觉得挺不错的,现在分享给大家,希望可以做个参考。

概述

可能很多人在做数据库恢复时,都遇到过如下错误:

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

thread 1

ORA-00289: suggestion : /archlog/recovertest1/recovertest1_48089_863551860.arc

ORA-00280: change 314215629614 for thread 1 is in sequence #48089

Specify log: {=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.1

Error: 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.1

Error: 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)

最后

以上就是靓丽黑夜为你收集整理的oracle 00283,oracle数据库恢复报ORA-00283,ORA-01610错误原因的全部内容,希望文章能够帮你解决oracle 00283,oracle数据库恢复报ORA-00283,ORA-01610错误原因所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错,欢迎将靠谱客网站推荐给程序员好友。

本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
点赞(60)

评论列表共有 0 条评论

立即
投稿
返回
顶部