Disk Groups Wizard (Oracle)

Go Up to Oracle Object Wizards

This wizard builds a CREATE DISKGROUP statement with redundancy and state properties, the associated disks and their properties, and attribute templates.

Note: Before working with disk groups, please consult Oracle documentation for general information on disk groups and ASM instances, and details on ASM operation and related permissions requirements. For more information, see Accessing Third Party Documentation.

To create a disk group using a wizard

1. On a connected Oracle datasource, expand the Instance and ASM nodes.
2. Right-click the Disk Groups node, and then select Create from the context menu.

   Note: If this is the first time you have initiated a disk group action since connecting, you must choose between a connection to the ASM instance or to continue using the default datasource connection. For more infomration about this feature, see Manage ASM Connection.

3. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
   • Properties. For details, see Disk Groups (Oracle) - Properties.
   • Disks. For details, see Disk Groups (Oracle) - Disks.
   • Templates. For details, see Disk Groups (Oracle) - Templates.
   • DDL View. For details, see Previewing the DDL Generated to Create the New Object.
4. Click Finish to create the object.

The Disk Groups Editor includes additional properties and options. For details, see Disk Groups Editor (Oracle).

Disk Groups (Oracle) - Properties

When creating or editing a disk group, this tab/panel lets you work with the following settings:

Setting	Description
Name	Provide a name for the disk group.
Redundancy Type	Lets you select a REDUNDANCY clause value of NORMAL, EXTERNAL, or HIGH.
Group State After Creation / Group State	(Group State when editing an existing disk group). Lets you select an initial disk group state of MOUNTED or DISMOUNTED. By default, the disk group is MOUNTED after creation. If you select DISMOUNTED, an ALTER statement is executed to change the state of the disk group to DISMOUNTED after creation.
Allocation Unit Size	(Oracle 11gR1 and later only). Specify the size of the allocation unit for the disk group.
Compatibility	(Oracle 11gR1 and later only). Specify the ASM instance minimum software version.
Database Compatibility	(Oracle 11gR1 and later only). Specify the database instance minimum software version.
ADVM Compatibility	(Oracle 11gR2 and later only). Lets you add an ATTRIBUTE ‘COMPATIBLE.ADVM’ =... clause, specifying whether the disk group can contain ASM columns.

Disk Groups (Oracle) - Disks

When creating or editing a disk group, this tab/panel lets you manage the disks of the disk group and their properties.

To add a disk to the group

1. Click Add.
2. Select an entry from the Disks dropdown.
3. Optional. Provide a Name for the disk.
4. Press TAB or ENTER.

   The disk appears in the Path list on the left, with default attribute values.

5. Proceed to edit the disk attributes.
6. Add more disks as necessary.

To edit disk attributes

1. Select the disk in the Path list on the left. The controls in the Property / Values list are updated with values of the selected disk.
2. Use the following table as a guide to providing additional property values.

Property or Group	Description
Size	Specify a disk size in KB, MB, or GB.
Failure Group	Specify the failure group where you want to add the disk.
Type (available as of Oracle 11GR1)	(Oracle 11gR1 and later only). Lets you select a REGULAR or QUORUM failure group or disk qualifier. If QUORUM is specified at creation, the QUORUM keyword is specified in any subsequent ALTER statements that affect the disk or the failgroup.
Force	If selected, the disk is added to the disk group even if the disk is already a member of a different disk group.

To delete a disk from the disk group

1. Select a disk from the Path list.
2. Click Delete.

Disk Groups (Oracle) - Templates

When creating or editing a disk group, this tab/panel lets you manage disk group template clauses submitted with the CREATE/ALTER DISKGROUP statement. Each template is a named set of attributes applied to files on the disk group.

{{Note|Add only custom templates when creating a disk group. The System Templates (CONTROL, DATAFILE, ONLINELOG, ARCHIVELOG, TEMPFILE, BACKUPSET, PARAMETERFILE, DATAGUARDCONFIG, FLASHBACK, CHANGETRACKING, DUMPSET, XTRANSPORT, and AUTOBACKUP) are automatically created for the disk group when the group is created. For more information, see Disk Groups Editor (Oracle).

To add a template to the list of disk template clauses for this disk group

1. Click New. The Add new template dialog opens.
2. Use the following table as a guide to providing information on this dialog, and then click OK when done creating the new template.

Setting	Description
Name	Provide a name for the template.
Stripe	Select COARSE to stripe files every 1MB. Select FINE to stripe files every 128KB.
Redundancy	Select a redundancy level of UNPROTECTED, MIRROR, PARITY, or HIGH.
Primary Region / Mirror Region	(Mirror Region for Oracle 11gR2 and later only). Lets you add an ATTRIBUTE disk region clause of HOT/COLD and MIRRORHOT/MIRRORCOLD values to the template definition.

To modify a template already in the list

1. Select the template, and then click Edit. The Edit template dialog opens.
2. Use the table above as a guide to providing information on this dialog.
3. Click OK.

To delete a template from the list

1. Select the template you want to delete, and then click Drop. You are prompted to verify.
2. Click Yes.