How to fix the Oracle error ORA-19901: database needs more recovery to create new incarnation?

In this post, you’ll learn more about the Oracle ErrorORA-19901: database needs more recovery to create new incarnation with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-19901: database needs more recovery to create new incarnation

Reason for the Error ORA-19901: database needs more recovery to create new incarnation

Recovery was done to an incarnation after changing the destination incarnation using RMAN’s RESET DATABASE command, but one or more of the recovered datafiles still belongs to the parent incarnation. This usually happens when recovery is ended before any logs from the desired incarnation have been applied.

How to fix the Error ORA-19901: database needs more recovery to create new incarnation ?

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

Continue recovery.