Oracle Version 12.1.0.2 - RMAN Recovery fails with ORA-1610

Owned by Alexey Sosnovskih
Nov 06, 2023
1 min read

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

After creating the controlfile and Cataloging the Archive logs , Recovery command in RMAN fails with ORA-1610 Error, whereas the same command works in 11g

RMAN-8054: starting media recovery
RMAN-8059: media recovery failed
RMAN-571: ===========================================================
RMAN-569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-571: ===========================================================
RMAN-3002: failure of recover command at 01/08/2016 13:01:42
RMAN-3009: failure of starting media recovery command on default channel at
01/08/2016 13:01:42
ORA-283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database
recover if needed
start until cancel until cancel
ORA-283: recovery session canceled due to errors
ORA-1610: recovery using the BACKUP CONTROLFILE option must be done

CAUSE

Unpublished Bug 19404068 : ORA-1610 ON RECOVER DATABASE FOR CREATED CONTROLFILE which is fixed in 12.2

Apply patch 19404068 or upgrade database to 12.2