My Oracle Support Banner

Steps To Recover A Dropped Tablespace Using TSPITR (Doc ID 1277795.1)

Last updated on JANUARY 29, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Recover a dropped tablespace using TSPITR.


RMAN automatic Tablespace Point-In-Time Recovery ( TSPITR) enables you to quickly recover one or more tablespaces in an Oracle database to an earlier time, without affecting the state of the rest of the tablespaces and other objects in the database.

Prior to 11.2 version the TSPITR had a restriction of not being able to recover the dropped tablespace.
From 11.2 this limitation no longer exists. We can recover the dropped tablespace using TSPITR.

The below example is an attempt to show the steps and functioning of TSPITR to recover a dropped tablespace.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.