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.
