How to fix the Oracle error RMAN-05031: cannot specify UNDO TABLESPACE clause for normal recovery?

In this post, you’ll learn more about the Oracle ErrorRMAN-05031: cannot specify UNDO TABLESPACE clause for normal recovery with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05031: cannot specify UNDO TABLESPACE clause for normal recovery

Reason for the Error RMAN-05031: cannot specify UNDO TABLESPACE clause for normal recovery

The UNDO TABLESPACE clause was specified for a normal recovery. It is only allowed for Tablespace Point-in-Time Recovery.

How to fix the Error RMAN-05031: cannot specify UNDO TABLESPACE clause for normal recovery ?

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

Remove the UNDO TABLESPACE clause and re-run the RECOVER command.