Sunday, September 19, 2010

In RAC database alert log reports ORA-00202 ORA-17510

Problem Description
In RAC environment alert log of the database instance intermittently reports following message for a brief period of time.

ORA-00202: controlfile: '+DATA/database/control01.ctl'
ORA-17510: Attempt to do i/o beyond file size


However, after sometime errors are go away. Database functions normally since the errors are reported and no problem is seen from the front end.

Cause of the Errors Reported
If you have close look of the alert log file of the other instance in the database, you will notice following message.

kccrsz: expanded controlfile section < > from < > to < > records
requested to grow by < > record(s); added < > block(s) of records

The above message indicates that there was an expansion in the size of the control file observed on the other node at around the time the errors were reported.

The scenario here is that there is a small window where the resize of a control file took place on one node and before the new control file size got updated/refreshed on the other node, a select was issued against one of the fixed views that accessed the control file without this control file transaction.

If you look for the trace files generated due to the these errors, you will notice the v$ fixed views being accessed in the failing sql captured.

The errors ultimately being disappeared automatically because the new control file size would get refreshed across all the nodes.

Solution
Since errors are harmless so you can simply ignore the error message.

No comments:

Post a Comment