Skip to main content
Delphix

Listing Snapshots Used by Virtual Databases (KB1604)

 

 

KBA

KBA# 1604

 

This article addresses how to easily get a listing of VDB snapshots including which snapshots are being held due to retention or due to VDB dependencies.

Applicable Delphix Versions

This article applies to the following versions of the Delphix Engine:

Major Release

Sub Releases

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

4.0

4.0.0.0, 4.0.0.1, 4.0.1.0, 4.0.2.0, 4.0.3.0, 4.0.4.0, 4.0.5.0, 4.0.6.0, 4.0.6.1

3.2

3.2.0.0, 3.2.1.0, 3.2.2.0, 3.2.2.1, 3.2.3.0, 3.2.4.0, 3.2.4.1, 3.2.4.2, 3.2.5.0, 3.2.5.1, 3.2.6.0, 3.2.7.0, 3.2.7.1

Customer Accessible Data 

Listing Snapshots 

Snapshots can be listed per database by the customer via the CLI

mwbuild.dc1 snapshot> /snapshot ; list database='Vmar_087'
NAME                         CONTAINER  LATESTCHANGEPOINT.LOCATION  LATESTCHANGEPOINT.TIMESTAMP
'@2016-12-20T08:48:25.301Z'  Vmar_087   6614975                     2016-12-20T08:48:25.000Z
'@2016-12-29T03:36:00.133Z'  Vmar_087   7122728                     2016-12-29T03:36:00.000Z

Finding VDB parent snapshots 

To locate the parent snapshot for a VDB, the timeflow needs to be examined. The parent snapshot cannot be deleted even after it is past its retention period, as the child VDB is dependent on it.

List the timeflows for each VDB. Each timeflow will have its own parent snapshot.

mwbuild.dc1 snapshot> /timeflow ; list database='Vmar_087' display=name,container,parentSnapshot,parentPoint.timeflow,parentPoint.location,parentPoint.timestamp
NAME                                CONTAINER  PARENTSNAPSHOT               PARENTPOINT.TIMEFLOW  PARENTPOINT.LOCATION  PARENTPOINT.TIMESTAMP
'DB_PROVISION@2016-12-20T00:46:42'  Vmar_087   '@2016-12-14T03:05:20.416Z'  marina/default        6514654               -

The PARENTSNAPSHOT column provides us with the snapshot reference that we can use for further investigation.

mwbuild.dc1 timeflow ''DB_PROVISION@2016-12-20T00:46:42''> /snapshot ; select '@2016-12-14T03:05:20.416Z'
mwbuild.dc1 snapshot ''@2016-12-14T03:05:20.416Z''> ls
Properties
    type: OracleSnapshot
    name: '@2016-12-14T03:05:20.416Z'
    consistency: INCONSISTENT
    container: marina
    creationTime: 2016-12-14T03:05:20.416Z
    firstChangePoint:
        type: OracleTimeflowPoint
        location: 6514594
        timeflow: marina/default
        timestamp: 2016-12-14T03:05:14.000Z
    fromPhysicalStandbyVdb: false
    latestChangePoint:
        type: OracleTimeflowPoint
        location: 6514654
        timeflow: marina/default
        timestamp: 2016-12-14T03:05:14.000Z
    missingNonLoggedData: false
    redoLogSizeInBytes: 52428800
    reference: ORACLE_SNAPSHOT-16
    retention: 0
    runtime:
        type: OracleSnapshotRuntime
        provisionable: true
    temporary: false
    timeflow: marina/default
    timezone: America/Los_Angeles,PST-0800
    version: 12.1.0.2.0