rman恢复后，在做recover database的时候，出现ORA-01547、ORA-01994错误，错误信息如下：

SQL> recover database until cancel;
ORA-00279: change 548207 generated at 11/28/2009 10:25:46 needed for thread 1
ORA-00289: suggestion :
/oracle/flash_recovery_area/ORCL/archivelog/2009_11_30/o1_mf_1_1_%u_.arc
ORA-00280: change 548207 for thread 1 is in sequence #1

Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oradata/orcl/system01.dbf'

ORA-01112: media recovery not started

[@more@]

尝试使用resetlog方式启动数据库，报如下ORA-01194错误:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oradata/orcl/system01.dbf'

尝试使用noresetlogs方式启动数据库，报ORA-01113错误，确定datafile 2需要media recovery

SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/oracle/oradata/orcl/undotbs01.dbf'

对datafile 2进行recover之后，启动数据库，数据库启动正常。

SQL> alter database recover datafile 2;

Database altered.

SQL> alter database open;

Database altered.

SQL>

ITPub博客

ORA-01547、ORA-01994错误解决一例

最新文章