Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: controlfile extend problem
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...Received on Sun Jun 04 2000 - 00:00:00 CDT
> 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.