Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.