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