We're looking at reducing our downtime windows for our Oracle environments. Most of the downtime are required for Oracle patching, for both database more importantly Oracle Applications (ERP) patching and upgrades which sometimes takes a couple of days. During this time, of course, the database is not available to users.
I have a few questions.
1. Can we use VVR to replicate our PROD1 database to PROD2 and then before patching/upgrade:
a. Switch the database over to PROD2.
b. Allow users update access to PROD2.
c. Patch/upgrade PROD1.
d. When PROD1 is finished, sync PROD1 and PROD2.
e. Bring PROD1 back online for user access.
Of course, all updates to PROD2 and to PROD1 during PROD1's patching/upgrade will be there at the end in PROD1.
Can this be done (may be together with VCS)? If not, then question 2 below.
2. Can VVR replace Oracle DataGuard? What are the benefits and drawbacks? I've read some of the articles from Oracle about the benefits and drawbacks of both products, but I'd like to hear from people who have used VVR and VCS in an Oracle environment.
3. What about VCS? Can it replace Oracle RAC? What are the pros and cons?
Also, can you point me to some documents/white papers that talks about using VVR and VCS to achieve 24x7 Oracle environment?
Thank you for any input.