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 22.214.171.124 and later
Information in this document applies to any platform.
*** Checked for relevance on 16-NOV-2015 ***
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