Oracle RAC ASM Multi-Disk Offline Method (Backup/Restore)

Using the Offline Method assumes that there is not enough free space in the diskgroup.

1. Open a terminal session on both RAC Nodes.

2. On RAC Node 1, on the ASM, type the following to remove the disk group.

   SQL> DROP DISKGROUP <diskGroupName> FORCE INCLUDING CONTENTS;
   

   Note

   Make sure that the disk is removed before guarding the raw devices.

3. On both RAC Node 1 and 2 type:

    chown oracle:oinstall /dev/<rawDevice1Name>
    chmod 660 /dev/<rawDevice1Name>
    chown oracle:oinstall /dev/<rawDevice2Name>
    chmod 660 /dev/<rawDevice2Name>
    chown oracle:oinstall /dev/<rawDevice3Name>
    chmod 660 /dev/<rawDevice3Name>
   

4. On the CipherTrust Manager, in the Host Group, apply GuardPoints to the three raw devices:

   <rawDeviceName1>
   <rawDeviceName2>
   <rawDeviceName3>
   

5. On RAC Node 1, to display the status of the guarded disks, type:

    secfsd -status guard
   

6. On both RAC Node 1 and 2, type:

    chown oracle:oinstall /dev/secvm/dev/<rawDeviceName1>
    chmod 660 /dev/secvm/dev/<rawDeviceName1>
    chown oracle:oinstall /dev/secvm/dev/<rawDeviceName2>
    chmod 660 /dev/secvm/dev/<rawDeviceName2>
    chown oracle:oinstall /dev/secvm/dev/<rawDeviceName3>
    chmod 660 /dev/secvm/dev/<rawDeviceName3>
   

7. From RAC Node 1, on the ASM, add the protected disk to the disk group, type:

   SQL> ALTER DISKGROUP <diskGroupName> ADD DISK /dev/secvm/dev/<rawDeviceName1> NAME <diskName1>;
   SQL> ALTER DISKGROUP <diskGroupName> ADD DISK /dev/secvm/dev/<rawDeviceName2> NAME <diskName2>;
   SQL> ALTER DISKGROUP <diskGroupName> ADD DISK /dev/secvm/dev/<rawDeviceName3> NAME <diskName3>;
   

   The disks are now added to the diskgroup and ready for use.

8. On RAC Node 1, restore the database.

9. The system is now ready for a reboot and failover test. Go to the Surviving the Reboot and Failover Testing.