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

Last updated on MAY 09, 2017

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 Export of the Repository 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.

Solution

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