CLI cookbook: determining the snapshot used to provision a VDB

Procedure:

The parent snapshot can be determined using the CLI as follows:

Log into the server as a Delphix administrator:
CODE
```
ssh admin@<server_ip>
```

Select the VDB.

CODE

delphix> database
delphix database> ls
Objects
NAME          PARENTCONTAINER DESCRIPTION
dSource1      - 
dSource2      - 
VDB1          dSource1        -
VDB2          dSource2        -
VDB3          dSource1        -
delphix database> select VDB1

List the VDB parameters, and make a note of the currentTimeflow value.

CODE

delphix database "VDB1"> ls
Properties  
    type: OracleDatabaseContainer    
    name: VDB1    
    currentTimeflow: VDB1/default    
    description: (unset)    
    diagnoseNoLoggingFaults: true    
    endianness: BIG_ENDIAN    
    group: <New Group>    
    masked: false    
    os: HP-UX    
    parentContainer: dSource1    
    performanceMode: false    
    processor: ia64    
    reference: ORACLE_DB_CONTAINER-10    
    runtime:     
        type: OracleDBContainerRuntime        
        logSyncActive: true    
    sourcingPolicy:     
        type: OracleSourcingPolicy        
        encryptedLinkingEnabled: false        
        logsyncEnabled: true        
        logsyncInterval: 300        
        logsyncMode: ARCHIVE_ONLY_MODE   
    version:

Select the Timeflow listed for the VDB.

CODE

delphix database "VDB1"> /timeflow
delphix timeflow> select VDB1/default
List the timeflow parameters.  The Snapshot used to provision the VDB is listed as parentSnapshot

delphix timeflow "VDB1/default"> ls
Properties

List the Timeflow parameters. The Snapshot used to provision the VDB is listed as parentSnapshot.

CODE

delphix timeflow "VDB1/default"> ls
Properties

type: OracleTimeflow    
    name: VDB1/default    
    container: VDB1    
    parentPoint:        
        type: OracleTimeflowPoint        
        location: 141285148        
        timeflow: dSource1/default    
    parentSnapshot: @2013-02-14T15:07:28.491Z    
    reference: ORACLE_TIMEFLOW-92572