There is one question in the Oracle Testing software
Evaluate this error message generated by the Oracle Server when you attempt to perform a recovery operation:
svrmgr> alter database open;
ORA-00283: Recovery session canceled due to errors
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/user_data/db02/u01/sys01.dbf'
ORA-01207: file is more recent than control file - old control file
Which must be done to alleviate this error?
To receive this error, you restored the datafiles and attempted to open the database with the current control file rather than the backup. The files are not synchronized and the database will not open. To recover from this error, restore the backup control file. Using the backup control file, recover the database. Open the database with the RESETLOGS option.
Isnt the error message ORA-01207: file is more recent than control file - old control file misleading. It says that the control file is old , this mean that you should you a newer control file. But the answer says use the control file from the backup.
Can somebody explain me why and what exactly is happenning at the back so that I can understand the question and answer better.
The control file is created prior to the system file or the changes must be recorded, if not this error shoots up. Now the problem is quite obvious that the changes made to the system file is not recorded in the controlfile. So restore the appropriate system file to proceed further
A Winner never Quits, A Quitter never Wins