Please Note:

Convert a baseline ASMFD disk group to a CTE guarded ASMFD disk group using the Online method

We will use the following example scenario in this section:

Number of RAC nodes: 2
Name of Diskgroup: DATA1
Number of disks: 3

Name of baseline disks assigned to raw device:
- DISK1: /dev/sdb1
- DISK2: /dev/sdc1
- DISK3: /dev/sdd1

ASMFD disk group DATA1 was created from baseline ASMFD disks DISK1, DISK2, and DISK3.

DG_NAME         DG_STATE   TYPE       DSK_NO PATH            MOUNT_S FAILGROUP  STATE
--------------- ---------- ------ ---------- --------------- ------- ---------- --------
DATA1           MOUNTED    EXTERN          0 AFD:DISK1       CACHED  DISK1      NORMAL
DATA1           MOUNTED    EXTERN          0 AFD:DISK2       CACHED  DISK2      NORMAL
DATA1           MOUNTED    EXTERN          0 AFD:DISK3       CACHED  DISK3      NORMAL

Objective:

Convert all of the database data on ASMFD disk group DATA1 from baseline to a CTE guarded ASMFD disk group.

Note

The combined capacity of /dev/sdc1 on DISK2 and /dev/sdd1 on DISK3 must be large enough to hold all of the data transferring from ASMFD disk DISK1 on /dev/sdb1.

To convert:

From RAC Node 1:

Connect locally, as the system administrator, to an Oracle ASM instance using OS authentication, type:
```
 sqlplus 'as sysasm'
```
At the ASM prompt, drop the ASMFD disk DATA1 from the disk group DISK1, type:
```
 ALTER DISKGROUP DATA1 DROP DISK DISK1 REBALANCE POWER 11 WAIT;
```
Verify that the ASMFD DISK2 is no longer part of the ASMFD disk group DATA1, type:

sqlplus '/as sysasm' col PATH for a15 col DG_NAME for a15 col DG_STATE for a10 col FAILGROUP for a10 select dg.name dg_name, dg.state dg_state, dg.type, d.disk_number dsk_no,d.path, d.mount_status, d.FAILGROUP, d.state from v$asm_diskgroup dg, v$asm_disk d where dg.group_number=d.group_number and dg.name = 'DATA1';

System Response
```
DG_NAME         DG_STATE   TYPE       DSK_NO PATH            MOUNT_S FAILGROUP  STATE
--------------- ---------- ------ ---------- --------------- ------- ---------- --------
DATA1           MOUNTED    EXTERN          0 AFD:DISK2       CACHED  DISK2      NORMAL
DATA1           MOUNTED    EXTERN          0 AFD:DISK3       CACHED  DISK3      NORMAL
```
Note

Depending on the size of your data, DISK1 might take some time to no longer show in the above query.
From the OS command prompt, drop ASMFD disk DISK1:
```
$GRID_HOME/bin asmcmd afd_unlabel DISK1
```
From the command prompt, verify DISK1 is no longer visible on both RAC Node 1 and 2.
```
$GRID_HOME/bin asmcmd afd_lslbl
```
Using CTE, guard the DISK1 raw partitioned device /dev/sdb1.

From the command prompt, recreate ASMFD disk DISK1, with the guarded raw device /dev/sdb1.

CTE

$GRID_HOME/bin asmcmd afd_label 'DISK1' '/dev/secvm/dev/sdb1'

CTE-U

$GRID_HOME/bin asmcmd afd_label 'DISK1' '/dev/secvmsdb1'

From the command prompt, verify that DISK1 is now visible on both RAC Node 1 and 2 with the newly guarded path:
```
$GRID_HOME/bin asmcmd afd_lslbl
```

From the ASM prompt, add the guarded ASMFD disk DISK1 back to the ASMFD disk group DATA1, type:

 sqlplus 'as sysasm'
 ALTER DISKGROUP DATA1 ADD DISK 'AFD:DISK1' REBALANCE POWER 11 WAIT;

Verify that ASMFD disk DISK1 is now part of ASMFD diskgroup DATA1, type:

sqlplus '/as sysasm' col PATH for a15 col DG_NAME for a15 col DG_STATE for a10 col FAILGROUP for a10 select dg.name dg_name, dg.state dg_state, dg.type, d.disk_number dsk_no,d.path, d.mount_status, d.FAILGROUP, d.state from v$asm_diskgroup dg, v$asm_disk d where dg.group_number=d.group_number and dg.name = 'DATA1';

System Response
```
DG_NAME         DG_STATE   TYPE       DSK_NO PATH            MOUNT_S FAILGROUP  STATE
--------------- ---------- ------ ---------- --------------- ------- ---------- --------
DATA1           MOUNTED    EXTERN          0 AFD:DISK1       CACHED  DISK1      NORMAL
DATA1           MOUNTED    EXTERN          0 AFD:DISK2       CACHED  DISK2      NORMAL
DATA1           MOUNTED    EXTERN          0 AFD:DISK3       CACHED  DISK3      NORMAL
```
Note

Depending on the size of your data, DISK1 might take some time to display in the above query.
Repeat the previous steps for Baseline DISK 2 and DISK 3

Suggest A Change

Convert a baseline ASMFD disk group to a CTE guarded ASMFD disk group using the Online method

On this page