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 or READ ONLY mode

• All data files are present on the Delphix Engine mounted storage

• Checkpoint SCN of all online datafiles is the same

• The database should be recovered and no data files should be in FUZZY state

• Managed recovery is not running for the staging database

• Checkpoint SCN must advance 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.