What is tablespace point in time recovery (TSPITR)?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is tablespace point in time recovery (TSPITR)?
Rating:
TSPITR is a technique that helps in recovering one or more tablespaces, except the SYSTEM tablespace, to a point in time.
It is used to recover/recover from the following:
- A tablespace in a very large database.
- A table that is logically corrupted.
- An erroneous DROP TABLESPACE operation.
- An erroneous DROP TABLE or TRUNCATE TABLE operation.
Rating:
Was this information helpful?
Other articles
- What is LOG_CHECKPOINT_TIMEOUT?
- What is RBAL?
- What is PLSQL_OPTIMIZE_LEVEL?
- What is multiplexing of a control file?
- What is automated storage management (ASM)?