Schema Recovery Options in a Consolidated Environment
(Doc ID 1386048.1)
Last updated on JANUARY 30, 2022
Oracle Database Cloud Service - Version N/A and later 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 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!