Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Autoraid, bdf and Oracle files

Re: Autoraid, bdf and Oracle files

From: Joel Garry <jgarry_at_my-deja.com>
Date: Mon, 07 Feb 2000 22:40:24 GMT
Message-ID: <87nhkn$acg$1@nnrp1.deja.com>


In article <389F294E.74AD453_at_earthlink.net>,   John Ott <johnott_at_earthlink.net> wrote:
> 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
>
>

Ahhhh, thanks!

jg
--
These opinions mine
mailto:joel-garry_at_nospam.home.com
Remove nospam to mail
http://ourworld.compuserve.com/homepages/joel_garr

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 07 2000 - 16:40:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US