How to fix the Oracle error RMAN-05530: an UNTIL TIME or SCN cannot be specified with FROM ACTIVE DATABASE?

In this post, you’ll learn more about the Oracle ErrorRMAN-05530: an UNTIL TIME or SCN cannot be specified with FROM ACTIVE DATABASE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05530: an UNTIL TIME or SCN cannot be specified with FROM ACTIVE DATABASE

Reason for the Error RMAN-05530: an UNTIL TIME or SCN cannot be specified with FROM ACTIVE DATABASE

A DUPLICATE with FROM ACTIVE DATABASE was specified along with either a SET UNTIL statment or UNTIL clause on the command. This is not supported. A DUPLICATE FROM ACTIVE DATABASE always creates a copy as of the current time.

How to fix the Error RMAN-05530: an UNTIL TIME or SCN cannot be specified with FROM ACTIVE DATABASE ?

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

Check the statement and remove the use of UNTIL.