URGENT - ORA - 65285 and controlfile - db_file

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Fri, 9 Sep 2005 12:27:49 -0400
Message-ID: <1a3629600509090927359e9d6@mail.gmail.com>

Hi Guys,
ORA - 65285, Oracle says it is not yet documented. I got the following error in my alert log file. kccrsz: denied expansion of controlfile section 19 by 1337 record(s) the number of records is already at maximum value (65535) control_file_record_keep_time integer 21 <-- Do I need to reduce this? When I saw the view v$controlfile_record_section, I saw couple of frightening messages like BACKUP CORRUPTION,COPY CORRUPTION. SQL> 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 4084 4 0 0 0
0

REDO THREAD 104 1 1 0 0
0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

REDO LOG 72 50 3 0 0
3

DATAFILE 180 121 116 0 0
674

FILENAME 524 372 121 0 0
0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

TABLESPACE 68 121 109 0 0
1

TEMPORARY FILENAME 56 121 1 0 0
1

RMAN CONFIGURATION 1108 50 1 0 0
1

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

LOG HISTORY 36 1134 993 1001 859
11732

OFFLINE RANGE 56 145 0 0 0
0

ARCHIVED LOG 584 2349 2349 1693 1692
13946

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

BACKUP SET 40 816 816 142 141
3201

BACKUP PIECE 736 699 699 585 584
3201

BACKUP DATAFILE 116 3379 3379 307 306
37325

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

BACKUP REDOLOG 76 14723 14723 10598 10597 34870

DATAFILE COPY 660 247 0 0 0
0

BACKUP CORRUPTION 44 185 0 0 0
0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

COPY CORRUPTION 40 204 0 0 0
0

DELETED OBJECT 20 65535 65535 39631 39630 123126

PROXY COPY 852 345 0 0 0
0

TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
------------------ ----------- ------------- ------------ -----------

LAST_RECID

RESERVED4 1 8168 0 0 0
0

22 rows selected.
and db_file_sequential reads show high numbers today. buffer busy waits 5834063 19 715996
SQL*Net more data to client 9529216 0 49799 rdbms ipc message 18068313 10248897 2441471803 async disk IO 23697154 0 18305842
db file scattered read 37739602 2 3562500 SQL*Net message from client 93460966 0 8260270235 SQL*Net message to client 93461042 0 18720 db file sequential read 213371307 53 13532254. We are on SOLARIS and 9.0.1.3 <http://9.0.1.3>.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 09 2005 - 11:31:30 CDT

URGENT - ORA - 65285 and controlfile - db_file_sequential waits error