Fusion Middleware Database Schema Recovery Without Having to Restore Entire Database

(Doc ID 2355784.1)

Last updated on MARCH 01, 2018

Applies to:

Oracle Fusion Middleware - Version and later
Information in this document applies to any platform.


1. Intended Audience

The expectation is that the content of this page will be incorporated into existing Oracle documentation.  The purpose of this document is to add additional detail to the currently documented steps for a specific upgrade backup/recovery use case.  The following sections provide information on how to perform a prefix level restore of schemas from a failed upgrade versus a full database restore.

2. Problem Statement

A single Oracle database may be shared by more than one Fusion Middleware domain.  When the upgrade of a single domain home fails, the recovery process must allow other domains that share the same database to remain on-line.  The following instructions describe a process of how to restore only the schemas affected by the failed upgrade.



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms