Taking Oracle staging push dSource snapshots

Taking a Snapshot

On initiating a sync, Delphix Engine checks the staging server for the database of the given name and if a match is found, it then takes a snapshot of its data files. Before and after taking the snapshot, Delphix Engine runs a few validations to check the readiness and consistency of the database for the snapshot.

Below are the checks performed by Delphix Engine during snapshot operation:

The staging database is in the MOUNT, READ ONLY or READ ONLY WITH APPLY mode
All data files are present on the Delphix Engine mounted storage
For a non-standby staging database, checkpoint SCN of all online datafiles is the same
The database must be recovered and no data files must be in FUZZY state
Checkpoint SCN must have advanced since the last snapshot was taken
Checkpoint SCN has not advanced during the snapshot operation

CDB dSource snapshots cannot be taken manually. A PDB dSource snapshot operation takes a CDB dSource snapshot first before taking a PDB snapshot.

Taking an incremental snapshot

The staging database can be populated further by:

Restoring incremental backups
Through ongoing managed recovery in case of Physical Standby databases

After the staging database is populated with incremental changes, a snapshot operation will take an incremental snapshot of the dSource.