Oracle RMAN Errors RMAN-03002 RMAN-03014 RMAN-06004

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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s