ORA-01248: file string was created in the future of
incomplete recovery



ORA-01248: file string was created in the future of incomplete recovery..

Answer / guest

Cause: Attempting to do a RESETLOGS open with a file entry
in the controlfile that was originally created after the
UNTIL time of the incomplete recovery. Allowing such an
entry may hide the version of the file that is needed at
this time. The file number may be in use for a different
file which would be lost if the RESETLOGS was allowed.

Action: If more recovery is desired then apply redo until
the creation time of the file is reached. If the file is not
wanted and the same file number is not in use at the stop
time of the recovery, then the file can be taken offline
with the FOR DROP option. Otherwise a different controlfile
is needed to allow the RESETLOGS. Another backup can be
restored and recovered, or a controlfile can be created via
CREATE CONTROLFILE.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14319: DEFAULT cannot be specified with other values

1 Answers  


RMAN-06497: WARNING: controlfile is not current, controlfile autobackup skipped

1 Answers  


ORA-14262: new subpartition name must differ from the old subpartition name

1 Answers  


RMAN-00575: timeout while trying to write to dbms_pipe

1 Answers  


PCC-00062: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  






ORA-02475: maximum cluster chain block count of string has been exceeded

1 Answers  


ORA-09874: TASDEF_READ: read error, unable to read tasdef@.dbf file.

1 Answers  


QSM-00514: the size of must-retain summaries exceeds specified space limit

1 Answers  


ORA-24392: no connection pool to associate server handle

1 Answers  


SQL*Loader-00424: table string makes illegal reference to collection field string

1 Answers  


ORA-16232: adding Logical Standby skip entry for table string.string

1 Answers  


ORA-06545: PL/SQL: compilation error - compilation aborted

1 Answers  


Categories