Solved

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

Posted on 2008-10-31
5
10,273 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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 …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

816 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now