How to fix the Oracle error RMAN-05073: Tablespace string creation SCN string is ahead of point-in-time SCN string?

In this post, you’ll learn more about the Oracle ErrorRMAN-05073: Tablespace string creation SCN string is ahead of 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-05073: Tablespace string creation SCN string is ahead of point-in-time SCN string

Reason for the Error RMAN-05073: Tablespace string creation SCN string is ahead of 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. This can happen if a previous tablespace point-in-time recovery was performed, for the tablespace.

How to fix the Error RMAN-05073: Tablespace string creation SCN string is ahead of point-in-time SCN string ?

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

If a previous TSPITR has been performed drop the tablespace and retry the command. Otherwise, verify the name of the tablespace and/or the point-in-time and resubmit the command.