My Oracle Support Banner

Schema Recovery Options in a Consolidated Environment (Doc ID 1386048.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


Consolidating multiple databases into a single database requires thought and consideration when needing to perform point in time recovery for a single application/schema. This article will discuss the options and best practices surrounding this type of recovery.


The intended audience for this article is a Database Administrator in charge of a consolidated schema environment  This environment would consist of multiple application schemas consolidated into a single database.  The administrator should have familiarity with Tablespace Point In Time Recovery concepts and usage as well as Recovery Manager (RMAN) and Flashback tools provided by Oracle.

The steps in this document are applicable to RDBMS versions 11g and 12c.


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
 Point in Time Recovery Options
 Determining Which Recovery Option to Choose
 RMAN TSPITR Operations
 RMAN TSPITR Sample Script
 RMAN TSPITR Best Practice Recommendations
 RMAN TSPITR Sample Execution
 Determine Row Counts and Recovery SCN
 Run Order Entry processing for a period and determine new counts.
 Setup for the TSPITR operation
 Perform the TSPITR operation
 Backup the datafile and bring online
 Manage Physical Standby
 Flashback Table Operations
 Flashback Table Best Practices
 Flashback Table Sample Execution
 Determine initial counts after load and the SCN to flashback to
 Run SOE Order Entry and determine new row counts
 Setup for flashback operation
 Perform the flashback table operation
 Verify the results
 Managing physical standby

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