Solved

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

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle query help 29 77
Convert Oracle data into XML document 2 59
case statement in where clause with not exist 15 46
How to connect SQL Server from my Oracle database? 11 72
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

896 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

17 Experts available now in Live!

Get 1:1 Help Now