Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> ORA-00235: controlfile fixed table inconsistent due to concurrent update

ORA-00235: controlfile fixed table inconsistent due to concurrent update

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Fri, 27 Jul 2001 09:49:19 +0800
Message-ID: <bng1mt49vhlpb81ai4k6tlnulr5i79cnsr@4ax.com>

Hello,

I have one 8.1.6 server running on HP-11.0 box.

it's in archivelog mode and we perform hot backup every day. (alter tablespace XXX begin/end backup;)

after backup completed , we have to do some check statements such like : select * from v$backup; ....etc.

But if the select statement join with v$view, like v$datafile or v$backup,
There is an error :

ORA-00235:controlfile fixed table inconsistent due to concurrent

                       update

Cause: Concurrent update activity on a control file caused a query on 
          a control file fixed table to read inconsistent information.

Action: Retry the operation.

the db has 289 tablespaces with 331 datafiles plus 10 logfiles and 3 controlfiles. (about 15G)

Should I ignore the error msg? (it occurs almost every time...) or should i do something? (create controlfile?...)

Thanks for any advise.

Regards,

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Thu Jul 26 2001 - 20:49:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US