-
Alert Log in Oracle 9i
Dear all,
I have an oracle 9i database in unix. I find the following message appears in alert log file repeatly.
kccrsz: denied expansion of controlfile section 9 by 55826 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #25503 Recno 61954 Record timestamp
11/14/02 18:41:55
Thread=1 Seq#=25503 Link-Recid=25502
Low
scn: 0x0000.57ce1b4e
11/14/02 18:41:55
Next
scn: 0x0000.57ce1b7a
What is it about?
Thx
-
Assuming that your CONTROL_FILE_RECORD_KEEP_TIME is set to default value of 7, your are hitting the max value(65535) MAXLOGHISTORY.
You can set CONTROL_FILE_RECORD_KEEP_TIME to 0 either in init.ora or dynamically alter system set control_file_record_keep_time=0;
Check Metalink for more info.
HTH
Sanjay