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: Strange problem releasing inodes

Re: Strange problem releasing inodes

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 27 Jan 2007 15:07:26 -0800
Message-ID: <1169939246.555314.320280@v33g2000cwv.googlegroups.com>

On Jan 26, 10:06 am, "EdStevens" <quetico_..._at_yahoo.com> wrote:
> OS: SunOS 5.10,Sun-Fire-V440
> Oracle: 10.2.0.1.0
>
> A couple of months ago we had an issue on this server with the OS
> claiming we were running out of space on the file system holding most
> of the Oracle files. Closer investigation showed 'some sort of
> problem with the inodes'. We stopped the db, the SA ran some
> utility, and the space usage dropped from 98% to around 50%.
>
> A couple of weeks ago, began getting indications were were in the same
> situation. Files are not growing, but reported FS usage is. Another
> repair operation was scheduled for last night. As soon as we stopped
> the databases the SA reported that reported FS usage immediately
> dropped.
>
> As far as database usage on this server, we have three databases. One
> is rather small, vanilla db backing a packaged app (Clarity/Niku); one
> is a physical standby running in recovery mode, and the third is an
> 8.1.7.4 that serves as a proxy client between the app and the physical
> standby in the event it becomes the primary. (Long story. Short
> version is app was written in Pro*C 8.1, then the source code lost.
> Solution is to put up an 8.1.7.4 for the app to connect to, and use
> synonyms and a db link to pass all activity through to the 10.2 db
> where the data actually resides.) We have a shell script that runs
> daily (via cron) to delete old archive logs a few days after they have
> been applied to the physical standby. Since the archivelogs are
> written to a new directory each day
> (/db01/archive/epspd/arc/<SID>/archivelog/<yyyymmdd>, the delete is
> actually deleting the date-based directory, not the enumerated
> archivelog files:
>
> find ${TARGET_DIR} \( -name "*" -type d \) -mtime +$RETAIN_DAYS -exec
> rm -rf {} \;
>
> Any ideas?
>
> BTW, today is my last day on this job -- starting a new job on Monday.
> Of course, I'll be able to follow and participate in this thread, but
> won't be able to work a TAR with MetaLink or actually follow up with
> the SA's here. But I thought this was a pretty interesting problem
> that was worth some discussion.

Ok you had an earlier problem that involved oracle and "you believe" that the system administrator "did something".

Not quite sure that's the followup I would want to see from someone posting on cdos so frequently. Don't you get a bigger bank from your buck by knowing all the details of a problem?

Posting on cdos when a similar problem occurs isn't exactly the same thing as getting all the details when a problem happens the first time.

I would expect that you might get a better idea of what is involved by calling the system administrator and "even though you are leaving" asking them for a complete explanation. Buying them a beer might be a good way of getting to the point of being able to ask your question. Received on Sat Jan 27 2007 - 17:07:26 CST

Original text of this message

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