员可以来自Sysadmin(sa)ASM的软件可以由RDBMS用户来安装。这样可以加强ASM管理角色。负责管理企业数据库DBA或ORACLE软件负责人同时管理ASM实例存储。 系统管理员(SA)管理OS LUNs(logical unit numbers),修改设备文件属组同时把ASM磁盘与其他主机逻辑卷管理器
不管如何分权和划分权责,下面的动作还是要为ASM存储做的:确定ASM存储需求 根据应用/数据库来确定存储类型,如SATA(Serial Advanced Technology Attachment)还是FC( Fibre Channel)。如果你部署一个分层存储这是一个非常重要的问题。例如,DATA磁盘组可能需要高端FC盘,而Flash磁盘组只需要SATA 磁盘就可以了。确定数据库需要多少空间。确定数据库操作的IOPS数。结合IOPS需求来确定数据库对后端存储磁盘的需求。这个步骤必须要要存储管理员和系统管理员系统完成。
从磁盘阵列预分配磁盘 从存储阵列创建LUNs。这些LUNs可以从RAID(RAID 10 或 RAID 5)组中来划分,映射给合适的主机。在主机层预分配磁盘。 root用户在OS上确认这些LUNs可以被主机识别。为这些LUNs调整权限和属组。
属组和权限修改完成后,ASM可以发现这些盘了。这些盘就可以被添加到已存在的磁盘组或用于创建新的磁盘组了。
创建必要的磁盘组 ASM识别存储阵列提供的磁盘以后,确定如何把这些磁盘分配给磁盘组。 使用已有磁盘组或创建新磁盘组。
如下的ASM v$视图描述了ASM的数据结构和组建:V$ASM_ALIAS This view displays all system- and user-defined aliases.
There is one row for every alias present in every diskgroup mounted by the
ASM instance. The RDBMS instance displays no rows in this view.
V$ASM_ATTRIBUTE This Oracle Database 11gview displays one row
for each ASM attribute defined. These attributes are listed when they are
defined in CREATE DISKGROUPor ALTER DISKGROUPstatements.
DISK_REPAIR_TIMERis an example of an attribute.
V$ASM_CLIENT This view displays one row for each RDBMS instance
that has an opened ASM diskgroup.
V$ASM_DISK This view contains specifics about all disks discovered by
the ASM instance, including mount status, disk state, and size. There is one
row for every disk discovered by the ASM instance.
V$ASM_DISK_IOSTAT This displays information about disk I/O statistics
for each ASM client. If this view is queried from the database instance, only
the rows for that instance are shown.
V$ASM_DISK_STAT This view contains similar content as the V$ASM_
DISK, except V$ASM_DISK_STATreads disk information from cache and
thus performs no disk discovery. This view is primarily used for quick access
to the disk information without the overhead of disk discovery.
V$ASM_DISKGROUPV$ASM_DISKGROUPdisplays one row for every ASM
diskgroup discovered by the ASM instance on the node.
V$ASM_DISKGROUP_STAT This view contains all the similar view contents
as the V$ASM_DISKGROUP, except that V$ASM_DISK_STATreads disk
information from the cache and thus performs no disk discovery. This view
is primarily used for quick access to the diskgroup information without the
overhead of disk discovery.
V$ASM_FILE The V$ASM_FILEview displays information about ASM
files. There is one row for every ASM file in every diskgroup mounted by the
ASM instance. In a RDBMS instance, V$ASM_FILEdisplays no rows.
V$ASM_OPERATION This view describes the progress of an influx ASM
rebalance operation. In a RDBMS instance, V$ASM_OPERATIONdisplays
no rows.
V$ASM_TEMPLATE This view contains information on user- and systemdefined templates.
V$ASM_TEMPLATEdisplays one row for every template
present in every diskgroup mounted by the ASM instance. In a RDBMS
instance,V$ASM_TEMPLATEdisplays one row for every template present
in every diskgroup mounted by the ASM instance with which the RDBMS
instance communicates
如下视图可以在RDBMS和ASM实例中访问见P68
总结 ASM实例管理ASM metadata。ASM实例与ORACLE实例非常相似也有 SGA和绝大多数的后台进程。ASM可以执行类似RDBMS实例的命令。 ASM实例不挂在数据库,但是挂载磁盘组。ASM管理metadata使得 ASM数据文件可以被数据库使用。ASM实例和数据库实例必须可以访问所有的ASM磁盘。当文件打开或创建时ASM实例提供extent map给RDBMS实例。 RDBMS实例基于extent map直接读写磁盘。ASM实例没有在I/0路径中。