The below error was received after restoring the database to a previous point in time:
RMAN-03002: failure of backup command at 08/10/2017 14:00:15
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20035: invalid high RECID
To resolve this either implement OPTION 1 OR OPTION 2 :
OPTION 1. unregister/register the database with recovery catalog:
— make sure you have a backup of your recovery catalog, because
it retains old backup information of all of your databases.
rman target /
connect catalog_usr/catalog_usr_pass@CATALOG
RMAN> unregister database;
RMAN> register database;
OPTION 2. Open Database with Resetlogs:
sqlplus / as sysdba
SQL> ALTER DATABASE MOUNT;
SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
SQL> ALTER DATABASE RECOVER CANCEL;
SQL> ALTER DATABASE OPEN RESETLOGS;
rman target /
connect catalog_usr/catalog_usr_pass@CATALOG
RMAN> reset database;
RMAN> backup database;