Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 2 | RMAN-03009: failure of crosscheck command on ORA_DISK_1 channel at 11/09/2019 11:56:32 ORA-19633: control file record 2354 is out of sync with recovery catalog |
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.
1 2 3 4 5 | SQL> select count(*) from v$archived_log where name like '%archivelog%'; COUNT(*) ---------- 1715 |
Find uppercase archive log files count
You can find the number of uppercase archive log files with the following query.
1 2 3 4 5 | SQL> select count(*) from v$archived_log where name like '%ARCHIVELOG%'; COUNT(*) ---------- 1 |
Find uppercase archive log files
The following query can be used to determine the archive log file created with Uppercase.
1 2 3 4 5 | SQL> select name from v$archived_log where name like '%ARCHIVELOG%'; NAME -------------------------------------------------------------------------------- +RECO/ORCL/ARCHIVELOG/2019_09_09/thread_1_seq_3421.24788.859035291 |
