My Oracle Support Banner

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

Last updated on SEPTEMBER 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
*** Checked for relevance on 16-NOV-2015 ***

Purpose

Recover a dropped tablespace using TSPITR.

Scope

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.

Details

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
Purpose
Scope
Details
References

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