[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ORA-01122: database file 1 failed verification check

Posted on 2012-09-14
4
Medium Priority
?
2,515 Views
Last Modified: 2012-09-26
Hi all,

I'm getting the following. Seem to be various approaches to resolving this type of error but from what I can see, system01.dbf requires a backup

I'm trying to find out if there is a backup for this system, but interested either way to know the best procedure to fix this please?

Database mounted.
  ORA-01122: database file 1 failed verification check
  ORA-01110: data file 1: '<path>/system01.dbf'
  ORA-01200: actual file size of 12396 is smaller than correct size of 52480 blocks


Thanks,
Mark
0
Comment
Question by:mgferg
  • 2
  • 2
4 Comments
 
LVL 35

Accepted Solution

by:
johnsone earned 750 total points
ID: 38398808
Restore is probably your only option.

This is just the first file that is reporting an issue.  Since it is file 1, there is a high likelihood that there are more files that have issues.

Oracle Support may have some tricks that could get you going again, but you would likely lose data.  That route should only be used if you have no backup at all.
0
 

Author Comment

by:mgferg
ID: 38419618
Thanks, apologies for delay in replying.

What exactly does the system01.dbf do? (or contain)

Does this HAVE to be restored from a backup (to fit in with the current files, assuming they're okay/recoverable)  or could we use a much older system01.dbf file that was saved after the Db was created)

Thanks
Mark
0
 
LVL 35

Expert Comment

by:johnsone
ID: 38423130
That file contains the data dictionary.

You could restore an old one, but you would either have to recover the file to its current state using archive logs or restore all files.

Oracle will not let you open the database unless all of the SCNs in all of the file headers are the same.

Like I said, that is most likely not the only file that has an issue.  That is the first file it checks (because it is listed first in the control file).  Once it finds a file with an issue it stops.  If you fix that file, it is likely that you will get the same message on another file.
0
 

Author Closing Comment

by:mgferg
ID: 38436279
Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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 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…
Suggested Courses
Course of the Month19 days, 7 hours left to enroll

872 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