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: controlfile extend problem

Re: controlfile extend problem

From: Jim Shan <jshan_at_home.com>
Date: 2000/06/05
Message-ID: <393B3CEE.9910D757@home.com>#1/1

I don't think you can use raw devices in Linux.

JS.

Bob Fazio wrote:

> I am not sure, but is it possible that they are using raw devices. If so,
> they will have to extent the device first, before the control file will
> expand. There is also a setting to control the expanding of the control
> file. See below (from the documentation)
>
> Records in some sections in the control file are circularly reusable while
> records in other sections are never reused. CONTROL_FILE_RECORD_KEEP_TIME
> applies to reusable sections. It specifies the minimum age in days that a
> record must have before it can be reused. In the event a new record needs to
> be added to a reusable section and the oldest record has not aged enough,
> the record section expands. If CONTROL_FILE_RECORD_KEEP_TIME is set to 0,
> then reusable sections never expand and records are reused as needed.
>
> --
> Robert Fazio, Oracle DBA
> rfazio_at_home.com
> remove nospam from reply address
> http://24.8.218.197/
> <bann3094_at_my-deja.com> wrote in message news:8h97fu$9m7$1_at_nnrp1.deja.com...
> > Hello,
> >
> > This message keeps popping up in the alert.log of a database that my
> > friend is Administrating.
> >
> >
> > -------------------------------
> >
> > kccexpd: controlfile not expanded: would require 28226 block(s), max is
> > 20000
> > krcpwnc: following controlfile record written over:
> >
> > -----------------------------------------------
> >
> > All I know is that the company is running Oracle 8i. I think the OS is
> > LINUX.
> >
> >
> > I thought that the only limit on you controlfile was available disk
> > space.
> >
> > You help will be greatly appreciated.
> >
> > Roger.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Mon Jun 05 2000 - 00:00:00 CDT

Original text of this message

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