OraFAQ Forum: Backup & Recovery » oracle error ORA-01200

Home » RDBMS Server » Backup & Recovery » oracle error ORA-01200

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle error ORA-01200 [message #173369]

Mon, 22 May 2006 02:34

shivnagpal
Messages: 5
Registered: May 2006
Location: DELHI

Junior Member

i have database in oracle 8.1.6
when i mount database by login to sql as sysdba below given error occur
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\COM0506\SYSTEM01.DBF'
ORA-01200: actual file size of 10151 is smaller than correct size of 10164 blocks

i used the recovery
it show media recovery completed
but same error occur on opening database
plz help me on this topic

Report message to a moderator

Re: oracle error ORA-01200 [message #173379 is a reply to message #173369]

Mon, 22 May 2006 03:40

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try to restore the file from backup again:

oerr ora 1200
01200, 00000, "actual file size of %s is smaller than correct size of %s blocks"
// *Cause:  The size of the file as returned by the operating system is smaller
//         than the size of the file as indicated in the file header and the
//         control file. Somehow the file has been truncated. Maybe it is the
//         result of a half completed copy.
// *Action: Restore a good copy of the data file and do recovery as needed.

Report message to a moderator

Previous Topic:	Datafile crashed
Next Topic:	password file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 04:19:02 CDT 2024