Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

529766May 14 2008 — edited May 15 2008
Gurus,

I get following error message when I triy to execute this query :-

SQL> select distinct 'alter tablespace '||tab.tablespace_name||' begin backup;'
2 from dba_tablespaces tab, dba_data_files ddf, v$backup back
3 where tab.tablespace_name = ddf.tablespace_name and
ddf.file_id = back.file# and
4 5 tab.status = 'ONLINE' and
6 tab.contents != 'TEMPORARY' and
7 back.status != 'ACTIVE';
select distinct 'alter tablespace '||tab.tablespace_name||' begin backup;'
*
ERROR at line 1:
ORA-00235: controlfile fixed table inconsistent due to concurrent update

I have tried to execute this query for around 3-4 hours but always hit this error.

Can anyone advice how do I resolve this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2008
Added on May 14 2008
14 comments
14,279 views