How to fix the Oracle error RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time?

In this post, you’ll learn more about the Oracle ErrorRMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time

Reason for the Error RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time

RMAN assumes that the current set of tablespaces with undo segments is the same set that was in use at the specified Point-in-Time. If the set of tablespaces with undo segments changes, the recovery fails. If recovery fails, use the optional UNDO TABLESPACE clause of the RECOVER command to specify the correct set of tablespaces.

How to fix the Error RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point-in-time ?

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

RMAN assumes that the current set of tablespaces with undo segments is the same set that was in use at the specified Point-in-Time. If the set of tablespaces with undo segments changes, the recovery fails. If recovery fails, use the optional UNDO TABLESPACE clause of the RECOVER command to specify the correct set of tablespaces.