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.
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)