none
Using DPM 2016 to backup Hyper-V server 2016 guest VM running Oracle application

    Question

  • Hi,

    Can I backup a full Hyper-V guest VM running server 2016 with Oracle application.  I am using DPM 2016 to backup full VM's.  Just not sure how windows handle the Oracle database?  

    Will such a backup restore the full system with Oracle DB ok?

    thx


    Robert

    Thursday, March 7, 2019 11:19 PM

All replies

  • Hello Robert,

    Unfortunately DPM doesn't support backing up Oracle databases, however Oracle have their own VSS writer inside the virtual machine (VM) which should put the database into a consistent state during Hyper-V backup that is performed by DPM.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Thursday, March 7, 2019 11:25 PM
  • Sounds like it will backup consistently by default then?  Is that correct?

    Thx


    Robert

    Thursday, March 7, 2019 11:29 PM
  • Yes, it should run consistently, though you might want to have a look at this:

    Volume-Based Shadow Copies
    The Oracle VSS writer supports volume-based shadow copies, which are snapshots of complete drive or volumes. Oracle Database places the files that it manages in a state suitable to create shadow copies. For example, the datafiles are placed in hot backup mode and a new snapshot control file is created for a database in ARCHIVELOG mode. Oracle VSS writer excludes files such as the current control file and online redo logs from the shadow copies. The writer also returns an error if the snapshot cannot be taken. For example, if a NOARCHIVELOG database is open in read/write mode, then the writer returns an error indicating that the snapshot is not possible.

    Reference:
    https://docs.oracle.com/cd/B28359_01/win.111/b32010/vss.htm#NTQRF280


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Friday, March 8, 2019 12:03 AM
    • Proposed as answer by Leon Laude Friday, March 8, 2019 11:51 PM
    Thursday, March 7, 2019 11:34 PM