kccrsz: denied expansion of controlfile section 9 by 65535 record(s)

Problem Description:
-------------------------
The machine did not respond properly and in the alert log you the got the following.
kccrsz: denied expansion of controlfile section 9 by 65535 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #528019 Recno 3739 Record timestamp
04/13/08 16:26:16
Thread=1 Seq#=528019 Link-Recid=528018


Error Description:
----------------------
1)Check the default value of control file record keep time.

SQL> show parameter control_file_record_keep_time

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7

2)Check the MAXLOGHISTORY database parameter.

SQL>alter database backup controlfile to trace as '/oradata/1.txt'
Check MAXLOGHISTORY value from /oradata/1.txt

Or, you can check RECORDS_TOTAL value from v$controlfile_record_section
SQL> select * from v$controlfile_record_section where type='LOG HISTORY' ;

Now the problem is occurred due to control_file_record_keep_time and MAXLOGHISTORY settings.

The MAXLOGHISTORY increases dynamically when the CONTROL_FILE_RECORD_KEEP_TIME is set to a value different from 0, but does not exceed MAXLOGHISTORY (65535).Once reached, the message appears in the alert log.

From above error it is seen the MAXLOGHISTORY parameter has already reached the maximum of 65535 and it cannot be increased anymore.

Solution of The problem:
---------------------------
1)Set the CONTROL_FILE_RECOED_KEEP_TIME to zero.

alter system set control_file_record_keep_time=0;
or.

2)Change the MAXLOGHISTORY parameter.

The compatibility level is set to a value that is earlier than 10.2.0, and you must create new new control file by CREATE CONTROLFILE command. If compatibility is 10.2.0 or later, you do not have to create new control files when you make such a change; the control files automatically expand, if necessary, to accommodate the new configuration information.

Caution:
-----------
Setting control_file_record_keep_time to zero is dangerous for making RMAN backups. In that case use recovery catalog as repository for RMAN backup instead of control file.

Related Link:
-------------
Create Controlfile

Controlfile Information