This topic describes the validated sync process for Oracle databases using both the Delphix Engine Graphic User Interface (GUI) and Command Line Interface (CLI)

Traditional Oracle dSource snapshots require some recovery during provisioning. By configuring validated sync for Oracle, the Delphix Engine will select a compatible Oracle installation and apply the recovery necessary to provision a snapshot immediately after each SnapSync. Snapshots that have been through this validated sync process step do not require recovery during provisioning.

The Delphix Engine may be unable to perform validated sync on a physical standby database in Real Time Apply mode. This is because the standby may apply changes before copying the logs that contain those changes. Without the logs necessary to perform recovery, validated sync cannot be executed. However, you can still provision the snapshot when the archive logs become available on the standby.

Prerequisite - Designating a Staging Host

In order to validate an Oracle dSource snapshot after a sync, 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 hosts are added to a pool. During sync validation, 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. Log into the Delphix Admin application using  Delphix Admin credentials.
  2. Select  Manage > Environments.
  3. In the Environments panel, select the environment you want to designate as staging.
  4. Next to  Environment Details, select Databases.
  5. Scroll down to the installations you want to designate as staging and slide the Use as Staging control to Yes.

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.

The default OS user for the staging host must have access to the Oracle installation that will be used to perform recovery during validated sync.

Oracle Pluggable Database

Validated sync for Oracle pluggable databases is not supported in this release.

Procedure - Enabling Validated Sync

Oracle validated sync can be enabled at link time or on any existing dSource. 

  1. Log into the Delphix Admin application using  Delphix Admin credentials.
  2. Select ManageDatabases > My Databases
  3. In the Databases panel, select the dSource for which you want to enable sync validation.
  4. Move the slider control for Sync Validation from Disabled to Enabled.

Video