ORA-19633: control file record is out of sync with recovery catalog

This error occurs due to problems during the upgrade process of databases from 11g to 12c. If the Upgrade is not completed and 11g continues to work , this error occurs during rman backup or archive log deletion due to bug number 14032377.

In 12C databases, archive log directory names are uppercase and in 11g, lowercase. Bug 14032377 is the problem when both uppercase and lowercase archive log files are present.

The error in Rman operations will be as follows.

The database must be upgraded to at least version 12.1 to resolve the problem.

Find lowercase archive log files count

You can find the number of lowercase archive log files with the following query.

Find uppercase archive log files count

You can find the number of uppercase archive log files with the following query.

Find uppercase archive log files

The following query can be used to determine the archive log file created with Uppercase.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *