Alert Log in Oracle 9i
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
Thread=1 Seq#=25503 Link-Recid=25502
What is it about?
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.