OIM 12c: Schema Backup and Restoration using Data Pump Client Utility
(Doc ID 2584066.1)
Last updated on NOVEMBER 10, 2022
Applies to:Identity Manager - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
The Database Layer (OIM and its dependent Schemas) are an integral part of the OIM Application Infrastructure.
This document intends to provide for a step-by-step process in detail for the “Logical” Backup and Restoration of the OIM 12c Application Database Schemas using Oracle’s Data Pump utility.
What this Technical Note covers
Backup of OIM 12c and its dependent Schemas of a running deployment.
Restoration from scratch on a different1/same database instance.
The methodology depicted is not intended for a Production level Backup Restoration and Recovery solution for an enterprise customer deployment.
1 - a different instance on the same or on a different physical machine.
What this Technical Note does NOT cover
Backup/Restoration methodology for the OIM 12c Upgrade environments
Backup/Restoration methodology for T2P scenarios.
Oracle Identity Manager 12c Database Schemas
From the operational perspective, OIM 12c and its dependent Database Schemas topology consists of the following ELEVEN mandatory schemas:
Oracle Identity Manager (OIM) Schema [OIM 12c]
Meta Data Service (MDS) Schema
Service Oriented Architecture Infra (SOAINFRA) Schema
Oracle Platform Security Services (OPSS) Schema
Audit Service (IAU) Schema
Audit Service Append (IAU_APPEND) Schema
Audit Service Viewer (IAU_VIEWER) Schema
Service Table (STB) Schema
User Messaging Service (UCSUMS) Schema
WebLogic Services (WLS) Schema
WebLogic Services Runtime (WLS_RUNTIME) Schema
OIM 12c Database Backup and Restoration
Local Backup of OIM Schema
For the Logical Backup of OIM 12c Schemas (and its subsequent Restoration), the recommended tool is Oracle Data Pump Export Utility.
Restoration of OIM Schema
For the restoration of the Logical Backup (taken using the Oracle Data Pump Export utility), the corresponding utility i.e. the Data Pump Import utility is to be essentially used.
Following are the possible scenarios of restoration based on the location of restore:
Local restoration - Restoration in the “same” Database Instance post Schema drop
Remote restoration - Restoration in a “different” Database Instance
Data Pump is a tool of choice over conventional export/import utility, as it not only provides a platform independent data dump but also by way of its architectural enhancements it is faster.
Data Pump command line clients are available out-of-the-box with Oracle Database Client/Server (Oracle DB 10g and onwards) with no additional licensing cost.
NOTE - Check for the compatibility of the Data Pump Client w.r.t. to the Target Database in use.
Compatibility between the DB version and the Data Pump Client:
A newer version of Data Pump Client cannot be used in order to export data from a lower database version.
For example to export data from database version 10.2.0.3 or 9.2 the 184.108.40.206 Data Pump Client would not suffice.
Remote vs Local Restoration
Steps for restoration on Local or Remote DB Instances are same almost the same except for:
In Remote Restoration, schemas are imported in a different database instance (which can be on a different machine as well). This Database may or may not have any prior OIM 12c Schemas or even any FMW Schema created on it, depending on this some additional steps may be required.
In the case of Remote DB restoration, the JDBC connection information is to be modified as per the steps in the section “OIM 12cmid-tier side JDBC Connection configuration”.
Generic High Level Steps in Logical Export of OIM 12c Schemas
NOTE - Order of Export of Database Schemas does not matter from the OIM 12c Application functionality perspective.
What to retain along with the exported data dump
For ease of subsequent restoration, following details are to be retained for later reference along with the OIM export dump:
Name of the OIM/dependent Schemas
Default and Temporary Tablespace names of OIM and its dependent schemas, along with names of any other tablespaces involved in OIM/other Schema objects.
Data Pump/Conventional Export log file
Generic High Level Steps in Logical Import of OIM 12c Schemas
NOTE - Steps 2) and 4) can be skipped if restoring on the same DB Instance (using the same schema names).
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
|Oracle Identity Manager 12c Database Schemas|
|OIM 12c Database Backup and Restoration|
|Generic High Level Steps in Logical Import of OIM 12c Schemas|
|Detailed Steps for Export of OIM 12c Schemas|
|Data Pump Export|
|Detailed Steps for Restoration of OIM 12c Schemas|
|Data Pump Import|
|OIM 12c Mid-Tier side JDBC Connection Configuration|
|Edit Data Source Configuration|
|Edit MBean Configuration|
|Bounce the OIM and SOA Managed Servers|
|Connect to OIM Application|