Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2008-11-14
4
Medium Priority
?
4,090 Views
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:
'/mnt/san-oracle-encrypt/u02/oradata/adtst01/system01.dbf'
ORA-01200: actual file size of 25604 is smaller than correct size of 25608
blocks
0
Comment
Question by:el123
4 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 22960962
Apply patch 5840434 available on the Metalink.
0
 
LVL 4

Expert Comment

by:iozturk
ID: 22961027
shutdown database and take a backup. then recreate control files.
0
 
LVL 10

Expert Comment

by:ravindran_eee
ID: 22968617
Do you have backup? Media recovery would be the solution!!

Thanks,
Ravi
0
 

Accepted Solution

by:
el123 earned 0 total points
ID: 22986975
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.
EL
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by 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…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

572 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