Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only

  • 1.  dxtoolkit - get snapshot status runtime.provisionable

    Posted 07-14-2023 08:54:00 AM

    I have written shell script program and embedded 2 jobs. 1. Snapsynch from Production to dSource 2. Refresh VDB from latest snapshot. 

    Since I was doing this at standby side, when snapshot finished it was still not ready for provisioning as it was waiting for few more logs.

    I am looking to check the condition of the snapshot via dxtoolkit. The same option is available in CLI with "runtime.provisionable" status. 

    Can you please help me to achieve this using dxtoolkit commands. 

    Appreciate your response. 

    Regards

    Pravin



    ------------------------------
    Pravin Patil
    Delphix Community Members
    ------------------------------


  • 2.  RE: dxtoolkit - get snapshot status runtime.provisionable

    Posted 07-14-2023 10:50:00 AM

    Hi Pravin,

    I've moved this to the toolkit community.

    Michael



    ------------------------------
    Michael Torok
    Digital Customer Experience, Senior Director
    Delphix
    ------------------------------

    Original Message


  • 3.  RE: dxtoolkit - get snapshot status runtime.provisionable
    Best Answer

    Posted 07-14-2023 02:14:00 PM

    Hello Pravin,

    I checked with our dxtoolkit team and the "dx_get_snapshot" command ( https://github.com/delphix/dxtoolkit/wiki/dx_get_snapshots ) should display something to the effect that a snapshot is not provisionable rather than a start and end date.

    I don't have any databases that are in that state so I can't illustrate it but here is some sample output of provisionable snapshots using the command:

    % ./dx_get_snapshots --engine neal6017 --details -name CDOMSHSRE256PDB1    


    Engine               Group                Database             Snapshot name                  Start time                     End time                       Creation time                  Timeflow   Retentio Vers
    -------------------- -------------------- -------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- -------- ----
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-06-19T10:30:44.581Z      2023-06-19 06:30:43 EDT        2023-06-19 06:30:43 EDT        2023-06-19 06:30:44 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-08T10:30:54.414Z      2023-07-08 06:30:54 EDT        2023-07-09 06:30:54 EDT        2023-07-08 06:30:54 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-09T10:30:53.936Z      2023-07-09 06:30:54 EDT        2023-07-10 06:30:56 EDT        2023-07-09 06:30:53 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-10T10:30:56.056Z      2023-07-10 06:30:56 EDT        2023-07-11 06:30:56 EDT        2023-07-10 06:30:56 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-11T10:30:55.936Z      2023-07-11 06:30:56 EDT        2023-07-12 06:30:51 EDT        2023-07-11 06:30:55 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-12T10:30:51.152Z      2023-07-12 06:30:51 EDT        2023-07-13 06:30:51 EDT        2023-07-12 06:30:51 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-13T10:30:49.618Z      2023-07-13 06:30:51 EDT        2023-07-14 06:30:53 EDT        2023-07-13 06:30:49 EDT        current    Policy   21.3
    neal6017             Oracle               CDOMSHSRE256PDB1     @2023-07-14T10:30:51.418Z      2023-07-14 06:30:53 EDT        2023-07-14 15:10:18 EDT        2023-07-14 06:30:51 EDT        current    Policy   21.3


    % ./dx_get_snapshots --engine neal6017 -name CDOMSHSRE256PDB1        


    Engine                         Group                Database                       Snapshot name                  Start time                     End time
    ------------------------------ -------------------- ------------------------------ ------------------------------ ------------------------------ ------------------------------
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-06-19T10:30:44.581Z      2023-06-19 06:30:43 EDT        2023-06-19 06:30:43 EDT
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-08T10:30:54.414Z      2023-07-08 06:30:54 EDT        2023-07-09 06:30:54 EDT
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-09T10:30:53.936Z      2023-07-09 06:30:54 EDT        2023-07-10 06:30:56 EDT
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-10T10:30:56.056Z      2023-07-10 06:30:56 EDT        2023-07-11 06:30:56 EDT      
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-11T10:30:55.936Z      2023-07-11 06:30:56 EDT        2023-07-12 06:30:51 EDT
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-12T10:30:51.152Z      2023-07-12 06:30:51 EDT        2023-07-13 06:30:51 EDT
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-13T10:30:49.618Z      2023-07-13 06:30:51 EDT        2023-07-14 06:30:53 EDT
    neal6017                       Oracle               CDOMSHSRE256PDB1               @2023-07-14T10:30:51.418Z      2023-07-14 06:30:53 EDT        2023-07-14 15:10:18 EDT    

    Thanks,

    Neal



    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


Related Content