Q
Problem solve Get help with specific problems with your technologies, process and projects.

Database starts and mounts but doesn't open

I had to do an install in order to work on my Oracle application. I basically had created a database OCTRN a month back. I also have a repository of the database but not sure why. When I tried to automatically start , mount and open the database, I get an error. 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 have a problem with my Oracle 9i database on Win2k Server. While I am not a DBA, I had to do an install in order to work on my Oracle application. I basically had created a database OCTRN a month back. I also have a repository of the database but not sure why. When I tried to automatically start , mount and open the database, I get an error saying:
ORA-01122: database file 11 failed verification check
ORA-01110: datafile 'F:opapps45OCTRNOCL_APP.DBF'
ORA-01207: file is more recent than controlfile - old controlfile
How 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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close