Skip to main content
Skip table of contents

CLI cookbook: determining the snapshot used to provision a VDB

Procedure:

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

  1. Log into the server as a Engine Administrator:

    CODE
    ssh admin@<server_ip>
  2. 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
  3. 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:
  4. 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
  5. 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
JavaScript errors detected

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

If this problem persists, please contact our support.