Backup and restore OIM 11g

This post will explain the steps to back and restore the OIM 11g. Typically the cases for backup and restore would involve:

  • Restoring in same database (restoring to previous working state)
  • Restoring in different database (setting up new OIM environment in new DB instance)

I will explain the 1st scenario here. The export and import is recommended using data pump client utlity.

Exporting OIM stuff:

In 11g all the OIM data will get stored in database schemas XXX_OIM, XXX_SOAINFRA, XXX_ORASDPM, XXX_MDS.

XXX_OIM: This contains all the OIM specific schema.

XXX_SOAINFRA: If there are workflows configured in the environment, this schema has all of it.

XXX_ORASDPM: This is the user messaging schema.

XXX_MDS: Stores all the metadata of the environment.

  • Shutdown the OIM Managed server, SOA Managed server and weblogic admin servers.
  • Shutdown DB server and start up. This is to avoid any functional inconsistency in the data being exported.
  • Goto the DB machine and execute the command as shown below at $ORACLE_HOME/bin.

expdp ‘”/as sysdba”‘ DIRECTORY=DATA_PUMP_DIR SCHEMAS=DEV_OIM,DEV_SOAINFRA,DEV_MDS,DEV_ORASDPM DUMPFILE=OIMSchemaExport.dmp LOGFILE=OIMSchemaExport.log JOB_NAME=OIMSchemaExport_JOB PARALLEL=4 COMPRESSION=ALL

The dump file (OIMSchemaExport.dmp) is where all our OIM schema backup is stored. Don’t open this as it may get corrupted. Check for the log file OIMSchemaExport.log for any errors.

Importing/Restoring OIM stuff:

  • Shutdown the OIM Managed server, SOA Managed server and weblogic admin servers.
  • Drop the schemas XXX_OIM, XXX_SOAINFRA, XXX_ORASDPM, XXX_MDS by logging into SQL with user having sysdba privileges. Use the command drop user XXX_OIM cascade. Execute this command for all other schemas.
  • Goto the DB machine and execute the command as shown below at $ORACLE_HOME/bin.

impdp ‘”/as sysdba”‘ SCHEMAS=DEV_OIM,DEV_SOAINFRA,DEV_MDS,DEV_ORASDPM DUMPFILE=OIMSchemaExport.dmp LOGFILE=OIMSchemaImport.log JOB_NAME=OIMSchemaExport_JOB PARALLEL=4

  • Check the log file OIMSchemaImport.log for any errors.
  • Start the WebLogic admin server, SOA server and OIM server.
  • Login to OIM console to see if it is restored appropriately.

Hope this helps.

About the Author Mahendra

I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com

Leave a Comment:

12 comments
Mr.T says November 29, 2012

hi, Mahendra.

can the same procedure be followed for the 2nd scenario (setting up new OIM environment in a new DB instance)?

best regards.

Reply
Mahendra says November 29, 2012

No Mr.T. The steps in this post does not work for new OIM instance.

Reply
Anand says November 29, 2012

HI Mahendra,

Can you throw some light on “How to customize the OAM logo to customized logo ” on the OAM console page.

Anand

Reply
Mr.T says November 29, 2012

hi again and thank you for your reply.

any suggestions on how to make this work for the 2nd scenario? we are in a situation where we need to restore our OIM environment in a new ODB instance. are there additional steps that we need to perform?

best regards.

Reply
Mahendra says November 30, 2012

Anand,

Is it OAM 10g or 11g?

Reply
Mahendra says November 30, 2012

Mr.T,

Please follow the metalink note 1359656.1.

Thanks
Mahendra.

Reply
Anand says November 30, 2012

Hi Mahendra,

Its OAM 11gR2

Anand

Reply
Mr.T says December 4, 2012

hi again.

thank you again on your help. we are testing the procedure described in note ID 1492129.1 (for OIM 11.1.2).

best regards,
Mr.T

Reply
Vishnu says June 18, 2015

I have a need to create user in a target system
using OIM Connector. Please guide.

Reply
    Atul Kumar says June 18, 2015

    @Vishnu, Which is target system ? Install appropriate connector for target system and test.

    Reply
Vishnu says June 19, 2015

Proofpoint is the target system.

Reply
Manpreet says September 26, 2017

Hi,
We are planning to migrate oim 11g r2 (11.1.2.0.14) from one server to new server.
1) We want to migrate database from old to new server
2) we want to migrate OIM application from old to new server
3) we have connector (AD/exchange/Lotus) installed on one instance and we want these also on one new instance.
Kindly provide detailed steps/documents for above requirements.

Thanks,

Reply
Add Your Reply