Database Reference
In-Depth Information
Database
A database is configured during installation to contain the SOA infrastructure
and MDS and messaging data. Although Oracle SOA Suite
11g
is certified on a
range of databases such as Microsoft SQL Server, MySQL, and IBM DB2, dis-
cussions in this topic assume an Oracle database, which is more common. The
Oracle database can be backed up via a tool such as Oracle
Recovery Man-
ager (RMAN)
.
The database maintains data related to in-flight instances, deployed composites,
and configuration, among other things. For example, if you deploy a composite
today and perform a database restore to the day before, that deployed compos-
ite will not be available. Also note that some configurations, such as that of the
Oracle BPEL Process Manager Engine, are stored in the database so that they
are available to all the managed servers.
The schemas that need to be backed up are listed in the following table. It is re-
commended to have nightly backups of the database.
Schema
Description
Metadata
Services
<ENV>_MDS
SOA Infra-
structure
<ENV>_SOAINFRA
Business
Activity
<ENV>_ORABAM
