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-32316: REFRESH FAST of "string"."string" unsupported after mixed DML

1 Answers  


ORA-32335: dimension must have at least one level

1 Answers  


ORA-29280: invalid directory path

1 Answers  


TNS-12531: TNS:cannot allocate memory

1 Answers  


ORA-27045: unable to close the file

1 Answers   Aomi,






ORA-12631: Username retrieval failed

2 Answers  


ORA-01343: LogMiner encountered corruption in the logstream

1 Answers  


ORA-13278: failure to convert SRID to native format

1 Answers  


ORA-13187: subdivision failed

1 Answers  


ORA-26718: transaction limit reached

1 Answers  


ORA-09959: IMON: deletion of a process failed.

1 Answers  


LPX-00115: element "~1S" is missing required attribute "~2S"

1 Answers  


Categories