My Oracle Support Banner

Fusion Middleware Database Schema Recovery Without Having to Restore Entire Database (Doc ID 2355784.1)

Last updated on JUNE 29, 2023

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.



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
 1. Intended Audience
 2. Problem Statement
 3. Preparing for the Upgrade
 3.1. Patch FMW Upgrade Assistant
 3.2.  Complete the Standard Pre-Upgrade Tasks
 3.3. Additional Required Pre-Upgrade Steps
 3.3.1 Export the Schemas
 3.3.2 Save Grants on SYS Owned Objects
 3.3.3 Identify Queue States
 4. Perform Schema Upgrade
 5. Performing an Online Schema Restoration After a Failed Upgrade
 5.1 Restore Schema Version Registry
 5.2 Drop Schemas to be Restored
 5.3 Import Schemas
 5.4 Restore Grants on Schemas
 5.5 Recompile Invalid Objects
 5.6 Restart Queues
 5.7 Continue Restoration Process

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