Re: Error from control file

premmehrotra_at_hotmail.com (Prem K Mehrotra) wrote in message news:<43441e77.0410111908.44a1646_at_posting.google.com>...
> 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
> ----------
> DELETED OBJECT 20 65535 65535 5693 5692
> 401870
>
> 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
> ----------------------------------------- -------- ----------------------------

Sorry, I have trouble understanding because some of Oracle messages are very confusing. It looks to me if if I can live with the warning messages in alert log file, nothing needs to be done and there is no error when I am doing rman backup or restore. Even if I were to restore rman bakup from control file (in the rare case)instead of recovery catalog, there will not be any problem.

Even when I rebuid the control file (since I am not changing any parameters in it), warning messages will show up agan after a while. Is that correct?

Prem Received on Wed Oct 13 2004 - 08:50:50 CDT