Begin from the beginning.
Did you do a RESTORE DATABASE ?
Or did you selectively restore datafiles ?
Strange datafile name --- looks like it could have been a DATAFILECOPY done using rman.
It is a very bad idea to have a datafile in /tmp On some OSs, /tmp may get cleared of files on a reboot.
Hemant K Chitale
Hi, HemantKChitale. I mean that it thrown out error ora-01207 through comparing data file with controlfile, but i don't know what it would be compared? checkpoint_change# or others? Please tell me something. I think it's not important whether it's RESTORE DATABASE or RESTORE DATAFILES.(Maybe I'm wrong )
It compares the checkpoint number on the datafile header with the checkpoint number in the controlfile.
It checks the scn of controlfile to the datafile.