Guru Conversation for the
Senior DBA
Congratulations,
now there are 8 disks
of 10 Giga bytes each. These are free devices available for use
by the ASM setup.
The
DBCA can be used for
these files in the
new database or add them using SQL*Plus commands.
CREATE
DISKGROUP dskgrp01 NORMAL REDUNDANCY
FAILGROUP fgcontrol01 DISK ‘/dev/raw/raw1’,
FAILGROUP fgcontrol02 DISK ‘/dev/raw/raw2’ ;
These files will show up in the init.ora
file of the ASM instance as ASM_DISKSTRING='/dev/raw/raw*'.
Conclusion
This chapter
explored the
Automatic Storage Management (ASM) features of Oracle Database
10g. The salient points are as follows.
-
Automatic Storage Mechanism (ASM)
will create and manage the underlying files for database
structures.
-
For the ASM architecture, Oracle
Database 10g utilizes a separate smaller database instances
installed in a separate oracle home, created during database set
up.
-
ASM instance manages the metadata
that is needed to make ASM files available to regular database
instances.
-
ASM instance and database
instances have access to a common set of disks called disk
groups.
-
ASM instance is expected to
always be up and running on the host.
