Re: HELP! getting 'actual filesize 'n' is smaller than correct filesize of 'n' blocks

y2k% oerr ora 01200 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. y2k%

In article <3650641e.14319380_at_news.erols.com>,   derek_otten_at_pamet.com wrote:
> I'm a new DBA and have just created a new production database. Having
> done an initial backup of it 2days ago, I created the tables for it in
> the master schema and in the 'usr' tablespace and then also created
> the primary keys on these tables. They were stored in the 'index'
> tablespace. I now am getting the following error when attempting a
> backup:
> ORA-01200: actual file size of 1658382 is smaller than correct size of
> 2032141 blocks
>
> for some reason, the file is being truncated. I then have to restore
> off the backup set (I have to do it twice because after the first
> time, the sys tablespace then needs recovery). I have it up and open
> at the moment, but I can't keep doing this, I'll never get another
> backup set (running in noarchivelog mode).
> help!
> Derek Otten
> Derek_otten_at_pamet.com
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 16 1998 - 20:31:59 CST