| Denied expansion of controlfile [message #58600] |
Sun, 21 September 2003 05:56  |
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
|
Member |
|
|
I've created a new test database (Oracle 8i on a Sun Solaris 8 unix platform). We began loading masses of data into it for the first time and after a while i noticed these messages appearing in the alert log :-
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 #11078 Recno 11078 Record timestamp
9/18/03 17:44:21
Thread=1 Seq=#=11078 Link-Recid=11077
Low
scn: 0x0000.001ad32f
09/18/03 17:44:21
Next
scn: 0x0000.001ad255
Is this just an information message saying that the control file has filled up and is reusing records. I assume i don't have to worry about it. The control file is about 6.5Meg in size and i created the database with these values (maxlogfiles=32, maxlogmembers=2 ,maxdatafiles=100, maxinstances=2).
|
|
|
|
| Re: Denied expansion of controlfile [message #58601 is a reply to message #58600] |
Sun, 21 September 2003 06:57  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
James,
It looks like the filesystem on which your controlfile resides has become full ,denying controlfile expansion.
Oracle controlfile has circularly reusable records(containing archivelog/backup info) and non-reusable records(containing datafiles/logfiles info etc).
The reusablility is controlled by CONTROL_FILE_RECORD_KEEP_TIME init.ora parameter. It defaults to 7 days. This is the minimum number of days the reusable records are retained in the controlfile before they get overwritten. The file expands ,filesystem permitting,to meet the minimum keep time.
But if the filesystem(or if say you store the controlfile on a raw device which cannot expand automatically) is full or some other issue prevents the controlfile from expanding, than the oldest records get overwritten irrespective of the control_file_record_keep_time and Oracle registers such a warning message in the alert.log file for you to take necessary action.
You dont have to worry too much about it if for example you use recovery catalog for RMAN and resync the catalog periodically( say every day or so) or if you dont need to recover the database from a backup taken before the control_file_Record_keep_time number of days, becos now the archivelog info has been overwritten.
You will need to free up the filesystem space and confirm if your keep_time setting is appropriate vs the frequency of the backups/resync catalog etc.
Hope this helps
Thiru
|
|
|
|
| Re: Denied expansion of controlfile [message #58607 is a reply to message #58601] |
Sun, 21 September 2003 15:45 |
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
|
Member |
|
|
Hello Thiru,
Thanks very much for your reply (very useful and interesting). I think you're correct about the file system. Its not full but i looked through the /var/adm/messages file and found many controller errors. Our unix system has just recently been installed/setup and the file systems are on SAN disks. I think there might be something up with the drivers or what ever (model errors as well). When we run a select to query a table the query takes ages (table in a tablespace thats on the SAN disks).
Thanks again for your reply.
|
|
|
|
| Re: Denied expansion of controlfile [message #153419 is a reply to message #58600] |
Mon, 02 January 2006 04:27 |
nmmeenaa
Messages: 1
Registered: January 2006
|
Junior Member |
|
|
kccrsz: denied expansion of controlfile section 9 by 65535 record(s) the number of records is already at maximum value (65535).
after 7 days my database stopped and find the above error message in my alert.log .please help me urgent
regards
nmmeenaa
|
|
|
|
| Re: Denied expansion of controlfile [message #153477 is a reply to message #153419] |
Mon, 02 January 2006 16:24 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Did you even read the above posting?
It is to do with your CONTROL_FILE_RECORD_KEEP_TIME as stated by Thiru.
What is its current value?
Did try setting it to 0 (zero)?
Apply caution here. If you are using RMAN, DO NOT TRY the above.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
