ORA-01122: database file 11 failed verification check ORA-01110: datafile 'F:opapps45OCTRNOCL_APP.DBF' ORA-01207: file is more recent than controlfile - old controlfileHow can I solve this problem and start my database? Right now, it only starts and mounts but does not open. I don't have a backup but I have some ARCHIVE log files in the homerdbms directory. I'd appreciate if someone could tell me the best way I can recover this or resolve this issue. I don't mind if I have to drop the datafile and re-create it. When I typed ALTER database datafile 'F:opapps45octrnocl_app.dbf' offline; it gave me "ORA-01516: nonexistent log file, datafile or tempfile 'F:opapps45octrnocl_app.dbf'."
For some reason, your control file is an old control file. If you have a more current control file, then you might want to copy that current control file over the old control file.
Otherwise, you'll have to perform a recovery operation using the old controlfile. You can use the following steps:
STARTUP MOUNT RECOVER DATABASE USING BACKUP CONTROLFILE;
When prompted for the log, specify AUTO. When you receive "media recovery complete," issue the following:
ALTER DATABASE OPEN RESETLOGS;
At this poiont, you should shut down the database and take a backup.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.