oracle查询报错ORA-01190

查询出现ORA-01190记录
1.先查询STATUS是不是ONLINE，OFFLINE是脱机，数据文件丢失或 RECOVER状态,就要执行恢复,然后再online

	SELECT TS#,FILE#,NAME,STATUS,CHECKPOINT_CHANGE# FROM V$DATAFILE;

2.修改文件状态为ONLINE

	ALTER DATABASE DATAFILE  2  ONLINE;

3.提示报错

	ORA-01190: 控制文件或数据文件2来自于最后一个 RESETLOGS 之前
	ORA-01110: 数据文件 2: 'E:\ORACLE9I\ORA9I\UNDOTBS01.DBF'

4.需要设置_allow_resetlogs_corruption参数

   ALTER SYSTEM SET "_allow_resetlogs_corruption"=TRUE SCOPE=SPFILE;

5.关闭数据库

   SHUTDOWN IMMEDIATE

6.开MOUNT

   STARTUP MOUNT;

7. 打开数据库

    	ALTER DATABASE OPEN;
   

8. 	ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME     ADJUST_SCN LEVEL 1';
   

9. 	SHUTDOWN IMMEDIATE
   

10. 	STARTUP MOUNT
    

11. 	SELECT TS#,FILE#,NAME,STATUS,CHECKPOINT_CHANGE# FROM V$DATAFILE; 
    

12. 	RECOVER UNTIL CANCEL;
    

13. 	ALTER DATABASE DATAFILE  6  ONLINE;
    

14. 	ALTER DATABASE OPEN RESETLOGS;