Q
Problem solve Get help with specific problems with your technologies, process and projects.

RMAN level 0 backup failures: ORA-00235

We are using the RMAN level 0 hot backup process. We invariably have level 0 backup failures during the process.

We are using the RMAN level 0 hot backup process. We invariably have level 0 backup failures during the process with errors related to 'ORA-00235: controlfile fixed table inconsistent due to concurrent update'. We do not use recovery catalog. We have increased redo logs such that checkpoint happens after 8-10 minutes. Still the issue surfaces. Any suggestions on how to prevent this issue with our normal database usage?

I've had the same thing happen to me. Unfortunately, not even Oracle's support site has any information on the problem. In my case, I found that I was performing a backup and I had a automated job that would also periodically sync the recovery catalog or perform some other RMAN operation. All of these RMAN operations update the control file, whether you are using a Recovery Catalog or not. So make sure that this is the only RMAN process running.

If you do receive the ORA-235 error, your database is not affected, only your RMAN backup. You can restart the backup and everything should be fine.

This was last published in July 2004

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close