Release Information


Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Data Backup and Recovery

Delphix Modernization Engine

Delphix Masking

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine


Mission Control

Delphix Express User Guide


Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation
Delphix Engine 4.3 Documentation

Skip to end of metadata
Go to start of metadata

This topic describes how to designate a staging host and enable validated sync for Oracle data sources.

Prerequisite - Designating a Staging Host

In order to validate an Oracle dSource snapshot for syncing, the Delphix Engine requires a host with an Oracle installation that is compatible with the dSource. This machine is known as the staging host. You must explicitly designate which machines you want the Delphix Engine to use as staging hosts. All machines that have been marked as staging sites are added to a pool. During validated sync, the Delphix Engine will select a compatible host from the pool, export the requisite archived redo logs and datafiles, and execute Oracle media recovery on the host. Follow these steps to designate a staging host.

  1. Select the repository you want to designate as staging.

    delphix>/repository/select '/u01/app/ora10205/product/10.2.0/db_1'
  2. Execute the update command.

    delphix repository "'/u01/app/ora10205/product/10.2.0/db_1'">update
  3. Set staging to true.

    delphix repository "'/u01/app/ora10205/product/10.2.0/db_1'" update *>set staging=true
  4. Commit the operation to designate the repository as staging.

    delphix repository "'/u01/app/ora10205/product/10.2.0/db_1'" update *> commit

To configure validated sync for multiple dSources with different Oracle versions, you must designate a compatible staging source for each. If multiple compatible staging sites exist, the Delphix Engine will select one at random.

The validated sync process will consume some resources on the staging host when snapshots are taken. Designating a performance-critical host as a staging host is not recommended.

Procedure - Enabling Validated Sync

  1. Select the dSource for which you want to enable validated sync.

    delphix>/database/select redsox1
  2. Execute the update command.

    delphix database "redsox1">update
  3. Set preProvisioningEnabled to true.

    delphix database "redsox1" update *>set preProvisioningEnabled=true
  4. Commit the operation to enable validated sync.

    delphix database "redsox1" update *>commit