Solved

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

Posted on 2008-10-31
5
10,430 Views
Last Modified: 2013-12-19
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??
0
Comment
Question by:kzsk31
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 250 total points
ID: 22853562
0
 

Author Comment

by:kzsk31
ID: 22853740
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
 
LVL 10

Assisted Solution

by:dbmullen
dbmullen earned 250 total points
ID: 22854972
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
 

Accepted Solution

by:
kzsk31 earned 0 total points
ID: 23134850
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

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question