oracle 错误01190,关机导致Oracle数据库启动失败,报错ora 01190 01110

天萃荷净

用户现场服务器掉电关闭，导致Oracle数据库无法启动，alter日志文件报错ora 01190 01110

事故现场故障模拟：

一、模拟offline文件然后resetlogs操作

1.设置datafile 5数据文件offline

2.rman备份数据库

3.关闭原数据库，删除数据文件/当前日志和部分归档日志

4.执行不完全恢复，resetlogs打开数据库(如下面操作)

[oracle@xifenfei ora11g]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 15 07:36:59 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>recover database until cancel;

ORA-00279: change 868870 generated at 03/15/2012 03:32:11 needed for thread 1

ORA-00289: suggestion :

/u01/oracle/oradata/archivelog/ora11g/1_29_777766629.dbf

ORA-00280: change 868870 for thread 1 is