Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> ORA-00235: controlfile fixed table inconsistent due to concurrent update
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
![]() |
![]() |