Oracle Solution for Error ora-01247

ORA-01247: database recovery through TSPITR of tablespace string

What triggered the Error:

Recovery of the whole database encountered redo indicating there was a point in time recovery of the tablespace. The new version of the files in the tablespace should be included in the recovery, but that was not done.

What should we do to fix it:

If the tablespace should not be recovered, take its file offline for drop. If it should be recovered, then restore or rename as needed and restart the recovery.