How to fix the Oracle error RMAN-05521: DUPLICATE without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified?

In this post, you’ll learn more about the Oracle ErrorRMAN-05521: DUPLICATE without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05521: DUPLICATE without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified

Reason for the Error RMAN-05521: DUPLICATE without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified

A DUPLICATE was attempted when target database was not open without connection to a recovery catalog. It is necessary that the list of tablespaces with undo segments is provided with the UNDO TABLESPACE clause.

How to fix the Error RMAN-05521: DUPLICATE without CATALOG and TARGET not open requires that UNDO TABLESPACE is specified ?

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

Retry the command specifying the list of tablespaces with undo segments using the UNDO TABLESPACE clause.