How to recover Oracle database, getting ORA-01122, ORA-01110, ORA-01207

Here is how the problem began, when starting up the database we got the following error message:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u12/oradata/evolmo/system01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile

I have re-created the controlfiles, however I cannot recover the database as the archive redo logs are no longer on disk.  

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;
ORA-00279: change 88134829 generated at 04/07/2008 09:04:52 needed for thread 1
ORA-00289: suggestion : /u3/arch/evolmo/1_289.dbf
ORA-00280: change 88134829 for thread 1 is in sequence #289


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u12/oradata/evolmo/system01.dbf'

At this point I am unable to recover the db.

I do not know how to recover the database as I do not have an export of the SYS schema.  I have nightly exports of the application schemas

Can someoine please help, I need to know the steps I would have to take to recover.
The database is in mount mode currently.  What do I do now??
kzsk31Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gatorvipCommented:
0
kzsk31Author Commented:
Thx a great article.  I tried all the suggestions, unfortunately, couldn't get past the redo log 289 which is no longer on disk.
0
dbmullenCommented:
if you have room,
      create another database,
      create the users and tablespaces (and roles)
      import the application tables from the old export.

now....
you say this:
Here is how the problem began, when starting up the database we got the following error message:
what caused the database to be down to begin with.

check these things
          select * from V$RECOVER_FILE ;
it should return either..  no rows or every rows is the same except the file#
plus...
do an ls -l on all of the datafiles
/u*/oradata/evolmo/*
do all the files have the same date?

if yes..  all is not lost yet..  you can still recover.
if no..    let the import finish and hope you can find all database links, public synonyms, and what ever else is missing.




0
kzsk31Author Commented:
DBMullen thanks for your response.  I will try it the next time.  For the time being I recreated the db and re-imported the data.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.