2 Node RAC 11GR2 Cluster/ASM Duplicate Database To Test Database on Same Host/ASM. Am I missing some
I am in dire need of a sanity check from a RAC expert so I'll make this simple and brief:
I have a 2 Node RAC Cluster, 11GR2 running on Oracle Linux, with a multipath SAN fibrechannel back end via ASM/OMF. It all works perfectly, I installed it fine to customer specs, and it has been solid.
The customer has the reasonable request to make a duplicate copy of the production database for use with testing. This would be on the SAME host, the same two node RAC cluster, and the same Data/FRA diskgroup. In attempting to sort through this process, I can't seem to find any clear examples of how to do this in my environment due to it being same host RAC.
2