1 Reply Latest reply: Nov 20, 2012 12:00 PM by mseberg RSS

    VMware snapshot of physical standby

    Chuck1958
      I want to do DR testing using my physical standby database. That database is on a VMware VM (guest OS is Windows 2008 R2). The standby is using maximum performance with real-time apply.

      My plan is this...

      1) take a vmware snapshot
      2) activate the standby
      3) do the testing
      4) roll back to the vmware snapshot

      It all sounds simple and straight forward. I just wanted to ask about it here first to make sure I'm not overlooking something.

      I thought about using flashback on the physical standby but I thought I remember reading somewhere that a separate license was required for that.

      One more thing. Would it be better to DEFER that standby location throughout the test? I think if I leave it on it will simply continue to write to the standby logs but they will be ignored. When I roll back to the snapshot, the standby should recognize the gaps and automatically resolve them. Am I missing anything?

      TIA
        • 1. Re: VMware snapshot of physical standby
          mseberg
          Hello;

          Yes I would DEFER.

          I don't see that you have missed anything. I use these a ton for testing and they work great.

          Generally I do these with everything oracle down.

          Additional Information :

          http://www.vmware.com/files/pdf/Oracle_Databases_on_vSphere_-UseCases.pdf

          http://www.vmware.com/files/pdf/solutions/DBA_Guide_to_Databases_on_VMware-WP.pdf

          Virtual Machine Backup Guide - http://www.vmware.com/pdf/vi3_vm_backup.pdf

          Consolidated Backup in Vmware Infrastructure 3 - http://www.vmware.com/pdf/vi3_consolidated_backup.pdf

          Vmware Consolidated Backup Best Practices, Tips and Tricks - http://download3.vmware.com/vmworld/2006/bct4540.pdf




          Best Regards

          mseberg

          Edited by: mseberg on Nov 20, 2012 11:49 AM