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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
kzsk31Connect With a Mentor Author 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
 
gatorvipConnect With a Mentor Commented:
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
 
dbmullenConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.