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.
Select the repository you want to designate as staging.
delphix repository "'/u01/app/ora10205/product/10.2.0/db_1'">update
Set staging to
delphix repository "'/u01/app/ora10205/product/10.2.0/db_1'" update *>set staging=true
Committhe 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
Select the dSource for which you want to enable validated sync.
delphix database "redsox1">update
delphix database "redsox1" update *>set preProvisioningEnabled=true
Committhe operation to enable validated sync.
delphix database "redsox1" update *>commit