Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Help: Errors In alert log file
Humm!!! Sounds like maybe "control_file_record_keep_time" is set to some crazy
value.
____________________Reply Separator____________________Subject: Help: Errors In alert log file Author: "salu Ullah" <salu_ullah_at_hotmail.com> Date: 7/5/00 8:14 AM
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
-- 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 mayReceived on Wed Jul 05 2000 - 11:55:40 CDT