Move OCR, Voting Disk File, ASM SPILE to a New Diskgroup ( 11.2.0.4 )

Below exercise is to move everything from old OCR/VOTING diskgroup OCR_VOTE  to new diskgroup OCR_VOTE2.

1)Create New CRS Diskgroup:

SQL> create diskgroup OCR_VOTE2 external redundancy disk 'ORCL:OCR_VOTE2';

Diskgroup created.

SQL> alter diskgroup OCR_VOTE2 set attribute 'compatible.asm'='11.2.0.0';

Diskgroup altered.

2) Mount the Diskgroup if Not Yet.

SQL> alter diskgroup OCR_VOTE2 mount;
alter diskgroup OCR_VOTE2 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "OCR_VOTE2" cannot be mounted
ORA-15013: diskgroup "OCR_VOTE2" is already mounted

3) Move OCR and Vote file from Old Diskgroup to New Diskgroup.

# export ORACLE_HOME=/u01/app/11.2.0.4/grid
# $ORACLE_HOME/bin/ocrconfig -add +OCR_VOTE2

# $ORACLE_HOME/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
 1. ONLINE 2acf2e1fd3524ffebf39abf0235da8bb (ORCL:OCR_VOTE1) [OCR_VOTE]
Located 1 voting disk(s).

# $ORACLE_HOME/bin/ocrconfig -delete +OCR_VOTE

# $ORACLE_HOME/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
 1. ONLINE 2acf2e1fd3524ffebf39abf0235da8bb (ORCL:OCR_VOTE1) [OCR_VOTE]
Located 1 voting disk(s).

# $ORACLE_HOME/bin/crsctl replace votedisk +OCR_VOTE2
Successful addition of voting disk aed2371729704f38bff6cb2716ba90f5.
Successful deletion of voting disk 2acf2e1fd3524ffebf39abf0235da8bb.
Successfully replaced voting disk group with +OCR_VOTE2.
CRS-4266: Voting file(s) successfully replaced

# $ORACLE_HOME/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
 1. ONLINE aed2371729704f38bff6cb2716ba90f5 (ORCL:OCR_VOTE2) [OCR_VOTE2]
Located 1 voting disk(s).

# $ORACLE_HOME/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
 Version : 3
 Total space (kbytes) : 262120
 Used space (kbytes) : 3736
 Available space (kbytes) : 258384
 ID : 2091720096
 Device/File Name : +OCR_VOTE2
 Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

4) Change ASM spfile location from Old DiskGroup to New DiskGroup

SQL> show parameter spfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +OCR_VOTE/blc5/asmparameterfil e/registry.253.767457217

SQL> create pfile='/tmp/tmp.ora' from spfile;

File created.

SQL> ! cat /tmp/tmp.ora
+ASM1.__large_pool_size=29360128
+ASM1.__oracle_base='/u01/app/grid'#ORACLE_BASE set from in memory value
+ASM1.__shared_pool_size=230686720
+ASM2.asm_diskgroups='FRA','DG1'#Manual Mount
+ASM1.asm_diskgroups='DG1','FRA','OCR_VOTE2'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.memory_target=1073741824
*.remote_login_passwordfile='EXCLUSIVE'

SQL> create spfile='+OCR_VOTE2' from pfile='/tmp/tmp.ora';

File created.

SQL> ! $ORACLE_HOME/bin/gpnptool get
Warning: some command line parameters were defaulted. Resulting command line:
 /u01/app/11.2.0.4/grid/bin/gpnptool.bin get -o-

<?xml version="1.0" encoding="UTF-8"?><gpnp:GPnP-Profile Version="1.0" xmlns="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:gpnp="http://www.grid-pnp.org/2005/11/gpnp-profile" xmlns:orcl="http://www.oracle.com/gpnp/2005/11/gpnp-profile" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.grid-pnp.org/2005/11/gpnp-profile gpnp-profile.xsd" ProfileSequence="11" ClusterUId="7fd95a772df4df5ebf03f302598ae4f1" ClusterName="BLC5" PALocation=""><gpnp:Network-Profile><gpnp:HostNetwork id="gen" HostName="*"><gpnp:Network id="net1" IP="10.4.15.0" Adapter="bond0" Use="public"/><gpnp:Network id="net2" IP="10.4.14.0" Adapter="bond1" Use="cluster_interconnect"/></gpnp:HostNetwork></gpnp:Network-Profile><orcl:CSS-Profile id="css" DiscoveryString="+asm" LeaseDuration="400"/><orcl:ASM-Profile id="asm" DiscoveryString="" SPFile="+OCR_VOTE2/blc5/asmparameterfile/registry.253.950184589"/><ds:Signature xmlns:ds="http://www.w3.org/2000/09/xmldsig#"><ds:SignedInfo><ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/><ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/><ds:Reference URI=""><ds:Transforms><ds:Transform Algorithm="http://www.w3.org/2000/09/xmldsig#enveloped-signature"/><ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"> <InclusiveNamespaces xmlns="http://www.w3.org/2001/10/xml-exc-c14n#" PrefixList="gpnp orcl xsi"/></ds:Transform></ds:Transforms><ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/><ds:DigestValue>7qFsk4u0KgpO52RoVbHjlk2dAzk=</ds:DigestValue></ds:Reference></ds:SignedInfo><ds:SignatureValue>T2vB/oL0FAq1Qvnk8A2bXutSzlxGHpHvPXElTHAj+ctYSoAuVuDa9arni3AOYjz3NjhHWjjAI9zCaQAJ+Rue0vtom4TFFpGHsw+ogxPurgZc74plFGd0Fv7wmztHBOwveQ4rG4AJ4PViLxM0ECwymfD08494jPEihb29wVki6js=</ds:SignatureValue></ds:Signature></gpnp:GPnP-Profile>
Success.

5) Stop and Start CRS, then verify.

a: $ORACLE_HOME/bin/crsctl stop crs
b: $ORACLE_HOME/bin/crsctl start crs

SQL> select name,state,usable_file_mb,total_mb,free_mb,required_mirror_free_mb from v$asm_diskgroup;

NAME STATE  USABLE_FILE_MB  TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB
----- ----- --------------- -------- -------- ----------------------
DG1 MOUNTED 266999          1536213    266999 0
FRA MOUNTED 671329          1024142    671329 0
OCR_VOTE2 MOUNTED 20126       20479     20126 0
OCR_VOTE DISMOUNTED 0             0         0 0

$ $ORACLE_HOME/bin/crsctl stat res -init -t

$ $ORACLE_HOME/bin/ocrcheck
 Status of Oracle Cluster Registry is as follows :
 Version : 3
 Total space (kbytes) : 262120
 Used space (kbytes) : 3736
 Available space (kbytes) : 258384
 ID : 2091720096
 Device/File Name : +OCR_VOTE2
 Device/File integrity check succeeded

Device/File not configured  

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check bypassed due to non-privileged user

$ $ORACLE_HOME/bin/crsctl query css votedisk

## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
 1. ONLINE aed2371729704f38bff6cb2716ba90f5 (ORCL:OCR_VOTE2) [OCR_VOTE2]

SQL> show parameter pfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +OCR_VOTE2/blc5/asmparameterfile/registry.253.950184589
Advertisements
This entry was posted in ASM, GI and RAC and tagged , , , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s