Automatic storage management for Oracle database 11g Research Paper

Automatic storage management for Oracle database 11g - Research Paper Example Despite the growing functionalities and capabilities of data management systems, traditional storage management systems could not help the organizations in leveraging their data management capabilities efficiently. Hence, the outcome emerged in the form of underutilization and overprovisioning. On the other hand, increasingly changing needs and requirements of organizations and data management systems are forcing the IT industry and researchers to discover effective techniques for data management and storage (Roussos, 2007; Joshi & Chalaka, 2006). However, the integration of autonomic features in data management system improves the performance of data management process by increasing effectiveness, speed, consistency and accurateness, eventually presenting fault free infrastructure for data management and storage. Without a doubt, these autonomic features are believed to be critical in Database Management Systems (DBMSs) for the reason that these autonomic systems take the approach o f what instead of how. Additionally, a wide variety of tool and applications can be employed by database management systems for the management of storage (Chaudhuri & Narasayya, 2001; Raza, Mateen, Hussain, & Awais, 2009). In this scenario, automatic storage management provides an excellent support for the rearrangement of dire groups to unaffected space of the disk (Raza, Mateen, Sher, Awais, & Hussain, 2010; Lightstone, Lohman, & Zilio, 2002). Oracle Data base 11g contains a wonderful feature known as Oracle Automatic Storage Management that follows the principle of combines stripe and mirror everywhere (SAME). In addition, Oracle Automatic Storage Management is responsible for managing groups of data storage in disk groups that can collect and store database files from a number of databases (Townsend, 2011; HP, 2008). This paper presents a detailed analysis of oracle automatic storage management for Oracle 11g. The basic purpose of this research is to present an analysis of autom atic storage management in the context of its working, its features and capabilities. This research will summarize the concepts discussed in other researches. Automatic Storage Management (ASM) for Oracle Database 11g In Oracle 11g, Automatic Storage Management (ASM) is designed to simplify the management of Oracle related files by facilitating the database administrators to reference disk groups instead of files and disks separately, which can be administrated through automatic storage management. Basically, the functionalities and capabilities offered by the automatic storage management are believed to be an extension of the OMF (Oracle Managed Files) features which further comprise mirroring and striping in order to provide secure and impartial storage management. In addition, a wide variety of templates are used to control the extent of the granularity and redundancy of the mirroring and striping. Though, Oracle provides a variety of default templates for each type of file store d by ASM, however extra templates can also be developed according to needs of the organizations. In addition, failure groups are also established in a disk group in order to accommodate the varying needs of the databases and required intensity of redundancy. If a database uses a two-way mirroring then it will require a disk group to establish and maintain two failure groups in order that individual files can be written and stored at two places (Oracle-Base2, 2013; Abraham, Bagal, Bauer, Belden, Bridge, & Chan, 2012). Additionally, the ASM