File shrank by 1356362240 bytes; padding with zeros

[Vu Pham]

On Sat, 2007-02-24 at 14:02 +1100, James McDonald wrote:
> Vu Pham wrote:
> > I have a file that always gives me a backup error. 
> >
> > tar: u3/CCTMS/BTDL/OVER.30: File shrank by 1356362240 bytes; padding
> > with zeros.
> >
> > This is the data file and it looks like it is ok. Everybody uses it
> > everyday and they find no problem at all.
> >
> >
> > What causes that error ?
> >   
> Sounds like it's being written to by a process while your trying to take 
> a snap shot of it via the backup...
> 
> I always try and stop my database engine/s first before performing a 
> backup or just use the internal db backup agent to get a snapshot of the 
> database and then back that up.
> 

James, I checked the backup script and it does have the stop and start
script for Universe database. The problem is for some reason, UV just
did not stop properly. After killing the process and running the backup
again, everything works fine.


Thanks,

Vu