Skip to Content
Author's profile photo Former Member

Change the redundancy of the Disk Group of the ASM instance

You want to change the redundancy of the Disk Group of the ASM instance.

Current situation:
/wp-content/uploads/2016/03/img1_917143.png

If you try to dismount/drop:

/wp-content/uploads/2016/03/img2_917144.png



Why?
Because the ASM instance has its spfile on it:

[grid@ora-asm:+ASM ~]$ asmcmd

ASMCMD> spget

+DATA/asm/asmparameterfile/registry.253.907250463

How to procede then

Firts, you need to add another diskgroup (VOL3):

[root@ora-asm ~]# oracleasm createdisk VOL3 /dev/sdd1

Writing disk header: done

Instantiating disk: done

[root@ora-asm ~]# oracleasm listdisks

VOL1

VOL2

VOL3

Present the new disk to asm.  

Create a new DG, this time with External redundancy:

asmca

/wp-content/uploads/2016/03/img3_917145.png

/wp-content/uploads/2016/03/img4_917146.png

Now we have to move the parameter file from +DATA to +DG_GRID.

Create a pfile from spfile, and shutdown the asm instance:

SQL> create pfile=’/tmp/init+ASM.ora’ from spfile;

File created.

SQL> shut immediate;

ASM diskgroups dismounted

ASM instance shutdown

Start from pfile:

SQL> startup pfile=’/tmp/init+ASM.ora’;

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size                  2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ASM diskgroups mounted

SQL> show parameter spfile

NAME TYPE        VALUE

———————————— ———– ——————————

spfile string

There is no spfile configured.


Now, all we have to do is to create a new spfile in the new location DG_GRID:


SQL> create spfile=’+DG_GRID/init.ora’ from pfile=’/tmp/init+ASM.ora’;

File created.

Shutdown and start the instance again, and you can see the spfile created in the new location:


SQL> shut immediate;

ASM diskgroups dismounted

ASM instance shutdown

SQL> startup

ASM instance started

Total System Global Area 1135747072 bytes

Fixed Size 2260728 bytes

Variable Size 1108320520 bytes

ASM Cache 25165824 bytes

ASM diskgroups mounted

SQL> show parameter spfile

NAME                                 TYPE        VALUE

———————————— ———– ——————————

spfile string      +DG_GRID/init.ora

Now, delete (dismount and drop) the old dg DATA, and thats it, you have changed the redundancy of your DG.

asmca

/wp-content/uploads/2016/03/img5_917147.png

/wp-content/uploads/2016/03/img6_917148.png

/wp-content/uploads/2016/03/img7_917149.png

Regards,

Richard W. L. Brehmer

http://www.rbrehmer.com

Assigned tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.