How to fix the Oracle error RMAN-05074: Tablespace string does not exist at specified point-in-time SCN string?

In this post, you’ll learn more about the Oracle ErrorRMAN-05074: Tablespace string does not exist at specified point-in-time SCN string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-05074: Tablespace string does not exist at specified point-in-time SCN string

Reason for the Error RMAN-05074: Tablespace string does not exist at specified point-in-time SCN string

The tablespace was found in the control file but the creation system change number (SCN) of the datafile(s) is after the specified point-in-time.

How to fix the Error RMAN-05074: Tablespace string does not exist at specified point-in-time SCN string ?

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

Verify the name of the tablespace and/or the point-in-time and resubmit the command.