Oracle DBA, How To, Error, Cause and Action

ORA-01247: database recovery through TSPITR of tablespace string

ORA-01247: database recovery through TSPITR of tablespace string




Cause: 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.




Action: 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.

No comments:

Post a Comment

Thanks for your comment.