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?
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 :
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
Edited by: mseberg on Nov 20, 2012 11:49 AM