ORA-00283: recovery session canceled due
file 2 failed verification
ORA-01110: data file 2:
more recent than control file - old control file
How Oracle judge file is more recent than control file - old control file, then it thrown out error ora-01207.
It must compare data file with control file, but what compare?
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 )