Disk Groups Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

This editor lets you work with basic properties, individual disks, and attribute templates for an existing disk group. It also lets you work at the individual file and alias level as well as view current operations executing against the disk group.

Note: This functionality is available for Oracle 10 g.
Note: When opening the editor, 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.
Note: If you do not have a connection to the ASM instance, you van view but cannot modify property values in the Disk Groups Editor.

To edit a disk group:

  1. On a connected Oracle datasource, expand the Instance and ASM nodes.
  2. In the right-hand pane, right-click a disk group and select Edit from the context menu.
  3. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Later versions of Oracle offer different properties for this object type:

10G

This tab lets you view the Name, Redundancy Level, and Group State values you chose on creating the disk group. For details on these properties, see Disk Groups (Oracle) - Properties. A Group Number for the disk group is also displayed. The General group displays properties corresponding to disk group attributes or information available from V$ASM views: Block Size, Total MB, Free MB, Required Mirror Free MB, Usable File MB, Offline Disks, and Is Unbalanced. The Attributes group displays Allocation Unit Size, Compatibility, Database Compatibility, and Sector Size properties.

11GR1

As of Oracle 11GR1, the Compatibility and Database Compatibility, properties can be modified. For details on these properties, see Disk Groups (Oracle) - Properties. A Disk Repair Time property can also be modified.

11GR2

The File Access Control Enabled and Access Control Unmask properties let you add ACCESS_CONTROL.ENABLED (whether Oracle ASM File Access Control is enabled for the disk group) or ACCESS_CONTROL.UMASK (a three-digit number that masks out permissions) attributes. Consult Oracle documentation for details on these attributes.

Disks

The Path list on this tab lets you view the disks currently assigned to this disk group. With a Path list disk selected, the Property/Value list displays attributes for that disk. The Creation category shows disk creation and mount date details as well as the setting you chose when adding this disk. For details on these properties, see Disk Groups (Oracle) - Disks. The Property/Value list differs by version

10G

The General, Status, Size, and Statistics categories display information returned from the LSATTR, LSDSK, and LSDG commands (V$ASM_ATTRIBUTE, V$ASM_DISKGROUP_STAT, V$ASM_DISKGROUP, V$ASM_DISK_STAT, and V$ASM_DISK views) as follows: General - Compound Index, Incarnation, Redundancy, Library, Label, UdID, and Product. Status - Mount Status, Header Status, and Mode Status. Size - Free MB. Statistics - Repair Timer, Reads, Writes, Read Errors, Write Errors, Read Time, Write Time, Bytes Read, and Bytes Written.

11GR1

The key differences for the 11gR1 release are the Mode Status, Online Wait, and Offline Timeout controls. Mode Status - Lets you bring a single disk ONLINE or OFFLINE. Online Wait - Enabled when bring a disk ONLINE, lets you select WAIT or NOWAIT. Offline Timeout - Enabled when taking a disk offline, lets you specify the amount of time after which the disk will be dropped after the status changes to OFFLINE.

11GR2

A Type property with REGULAR and QUORUM values is available.

Volumes (available as of Oracle 11GR2)

Lets you manage (add, edit, delete) volumes associated with the disk group.

Templates

This tab lets you maintain the list of named attributes applied to disks in this disk group. Note that System Templates are automatically created for the disk group when the group is created. For details on template attributes and information on adding, editing, and deleting templates, see Disk Groups (Oracle) - Templates.

Files (disabled unless you have a direct connection to the ASM instance)

The Directories list is a representation of the ASM virtual folder. On creation, the list is populated with the system directory hierarchy dictated by the ASM fully qualified file name convention. Use the associated buttons to create new directories, delete user-created directories, or modify the directory name or base directory of a user-created directory. The Files and Aliases list contains files generated automatically as part of database operations (including tablespace creation) and user-created aliases. Selecting a file or alias from the list displays its attributes in the Property/Value list on the right. Use the associated buttons to create an alias to a selected file, delete files or aliases, or modify the name or base directory of a user-created alias.

Operations (disabled unless you have a direct connection to the ASM instance)

Displays any commands currently running on the ASM instance.

Users and Groups (available as of Oracle 11GR2)

These tabs apply only to Oracle 11GR2 datasources installed on Linux/Unix computers. Permissions/ownership are also dependent on the File Access Control Enabled and Access Control Unmask values on the Properties tab. These tabs lets you manage the File Access Control users and user groups.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

4. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.