Re: Help: 2nd Req - Errors In alert log file

Search Metalink for "control_file_record_keep_time", you could be hitting a bug associated with MAXLOGHISTORY, fixed in 8.0.6, which DocID: 1057885.6 explains in detail.

Suzy

salu Ullah wrote:
>
> Hello all,
>
> I was checking my alert log file saw the following errors:
>
> kccexpd: controlfile not expanded: would require 30276 block(s), max is
> 20000
> krcpwnc: following controlfile record written over:
> RECID #480930 Recno 21067 Record timestamp
> 06/30/00 20:42:24
> Thread=1 Seq#=557071
> Flags:
> Resetlogs scn and time
> scn: 0x0000.0000334c
> 05/27/99 14:35:10
> filename /u06/oracle/arch/log557071.arc
> Low
> scn: 0x0000.02cde95e
> 06/30/00 20:42:22
> Next
> scn: 0x0000.02cde9a0
> 06/30/00 20:42:24
> Block count=500 Blocksize=1024
> Wed Jul 5 09:28:11 2000
> kccexpd: controlfile not expanded: would require 20576 block(s), max is
> 20000
> krcpwnc: following controlfile record written over:
> RECID #530834 Recno 13829 Record timestamp
> 06/30/00 09:45:18
> Thread=1 Seq#=548343 Link-Recid=530833
> Low
> scn: 0x0000.02c5c00f
> 06/30/00 09:45:16
> Next
> scn: 0x0000.02c5c048
> Thread 1 advanced to log sequence 588767
> Current log# 2 seq# 588767 mem# 0: /u02/oradata/oracle/redo02.log
> Wed Jul 5 09:28:11 2000
> kccexpd: controlfile not expanded: would require 30276 block(s), max is
> 20000
> krcpwnc: following controlfile record written over:
> RECID #480931 Recno 21068 Record timestamp
> 06/30/00 20:42:26
> Thread=1 Seq#=557072
> Flags:
> Resetlogs scn and time
> scn: 0x0000.0000334c
> 05/27/99 14:35:10
> filename /u06/oracle/arch/log557072.arc
> Low
> scn: 0x0000.02cde9a0
> 06/30/00 20:42:24
> Next
> scn: 0x0000.02cde9e1
> 06/30/00 20:42:25
> Block count=500 Blocksize=1024
> Wed Jul 5 09:29:12 2000
> kccexpd: controlfile not expanded: would require 20576 block(s), max is
> 20000
> krcpwnc: following controlfile record written over:
> RECID #530835 Recno 13830 Record timestamp
> 06/30/00 09:45:20
> Thread=1 Seq#=548344 Link-Recid=530834
> Low
> scn: 0x0000.02c5c048
> 06/30/00 09:45:18
> Next
> scn: 0x0000.02c5c07e
> Thread 1 advanced to log sequence 588768
> Current log# 3 seq# 588768 mem# 0: /u01/oradata/oracle/redo01.log
>
> I have checked the disk space for the filesystems in which my control files
> reside & they all seems to have enough space, if its the space problem.
> For that SCN errors, do i have to reset my logs, incase its not matching SCN
> # in control file with the current one.
>
> Thanks in advance
>
> Salu
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: salu Ullah
> INET: salu_ullah_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Jul 06 2000 - 12:26:21 CDT