Sunday, November 1, 2009

Automatic Storage Management

What is Automatic Storage Management ?

ASM is a special kind of volume manager specifically designed for Oracle Database Files. You give all the disks to Oracle and it will manage it for you. ASM groups the disks in the storage system as one or more disk groups and automates the placement of files within these disk groups. This results in better utilization, performance and high availability.

Advantages of ASM

1. Automatic Load Balancing: The data is spread over all the available disks and hence provide equal distribution of I/O loads across all the disks.

2. Automatic Rebalancing of data: When a disk is added or removed the data is automatically rebalanced with the remaining disks without affecting the performance.

3. Fault Tolerance : ASM provides fault tolerance through 2 to 3 levels of mirroring.

4. ASM can be used in single instance as well as RAC environment.

5. ASM files can co-exist with non-asm files in the same database.

Disadvantage of ASM

ASM cannot support some files such as alert log files, trace files, external table files etc.


Types of files stored in ASM

Data Files, Control files, Redo Log files, Archived log files, Temp files, Parameter files, Backup pieces, Flashback logs, Data pump sets.

Thanks

If you like the post vote for me by clicking the following button.

Top Blogs

No comments:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com