Delphix Products

 View Only
Expand all | Collapse all

VDB WAS SHUTDOWN ABORTED via SQLPLUS, how does this affect the VDB and GUI?

  • 1.  VDB WAS SHUTDOWN ABORTED via SQLPLUS, how does this affect the VDB and GUI?

    Posted 12-10-2015 03:07:00 AM
    Hi,

    Our VDB was shutdown by a tester via sqlplus (oracle user). I did not know what was being done and it was taking a long time so another user issued a shutdown abort. We are starup mounting it but it is taking a long time. How does this affect the VDB since these were not performed via the GUI? In case our data got corrupted can we just stop the current VDB, and provision a new VDB using the snapshot a few minutes before it was shutdown? Thank you.



  • 2.  RE: VDB WAS SHUTDOWN ABORTED via SQLPLUS, how does this affect the VDB and GUI?
    Best Answer

    Posted 12-10-2015 05:22:00 PM
    Hi Mark,

    Oracle will typically need to perform some recovery work after an instance failure or in this case a shutdown abort. How long this takes is dependent on what activity in terms of DML (insert,updates, deletes) were occurring at the time the instance was aborted.

    Under normal circumstances, you would not need to provision a new VDB as the Oracle databases recovery mechanisms would resolve any inconsistencies in the data and any transactions that were in a live and uncommitted state at the time of the abort would be rolled back.

    The Delphix Engine should detect the instance was shut down and adjust the status of this VDB accordingly moving it to an INACTIVE state. Upon restarting it whether this be through sqlplus or through the Delphix GUI the VDB Status should return to RUNNING.


    (I saw that you also created a support case for the same issue and have posted the answer here for continuity)