| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Error from control file
premmehrotra_at_hotmail.com (Prem K Mehrotra) wrote in message news:<43441e77.0410111140.284af124_at_posting.google.com>...
> I see follpwing error/message in my alert.log file:
>
> krcpwnc: following controlfile record written over:
> RECID #336327 Recno 5684 Record timestamp
> 09/12/04 00:16:04
> Object type=254 Object recid=1516 Object timestamp=
> 06/07/04 21:58:47
> kccrsz: denied expansion of controlfile section 19 by 1337 record(s)
> the number of records is already at maximum value (65535)
>
>
> I am settng CONTROL_FILE_RECORD_KEEP_TIME=30
>
>
> Looking at Metalink, it appears that this error occurs because some
> section
> of control file needed to be reused. My questions are:
>
> 1. Does Oracle anyway ends up reusing the section despite he message.
>
> 2. Oracle recommends to set this parameter to 0 which means section
> will be reused. I presume the this error message will not be shown.
>
> 3. Is there any other way to fix the problem.
>
>
> hanks a lot,
>
> Prem
Below is the output from a v$ view. If I were to rebuild control file which paraemeter will I change.
select * from v$controlfile_record_section;
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
----------------- ----------- ------------- ------------ ----------- ----------LAST_RECID
DATABASE 192 1 1 0 0
0
CKPT PROGRESS 2036 8 0 0 0
0
REDO THREAD 104 8 1 0 0
0
REDO LOG 72 32 3 0 0
3
DATAFILE 180 62 21 0 0
21
FILENAME 524 127 28 0 0
0
TABLESPACE 68 62 21 0 0
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
----------------- ----------- ------------- ------------ ----------- ----------
LAST_RECID
21
RESERVED1 56 62 0 0 0
0
RESERVED2 1 1 0 0 0
0
LOG HISTORY 36 1357 1357 802 801
25783
OFFLINE RANGE 56 72 0 0 0
0
ARCHIVED LOG 584 2565 2565 2290 2289
37140
BACKUP SET 40 305 305 71 70
2408
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
----------------- ----------- ------------- ------------ ----------- ----------
LAST_RECID
BACKUP PIECE 736 232 232 152 151
2408
BACKUP DATAFILE 116 737 737 187 186
7450
BACKUP REDOLOG 76 1339 1339 1238 1237
11468
DATAFILE COPY 660 129 0 0 0
0
BACKUP CORRUPTION 44 92 0 0 0
0
COPY CORRUPTION 40 101 0 0 0
0
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
----------------- ----------- ------------- ------------ ----------- ----------
LAST_RECID
PROXY COPY 852 191 0 0 0
0
RESERVED4 1 4072 0 0 0
0
22 rows selected.
SQL> desc v$controlfile_record_section;
Name Null? Type ----------------------------------------- -------- ----------------------------Received on Mon Oct 11 2004 - 22:08:30 CDT
 |
 |