Shulou(Shulou.com)06/01 Report--

Refer to Rename Diskgroup having OCR, Vote File, ASM SPILE (document ID 1335975.1)

Goal:

Consider a 11.2 Grid Infrastructure with CLUSTER setup having OCR, Vote File and ASM SPFILE on a diskgroup.

Under certain circumstances you may wish to rename that diskgroup.

"renamedg" utility can be used to rename of the diskgroup when the diskgroup is dismounted.

But since the diskgroup contains OCR and Vote File we need to use an intermediate diskgroup for storing OCR and Vote File temporarily while renaming the actual diskgroup.

Change the condition description:

-> Name of Temporary diskgroup is TEMP.

-> OCR,Voting Disks and ASM SPFILE are originally stored ina diskgroup DATA.

-> Diskgroup DATA should be renamed to CRS.

-> $ORACLE_HOME points to GRID Home.

-> Cluster is up and running in all nodes of RAC.

Action:

1 create a temporary disk group:

Login as SYSASM using SQLPLUS into ASM instance on one node and run below commands:

Sqlplus'/ as sysasm'

Create diskgroup TEMP normal redundancy disk'/ dev/asm11','/ dev/asm12','/ dev/asm13' attribute 'compatible.rdbms'='11.2.0.0',' compatible.asm'='11.2.0.0', 'au_size'='4M'

2 Migration

Move OCR and Vote file from DATA to:

$ORACLE_HOME/bin/bin/ocrconfig-add + TEMP

$ORACLE_HOME/bin/bin/ocrconfig-delete + DATA

$ORACLE_HOME/bin/crsctl replace votedisk + TEMP

Successful addition of voting disk 9d351cfdbef64facbfe2d1519880ef33.

Successful addition of voting disk 302c23b19e864f92bfa68eda9045e5cc.

Successful addition of voting disk 6eeca4920acb4f8fbf6ec5a4e2b8ea7b.

Successful deletion of voting disk 32f7d65cf17d4fa3bf2932998251635f.

Successful deletion of voting disk 10c31fb0891d4f5abfb38ef34cd49f4d.

Successful deletion of voting disk 7d6f7d6480554f01bfc2621a3adb8f5f.

Successfully replaced voting disk group with + TEMP.

CRS-4266: Voting file (s) successfully replaced

Check integrity

$ORACLE_HOME/bin/crsctl query css votedisk

# # STATE File Universal Id File Name Disk group

1. ONLINE 9d351cfdbef64facbfe2d1519880ef33 (ORCL:DISK4) [TEMP]

2. ONLINE 302c23b19e864f92bfa68eda9045e5cc (ORCL:DISK5) [TEMP]

3. ONLINE 6eeca4920acb4f8fbf6ec5a4e2b8ea7b (ORCL:DATA4) [TEMP]

Located 3 voting disk (s).

$ORACLE_HOME/bin/ocrcheck

Status of Oracle Cluster Registry is as follows:

Version: 3

Total space (kbytes): 262120

Used space (kbytes): 2804

Available space (kbytes): 259316

ID: 1778064925

Device/File Name: + TEMP

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

3 migrate spfile, migrate from DATA to TEMP diskgroup

Change ASM SPFILE location from DATA to TEMP diskgroup.

Sqlplus'/ as sysasm'

Create pfile='/tmp/init/init' from spfile

Create spfile='+TEMP' from pfile='/tmp/init/init'

Now GPNPTOOL will get updated with new ASM SPFILE location.

That can be verified by below command:

$ORACLE_HOME/bin/gpnptool get

4 2 nodes restart crs

Restart CRS on all nodes to startup CRS using new SPFILE from TEMP diskgroup

Crsctl stop crs

Crsctl start crs

5 uninstall OLD disk (i.e. data disk)

Dismount the OLD Diskgroup on all cluster nodes

Login as SYSASM using SQLPLUS into ASM instance on one node and run below commands:

Sqlplus'/ as sysasm'

Alter diskgroup data dismount

6 rename OLD disk (that is, rename data disk to CSS disk)

Rename OLD diskgroup to NEW diskgroup name

Renamedg phase=both dgname=DATA newdgname=CRS verbose=true

Query disk information

Set line 1000

Set pages 599

Col path format a30

Select name,path,group_number,header_status,total_mb,free_mb from v$asm_disk

Select name,state,usable_file_mb,total_mb,free_mb,required_mirror_free_mb from v$asm_diskgroup

7 Mount CRS disk

Mount the renamed diskgroup on All the nodes

Login as SYSASM using SQLPLUS into ASM instance on one node and run below commands:

Sqlplus'/ as sysasm'

Alter diskgroup CRS mount

Query disk information

Select name,state,usable_file_mb,total_mb,free_mb,required_mirror_free_mb from v$asm_diskgroup

8 migrate OCR and vote file to the new disk CRS

Move OCR and Vote file from TEMP Diskgroup to CRS Diskgroup

$ORACLE_HOME/bin/ocrconfig-add + CRS

$ORACLE_HOME/bin/ocrconfig-delete + TEMP

$ORACLE_HOME/bin/crsctl replace votedisk + CRS

Successful addition of voting disk ae0f06430e724fb7bf3757a7cdf8a101.

Successful addition of voting disk 1b355413f5904f5abff181938191ed97.

Successful addition of voting disk a7f75c9872ac4f6fbf77bbcb10ea17a6.

Successful deletion of voting disk 9d351cfdbef64facbfe2d1519880ef33.

Successful deletion of voting disk 302c23b19e864f92bfa68eda9045e5cc.

Successful deletion of voting disk 6eeca4920acb4f8fbf6ec5a4e2b8ea7b.

Successfully replaced voting disk group with + CRS.

CRS-4266: Voting file (s) successfully replaced

9 modify spfile path

Change ASM SPFILE location from TEMP to CRS Diskgroup:

Login as SYSASM using SQLPLUS into ASM instance on one node and run below commands

Sqlplus'/ as sysasm'

Create spfile='+CRS' from pfile='/tmp/init/init'

102 nodes restart crs

Restart CRS on all nodes to startup CRS using new SPFILE from TEMP diskgroup

Crsctl stop crs

Crsctl start crs

11 Delete temporary TEMP disk group

Drop the Intermediate Diskgroup TEMP

Login as SYSASM using SQLPLUS into ASM instance on one node and run below commands::

Drop diskgroup temp including contents

NOTE: Diskgroup TEMP must be mounted in order to be able to drop it.You need to mount it (if it is not already mounted at CRS startup) and then run "drop diskgroup.."

12 delete disk information

Need to Remove the Diskgroup Resources TEMP and from Oracle Clusterware

Srvctl remove diskgroup-g DATA

Srvctl remove diskgroup-g TEMP

13 verify information

Ensure ALL Cluster resources are started successfully using below sample commands

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

$ORACLE_HOME/bin/crsctl check cluster-all

$ORACLE_HOME/bin/crsctl stat res-t

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.