Link to home
Start Free TrialLog in
Avatar of kzsk31
kzsk31Flag for Canada

asked on

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??
SOLUTION
Avatar of gatorvip
gatorvip
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kzsk31

ASKER

Thx a great article.  I tried all the suggestions, unfortunately, couldn't get past the redo log 289 which is no longer on disk.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial