ORA-01200: actual file size of 25604 is smaller than correct size of 25608 blocks

Posted on 2008-11-14
Last Modified: 2012-05-05
Hi guys,

I'm getting this error when trying to startup the db:

SQL> startup
ORACLE instance started.

Total System Global Area 1962934272 bytes
Fixed Size                  2085008 bytes
Variable Size            1325404016 bytes
Database Buffers          629145600 bytes
Redo Buffers                6299648 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
ORA-01200: actual file size of 25604 is smaller than correct size of 25608
Question by:el123
    LVL 47

    Expert Comment

    Apply patch 5840434 available on the Metalink.
    LVL 4

    Expert Comment

    shutdown database and take a backup. then recreate control files.
    LVL 10

    Expert Comment

    Do you have backup? Media recovery would be the solution!!


    Accepted Solution

    Sorry guys, it was some internal issue at the o/s level, none of these solutions are workable, so need to close this question.

    Thanks for your help.

    Featured Post

    Looking for New Ways to Advertise?

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

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    trigger 5 39
    SQL Query 6 55
    Cross Outer Join 4 42
    run a PARFILE from a Windows Scheduled task - Oracle export 5 21
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now