ORA-01122: database file 1 failed verification check

Posted on 2012-09-14
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

Question by:mgferg
    LVL 34

    Accepted Solution

    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.

    Author Comment

    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)

    LVL 34

    Expert Comment

    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.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    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 post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    759 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

    7 Experts available now in Live!

    Get 1:1 Help Now