Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot perform ASM cloning with EMC BCV sync/split

Srinivas.RJun 19 2008 — edited Jun 20 2008
We have a ASM instance (RAC) on two notes (+ASM1 and +ASM2 respectively).

We wanted to use EMC BCV sync/split to clone the source database. Here are the details

Source
----------
ASM Instance = +ASM1(RAC)
DB Instance = TESTASM (In diskgroup TESTASM_DG)
10.2.0.3 versions both

Target
--------
1) ASM Instance = +ASM2 (RAC)
2) I first created a new diskgroup called TESTASM2_DG (note the 2 in the name) and mounted it.
3) put source TESTASM db in hotbackup mode
4) unix SA did the BCV sync split.

What happenend then was the diskgroup name on the target became TESTASM_DG now (i guess this is because the diskgroup name is stored in the disk header). I was not able to mount it on target. It says ASM disk header corruption.

So then i thought let me re do this and here are the changes

Target
---------
1) Create TESTASM_DG diskgroup (same name as the source). - But create diskgroup failed with

create diskgroup TESTASM_DG
external redundancy DISK '/dev/rdsk/c12t1d4';

ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15030: diskgroup name "TESTASM_DG" is in use by another diskgroup

drop diskgroup TESTASM_DG
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-15001: diskgroup "TESTASM_DG" does not exist or is not mounted

Questions
--------------
1) Why is ASM2 saying TESTASM_DG is already in use ? Yes it is being used on the source node by ASM1. So does it mean that a RAC ASM cluster cannot have two same diskgroup names on each of the nodes in this cluster ?

If there is this restriction, then how do we perform BCV sync/split. We use BCV sync/split as our database cloning option. There are other things like RMAN DUPLICATE etc, but that is not feasible for us because of time taken and other performance issues. BCV sync/split is very fast and we want to use it even after ASM

Will most appreciate your help on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2008
Added on Jun 19 2008
14 comments
5,102 views