Oracle datafile error codes/messages

The datafile is the largest pysical storage unit of the Oracle database.

When add datafiles ,drop datafiles ,resize datafiles ,extend datafiles,you may issue errors about datafile.

Hope following datafile errors help you solve problems.

 

ORA-00295 datafile/tempfile number string is invalid, must be between 1 and string

ORA-00296 maximum number of files (string) exceeded for RECOVER DATAFILE LIST

ORA-00297 must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START

ORA-00393 log string of thread string is needed for recovery of offline datafiles

ORA-01165 MAXDATAFILES may not exceed string

ORA-01169 DATAFILE number 1 not found. Must be present

ORA-01171 datafile string going offline due to error advancing checkpoint

ORA-01180 can not create datafile 1

ORA-01237 cannot extend datafile string

ORA-01238 cannot shrink datafile string

ORA-01244 unnamed datafile(s) added to controlfile by media recovery

ORA-01259 unable to delete datafile string

ORA-01274 cannot add datafile ‘string’ – file could not be created

ORA-01516 nonexistent log file, datafile, or tempfile “string”

ORA-01670 new datafile string needed for standby database recovery

ORA-01904 DATAFILE keyword expected

ORA-02162 invalid value for MAXDATAFILES

ORA-02164 DATAFILE clause specified more than once

ORA-02199 missing DATAFILE/TEMPFILE clause

ORA-03280 invalid DATAFILE filename specified

ORA-03283 specified datafile string does not exist

ORA-03284 datafile string is not a member of tablespace string

ORA-03296 cannot resize datafile – file string not found

ORA-03298 cannot shrink datafile – file string is under hot backup

ORA-07345 The datafile name must not contain the string ‘..’.

ORA-10575 Give up restoring recovered datafiles to consistent state: out of memory

ORA-10576 Give up restoring recovered datafiles to consistent state: some error occurred

ORA-10580 Can not modify datafile header during test recovery

ORA-16133 Datafile string has incorrect terminal recovery stamp.

ORA-19573 cannot obtain string enqueue for datafile string

ORA-19576 datafile string not defined in control file

ORA-19593 datafile number string already included as string

ORA-19612 datafile string not restored due to string

ORA-19613 datafile string not found in backup set

ORA-19640 datafile checkpoint is SCN string time string

ORA-19641 backup datafile checkpoint is SCN string time string

ORA-19643 datafile string: incremental-start SCN is too recent

ORA-19644 datafile string: incremental-start SCN is prior to resetlogs SCN string

ORA-19645 datafile string: incremental-start SCN is prior to creation SCN string

ORA-19646 cannot change size of datafile string from string to string

ORA-19648 datafile string: incremental-start SCN equals checkpoint SCN

ORA-19651 cannot apply offline-range record to datafile string: SCN mismatch

ORA-19652 cannot apply offline-range record to datafile string: file is fuzzy

ORA-19657 cannot inspect current datafile string

ORA-19661 datafile string could not be verified

ORA-19663 cannot apply current offline range to datafile string

ORA-19667 cannot do incremental restore of datafile string

ORA-19668 cannot do full restore of datafile string

ORA-19721 Cannot find datafile with absolute file number string in tablespace string

ORA-19722 datafile string is an incorrect version

ORA-19723 Cannot recreate plugged in read-only datafile string

ORA-19729 File string is not the initial version of the plugged in datafile

ORA-19730 can not convert offline plugged-in datafile string

ORA-19731 cannot apply change to unverified plugged-in datafile string

ORA-19732 incorrect number of datafiles for tablespace string

ORA-19734 wrong creation SCN – control file expects converted plugged-in datafile

ORA-19735 wrong creation SCN – control file expects initial plugged-in datafile

ORA-25114 invalid file number specified in the DUMP DATAFILE/TEMPFILE command

ORA-25116 invalid block number specified in the DUMP DATAFILE/TEMPFILE command

ORA-25118 invalid DUMP DATAFILE/TEMPFILE option

ORA-29306 datafile string is not online

ORA-29307 datafile string error, string

ORA-29316 datafile string been imported twice

ORA-29317 datafile string does not exist

ORA-29318 datafile string is online

ORA-29319 datafile string is not correct

ORA-29320 datafile header error

ORA-29321 too many datafiles added since the point-in-time

ORA-29328 too many datafiles in this tablespace ‘string’

ORA-29338 datafile string is in an undesired state (string, string)

ORA-29348 You must specify the datafiles to be plugged in