Backup & Recovery

 View Only

  • 1.  snapshot on Oracle and SQL servers

    Posted Apr 25, 2013 05:36 PM

    All,

    I am a big fan of snapshots for application servers, file servers, etc. I wanted some input on the behavior of taking snapshots of Oracle and SQL severs. Is it supported?

    I am no DBA, but it seems to me it may not be best practice.

    Your input would be greatly appreciated



  • 2.  RE: snapshot on Oracle and SQL servers
    Best Answer

    Posted Apr 25, 2013 05:42 PM

    I'd recommend using the database level snapshot functions builtin into the database engines instead...



  • 3.  RE: snapshot on Oracle and SQL servers

    Posted Apr 25, 2013 05:46 PM

    Thank you for your reply Matt. Is it safe to say that capturing VM snapshots of Oracle and SQL vm's is not supported by the vendors.

    I know vSPhere will of course let you capture the snapshot, but if there is an issue and I need to revert back, I wonder if there could be Databse corruption.



  • 4.  RE: snapshot on Oracle and SQL servers
    Best Answer

    Posted Apr 25, 2013 06:46 PM

    If you are relying solely on VMware snapshots - the answer is yes - it could cause database corruption.

    As Matt said. Database vendor tools should be used for snapshoting your database



  • 5.  RE: snapshot on Oracle and SQL servers

    Broadcom Employee
    Posted Apr 25, 2013 06:50 PM

    This blog article may be of interest:

    http://blogs.vmware.com/vsphere/2013/03/quiescing-oracle-db-windows-vdpa.html



  • 6.  RE: snapshot on Oracle and SQL servers

    Posted Apr 25, 2013 07:11 PM

    Thank you all!!!!!