[askdba] URGENT - ORA - 65285 and controlfile - db_file_sequential waits error
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>, askdba@xxxxxxxxxxxxx
- Date: Fri, 9 Sep 2005 12:27:49 -0400
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>.
Other related posts:
- » [askdba] URGENT - ORA - 65285 and controlfile - db_file_sequential waits error
