?
Solved

database file 1 failed verification check

Posted on 2006-06-12
3
Medium Priority
?
1,801 Views
Last Modified: 2012-06-27
The file system was 100% full, and the db (8.1.7.3) was down.
When I trying to bring the db, I am getting:

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/dev/rtrain_0160_000'
ORA-01207: file is more recent than controlfile - old controlfile

How do you fix these?
0
Comment
Question by:JohnLucania
[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
3 Comments
 
LVL 8

Assisted Solution

by:gvsbnarayana
gvsbnarayana earned 600 total points
ID: 16886426
Hi,
  I understand that a recovery should be done on this database.
Make sure that you have sufficient space on the disks of Control file and then recover the database using backup control file clause.
HTH.
Regards,
Badri.
0
 
LVL 19

Accepted Solution

by:
actonwang earned 1400 total points
ID: 16886447
Use the current control file or do BACKUP CONTROLFILE RECOVERY.

you might need to do:

 recover [until cancel]  using backup controlfile

to make your control file current.

0
 
LVL 19

Expert Comment

by:actonwang
ID: 16886500
make sure you have all online redo logs available.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

762 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