We are implementing 11gR2 (184.108.40.206) RAC in our core-business database. It is actually a set of 3 databases (say DB1 ,DB2 and DB3), and another 4 which are BCV copies (DB1_BCV1, DB1_BCV2, DB2_BCV1, DB3_BCV1). -- all on the same server - HP-UX Itanium 11.31.
Currently we are running on a non-RAC, filesystem setup on Oracle 10gR2, with EMC VNX as our storage.
This is how the Main and BCV DBs work as of now:
1. DB1 --> BCV1 and BCV2. Establish --> Begin Backup --> Split --> End Backup --> Recreate ControlFile with the names DB_BCV1 and DB1_BCV2 accordingly and startup the databases. The copy DB_BCV1 is used for Reporting and BCV2 is used for offline backup after starting as DB1_BCV2.
2. DB2 & DB3 --> BCV1 --> started up as DBx_BCV1 and then offline filesystem backup is taken.
So, my question really is:
How do I do my BCV splits when these databases will be a part of ASM and RAC 11gR2? We will obviously creating separate DISKGROUPs for each database. So, how can I do my BCV splits and start these databases?
Appreciate your expert advice.
As far as I know, EMC BCV works on the basis of physical disks and does not understand or care about content as such. When disks are used under ASM they store a special data header to identify themselves, so I would imagine you can change the ASM diskstring init parameter to point to the BCV disks when necessary. However, you may want to keep in mind that ASM maintains it's own way of striping information and providing redundancy. Since BCV does not understand ASM disk groups it may corrupt data of disk groups that are comprised of several physical disks.
Also BCV may be disk cloning or a snapshot from previous data. The later may not provide a restore option if you loose the complete enchilada.