asm 文档

1

Oracle Database 11g Release 1 and 10g Release 2

Automatic Storage Management

Overview and Technical Best Practices

2

ASM installation

.......................................................................................................... 6

ASM and privileges

...................................................................................................... 8

............................................................................................................................ 9

............................................................................................................................... 10

Database consolidation and clustering

............................................................................ 18

11gR1 ASM and Rolling Upgrade

ASM – Database Multi-Version Support

Database processes to support ASM

Database Init.ora parameters to support ASM

ASM and database shutdown dependencies

..................................................................... 21

ASM and database deployment Best Practices

............................................................................................... 23

................................................................................................................ 25

..................................................................................... 30

............................................................................................................. 31

....................................................................................................................... 33

............................................................................... 34

................................................... 35

...................................................................... 36

............................................................................................. 37

3

Introduction

command line utility (new in Oracle Database 10g Release 2) is also available for those ASM

administrators who are not familiar with SQL.

ASM is a management tool specifically built to simplify the job of the DBA. It provides a simple storage

management interface across all server and storage platforms. ASM provides the DBA flexibility to

manage a dynamic database environment with increased efficiency. This feature is a key component of

Grid Computing and Database Storage Consolidation.

The following are some key benefits of ASM:

functionality.

contain ASM and non-ASM files. Any new files can be created as ASM files whilst existing files

can also be migrated to ASM.

4

and eventually create a database within an ASM diskgroup, discussing some best practices along the way.

Automatic Storage Management in Oracle Database 10g Release 2 expands the capabilities of ASM and

provides features and enhancements in the following categories:

o Command Line Interface (CLI)

o ASM file system view through XMLDB virtual folders

o Enhanced ASM manageability and alerts

o Enhancements in DBMS_FILE_TRANSFER utility

This paper will introduce the new features of Automatic Storage Management (ASM) in Oracle Database

10g Release 2, and describe the benefits and improvements in simplification and automation for managing

Oracle database files.

5

ASM Instances

Upon startup, an ASM instance will spawn all the basic background processes, plus some new ones that are

specific to the operation of ASM. The STARTUP clauses for ASM instances are similar to those for

database instances. For example, RESTRICT prevents database instances from connecting to this ASM

instance. NOMOUNT starts up an ASM instance without mounting any disk group. MOUNT option

simply mounts all defined diskgroups

.

The illustration in Figure 1 shows the basic init.ora parameters required to start ASM. Observe that all

ASM processes begin with asm, as opposed to the database instance, whose processes begin with ora.

Figure 1.