Users who connect to an ASM instance as SYSDBA can perform all ASM operations, such as
creating and deleting disk groups as well as adding and removing disks from disk groups.
The SYSOPER users have a much more limited set of commands available in an ASM instance.
In general, the commands available to SYSOPER users give only enough privileges to perform
routine operations for an already configured and stable ASM instance. The following list contains
the operations available as SYSOPER:
Starting up and shutting down an ASM instance
Mounting or dismounting a disk group
Altering a disk group??™s disk status from ONLINE to OFFLINE, or vice versa
Rebalancing a disk group
Performing an integrity check of a disk group
Accessing the V$ASM_* dynamic performance views
ASM Initialization Parameters
A number of initialization parameters are either specific to ASM instances or have new values
within an ASM instance. An SPFILE is highly recommended instead of an initialization parameter
file for an ASM instance. For example, parameters such as ASM_DISKGROUPS will automatically
be maintained when a disk group is added or dropped, potentially freeing you from ever having
to manually change this value.
We will present the ASM-related initialization parameters in the following sections.
?–
?–
?–
?–
?–
?–
102 Oracle Database 11g DBA Handbook
INSTANCE_TYPE For an ASM instance, the INSTANCE_TYPE parameter has a value of ASM.
Pages:
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201