This discussion is archived
1 Reply Latest reply: Nov 20, 2012 10:00 AM by mseberg RSS

VMware snapshot of physical standby

Chuck1958 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points