查询出现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;
-
打开数据库
ALTER DATABASE OPEN;
-
ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME ADJUST_SCN LEVEL 1';
-
SHUTDOWN IMMEDIATE
-
STARTUP MOUNT
-
SELECT TS#,FILE#,NAME,STATUS,CHECKPOINT_CHANGE# FROM V$DATAFILE;
-
RECOVER UNTIL CANCEL;
-
ALTER DATABASE DATAFILE 6 ONLINE;
-
ALTER DATABASE OPEN RESETLOGS;