Re: Autoraid, bdf and Oracle files

Joel Garry wrote:

> Gurus:
>
> I have an Autoraid on hp-ux 10.20. One filesystem is 16G. There is
> nothing except Oracle data files on there (besides lost+found). This is
> a recently created filesystem on recently installed disks. I created
> 26 tablespaces, and according to bdf I used up 94% of the filesystem.
> The tablespaces are mostly empty, some data has been loaded, more will
> be added over the course of a few months. One file per tablespace.
>
> Every night, I do an Oracle cold backup and export (both to another
> disk - omniback backups are of the other disk at other times). Before
> and after the Oracle backups I do a bdf. Last Thursday, the disk usage
> shrunk to 92% sometime during the backup. This has me mystified. I
> know Autoraid moves stuff around, but could it have come up with 250K
> blocks doing that? Do I have some potential corrupted db files? How
> could I tell? Should I even be worrying about this? No complaints in
> any system or Oracle logs. I don't think there has been anything in
> lost+found. I've seen bdf take a few minutes to catch up, but never be
> stable for 2 days then suddenly change its mind.
>
> /dev/vg07/u08 16777216 15646277 1060256 94% /u08
>
> /dev/vg07/u08 16777216 15373733 1315766 92% /u08
>
> jg
> --
> These opinions mine
> mailto:joel-garry_at_nospam.home.com
> Remove nospam to mail
> http://ourworld.compuserve.com/homepages/joel_garry
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

I would not worry

What probably happened was an oracle process had a lock on a file that was set to be deleted. When you did the cold backup of oracle the process was shutdown and the file was finally deleted.

I've seen this before.

later
John Received on Mon Feb 07 2000 - 14:21:46 CST