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: This functionality is available as of Oracle 10g.

Note: Before working with disk groups, 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 select Create from the context menu.

   Note: If this is the first time you have initiated a disk group action since connecting, you are prompted to choose between a connection to the ASM instance or to continue using the default datasource connection. For details on the implications, 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 panel - for details, see Disk Groups (Oracle) - Properties.
   • Disks panel - for details, see Disk Groups (Oracle) - Disks.
   • Templates panel - for details, see Disk Groups (Oracle) - Templates.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
4. Finally, use the Finish button to create the object.

The Disk Groups Editor has properties and options over and above those in the Disk Groups Wizard. 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 (labelled 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 (available as of Oracle 11gR1)	Specify the size of the allocation unit for the disk group.
Compatibility (available as of Oracle 11gR1)	Specify the ASM instance minimum software version.
Database Compatibility (available as of Oracle 11gR1)	Specify the database instance minimum software version.
ADVM Compatibility (available as of Oracle 11gR2)	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, select an entry from the Disks dropdown, optionally provide a Name for the disk, and press TAB or ENTER.

   The disk is added to the Path list on the left, with default attribute values.

2. Proceed to edit the disk attributes.
3. 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 to which the disk is to be added.
Type (available as of Oracle 11GR1)	Lets you select a REGULAR or QUORUM failure group or disk qualifier. If QUORUM is specified at creation, the QUORUM keyword will be specified in any subsequent ALTER statements that will 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: Only custom templates need to be added 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 the New button. The Add new template dialog opens.
2. Use the following table as a guide to providing information on this dialog:

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 and Mirror Region (available as of Oracle 11GR2)	Let you add an ATTRIBUTE disk region clause of HOT/COLD and MIRRORHOT/MIRRORCOLD values to the template definition.

3. Click OK.

To modify a template already in the list

1. Select the template and click the Edit button. 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 and click the Drop button. You are prompted to verify.
2. Click Yes.