My Oracle Support Banner

How To Perform an Entire Repository Export/Import With OWB 11.2 Using OMB*Plus Scripting Language (Doc ID 1581864.1)

Last updated on JULY 18, 2019

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

OWB 11.2 provides a way to make an Entire Repository Export using the Repository Assistant. The Entire Export contains both metadata and runtime data and is considered to be a supported backup of the OWB repository. The metadata consists of the design of OWB projects such as tables, mappings, flows etc. Runtime data consists e.g. of deployment information that can be seen in the Control Center, but also audit information that tells how many rows were loaded at a specific date/time. 

Customers might want to schedule such exports unattended in order to have valid backups of the complete OWB Repository. In such case the export would need to be made using OMB*Plus scripting language. This document explains how OMB*Plus can be used to make the Entire Repository Export using OMB*Plus scripting language. Also it explains how to execute the OMB*Plus export command from a shell script or batch file.

 

The second part of this note is using this Entire Repository Export to create a new repository.  This might be required due to a hardware failure, a disaster recovery situation or moving the repository to new hardware.

 

Solution

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
Goal
Solution
 Note:  It is recommended you monitor and purge audit data on a regular basis.  Audit data is included in an Entire Repository Export as text files in the MDL.  If you have large amounts of audit data, it will slow the export and may prevent an export or import from completing.
 Export the Repository
 1. The Entire Export Repository command
 
2. How to execute the script directly from the Operating System
References


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