Schema Recovery Options in a Consolidated Environment
(Doc ID 1386048.1)
Last updated on MARCH 12, 2021
Oracle Database - Enterprise Edition - Version 220.127.116.11 and later Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2013***
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!