How to fix the Oracle error ORA-19906: recovery target incarnation changed during recovery?

In this post, you’ll learn more about the Oracle ErrorORA-19906: recovery target incarnation changed during recovery with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19906: recovery target incarnation changed during recovery

Reason for the Error ORA-19906: recovery target incarnation changed during recovery

While a media recovery was active, a new incarnation was detected by the server due to inspection or cataloging of archived logs or backup files.

How to fix the Error ORA-19906: recovery target incarnation changed during recovery ?

You can fix this error in Oracle by following the below steps

If you want recovery to use the new incarnation, restart recovery. This is the most common action on a standby database when RESETLOGS is done in primary. If you do not want recovery to use the new incarnation, change the recovery destination using RMAN’s RESET DATABASE TO INCARNATION command. To see which incarnations are available for this target database, query V$DATABASE_INCARNATION or use RMAN’s LIST INCARNATION command.