Ora-01248:file N is created in the future of incomplete recovery error

Database status

Control File
Controlling data file information in a file
Data File header information
Redo Information

Based on the information gathered by the current database recovery check script (Oracle database Recovery check), the database is not archived and redo has been overwritten, and database DataFile 5 cannot be directly online. In this case, You can use bbed to modify the file head SCN to implement online (use bbed to make the Sysaux data file online in RAC), or you can use the _allow_resetlogs_ Corruption and other hidden parameters to achieve online. In this recovery case, there are 180 data files, 160 offline, and then the open database, so a large number of data files do not work properly online,bbed too much work. Unfortunately, during the recovery process ORA-01248

ORA-01248 error occurred in database Resetlogs

The code is as follows

sql> ALTER DATABASE open resetlogs; ALTER DATABASE open Resetlogs * ERROR at line 1: Ora-01248:file 5 is created in the future of incomplete recovery Ora-01110:data file 5: ' F:/ttdata/pubrts. DAT ' Alert Log Record Fri Oct 10 15:09:26 2014 ALTER DATABASE open Resetlogs Fri Oct 10 15:09:26 2014 Resetlogs is being done without consistancy checks. This could result In a corrupted database. The database should be recreated. ORA-1248 signalled during:alter database open resetlogs ... Fri Oct 10 15:15:22 2014 ALTER DATABASE Open Fri Oct 10 15:15:22 2014 ORA-1589 signalled during:alter database open ... Fri Oct 10 15:15:30 2014 ALTER DATABASE open Resetlogs Resetlogs is being done without consistancy checks. This could result In a corrupted database. The database should be recreated. ORA-1248 signalled during:alter database open resetlogs ... Try offline file and Resetlogs Sql>alter DATABASE datafile 5 OFFLINE; Database altered. Sql>alter DATABASE OPEN resetlogs; ERROR at line 1: Ora-01245:ffline file 5 would be lost if Resetlogs was done Ora-01110:data file 5: ' F:/ttdata/pubrts. DAT ' Alert Log Fri Oct 10 15:19:37 2014 ALTER DATABASE datafile 5 offline Fri Oct 10 15:19:37 2014 Completed:alter DATABASE datafile 5 offline Fri Oct 10 15:19:40 2014 ALTER DATABASE open Resetlogs Resetlogs is being done without consistancy checks. This could result In a corrupted database. The database should be recreated. ORA-1245 signalled during:alter database open resetlogs ... This error occurs because the database is not in archive mode and the offline data file requires the use of offline drop Fri Oct 10 15:22:16 2014 ALTER DATABASE datafile 5 offline drop Fri Oct 10 15:22:17 2014 Completed:alter database datafile 5 offline drop Fri Oct 10 15:23:13 2014 ALTER DATABASE open Resetlogs Fri Oct 10 15:23:14 2014 Fri Oct 10 15:23:49 2014 Resetlogs after complete recovery through change 1422423346 Resetting resetlogs activation ID 3503292347 (0XD0CFFFBB) Fri Oct 10 15:24:01 2014 Setting recovery target incarnation to 3 Fri Oct 10 15:24:04 2014 assigning activation ID 3649065262 (0xd980512e) Lgwr:starting ARCH Processes ARC0 started with pid=23, OS id=3772 Fri Oct 10 15:24:04 2014 Arc0:archival started Arc1:archival started Lgwr:starting ARCH Processes COMPLETE ARC1 started with pid=24, OS id=3668 Fri Oct 10 15:24:05 2014 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0:d:/oracle/product/10.2.0/oradata/clttdb/redo01. LOG Successful open of Redo thread 1 Fri Oct 10 15:24:05 2014 MTTR advisory is disabled because fast_start_mttr_target are not set Fri Oct 10 15:24:05 2014 Arc0:starting ARCH Processes Arc2:archival started Arc0:starting ARCH Processes COMPLETE Arc0:becoming the ' no FAL ' ARCH ARC2 started with pid=25, OS id=636 Fri Oct 10 15:24:06 2014 Arc0:becoming the ' no SRL ' ARCH Fri Oct 10 15:24:06 2014 Arc1:becoming the Heartbeat ARCH Fri Oct 10 15:24:06 2014 Smon:enabling Cache Recovery Fri Oct 10 15:24:07 2014 Successfully onlined Undo tablespace 1. Dictionary Check Beginning The File #5 is offline, but are part of the online tablespace. Data file 5: ' F:/ttdata/pubrts. DAT ' Dictionary Check Complete Fri Oct 10 15:24:19 2014 smon:enabling TX Recovery Fri Oct 10 15:24:19 2014 Database Characterset is ZHS16GBK Replication_dependency_tracking turned off (no async multimaster replication found) Starting background Process QMNC QMNC started with pid=26, OS id=868 Fri Oct 10 15:24:21 2014 Logstdby:validating Controlfile with logical metadata Fri Oct 10 15:24:21 2014 Logstdby:validation Complete Completed:alter Database Open Resetlogs Open successfully, resetlogs the library again, realize the data file online Fri Oct 10 15:28:44 2014 ALTER DATABASE datafile 5 Online Fri Oct 10 15:28:44 2014 Completed:alter DATABASE datafile 5 Online Fri Oct 10 15:31:46 2014 ALTER DATABASE open Resetlogs Fri Oct 10 15:31:46 2014 Resetlogs is being done without consistancy checks. This could result In a corrupted database. The database should be recreated. Setting recovery target incarnation to 4 Fri Oct 10 15:32:00 2014 assigning activation ID 3649091231 (0xd980b69f) Lgwr:starting ARCH Processes ARC0 started with pid=23, OS id=700 Fri Oct 10 15:32:00 2014 Arc0:archival started Arc1:archival started Lgwr:starting ARCH Processes COMPLETE ARC1 started with pid=24, OS id=3360 Fri Oct 10 15:32:01 2014 Thread 1 opened at log sequence 1 Current log# 1 seq# 1 mem# 0:d:/oracle/product/10.2.0/oradata/clttdb/redo01. LOG Successful open of Redo thread 1 Fri Oct 10 15:32:01 2014 MTTR advisory is disabled because fast_start_mttr_target are not set Fri Oct 10 15:32:01 2014 Arc0:starting ARCH Processes Arc2:archival started Arc0:starting ARCH Processes COMPLETE Arc0:becoming the ' no FAL ' ARCH ARC2 started with pid=25, OS id=2016 Fri Oct 10 15:32:02 2014 Arc0:becoming the ' no SRL ' ARCH Fri Oct 10 15:32:02 2014 Arc1:becoming the Heartbeat ARCH Fri Oct 10 15:32:02 2014 Smon:enabling Cache Recovery Fri Oct 10 15:32:03 2014 Successfully onlined Undo tablespace 1. Dictionary Check Beginning Fri Oct 10 15:32:15 2014 Dictionary Check Complete Fri Oct 10 15:32:15 2014 smon:enabling TX Recovery Fri Oct 10 15:32:15 2014 Database Characterset is ZHS16GBK Replication_dependency_tracking turned off (no async multimaster replication found) Starting background Process QMNC QMNC started with pid=26, OS id=256 Fri Oct 10 15:32:17 2014 Logstdby:validating Controlfile with logical metadata Fri Oct 10 15:32:17 2014 Logstdby:validation Complete Completed:alter Database Open Resetlogs

Link: http://www.xifenfei.com/5539.html