Oracle Database 19c: ASM Administration Workshop Course Overview

Oracle Database 19c: ASM Administration Workshop Course Overview

The Oracle Database 19c: ASM Administration Workshop is a comprehensive course designed to educate learners on the automation and management of storage solutions using Oracle Automatic Storage Management (ASM). This course is crucial for database administrators who manage and configure storage for Oracle databases.

Beginning with an ASM Overview, students will learn the fundamentals and components, such as ASM Disk Groups, and proceed to hands-on administration of ASM instances, including starting and stopping node listeners. The course covers Flex ASM, which allows the ASM instance to run on a separate node from the database server, enhancing flexibility and failover capabilities.

Modules on Administering ASM Disk Groups delve into advanced features, Disk group compatibility attributes, and Rebalance operations. Students also explore the administration of ASM files, directories, templates, and Oracle Automatic Storage Management Cluster File System (ACFS) for a more robust storage solution.

Emphasizing on oracle 19c asm advancements, the workshop includes lessons on ACFS/ADVM enhancements, such as 4K sector support, and Encrypting ACFS file systems. Advanced topics provide deeper insights into asm oracle 19c, including Point-In-Time Database Clones and cleanup procedures.

By the end of the course, participants will possess the skills necessary to efficiently manage ASM with Oracle Database 19c, ensuring optimized storage performance and reliability.

CoursePage_session_icon

Successfully delivered 4 sessions for over 7 professionals

Purchase This Course

Fee On Request

  • Live Training (Duration : 16 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

You can request classroom training in any city on any date by Requesting More Information

  • Live Training (Duration : 16 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

You can request classroom training in any city on any date by Requesting More Information

Request More Information

Email:  WhatsApp:

Koenig's Unique Offerings

Course Prerequisites

To ensure that participants are adequately prepared for the Oracle Database 19c: ASM Administration Workshop and can fully benefit from the course content, the following minimum prerequisites are recommended:


  • Basic understanding of database concepts and structures.
  • Familiarity with Oracle Database architecture and its main components.
  • Experience with database administration, including starting and stopping database instances.
  • Knowledge of the Linux or UNIX operating system environment, including command-line usage and file system navigation.
  • Prior experience with Oracle Grid Infrastructure, including Oracle Automatic Storage Management (ASM) and Oracle Clusterware.
  • Understanding of disk storage concepts such as disk partitions, file systems, and disk redundancy.
  • Ability to use Oracle command-line tools such as SQL*Plus and ASM command-line tools (asmcmd).

These prerequisites are designed to provide a foundation that will help students grasp the course material more effectively. However, individuals with a strong motivation to learn and a commitment to understanding the course concepts may also succeed even if they do not meet all of the above requirements.


Target Audience for Oracle Database 19c: ASM Administration Workshop

The Oracle Database 19c: ASM Administration Workshop is designed for professionals managing databases and storage structures within an Oracle environment.


  • Database Administrators
  • Data Warehouse Administrators
  • Technical Administrators
  • Support Engineers
  • System Analysts
  • IT Infrastructure Engineers
  • Storage Administrators
  • Database Designers
  • Data Center Support Engineers
  • Oracle ASM Data Management Professionals
  • Oracle Consultants
  • Cloud Database Operators
  • Database Architects


Learning Objectives - What you will Learn in this Oracle Database 19c: ASM Administration Workshop?

Introduction to Course Learning Outcomes

Gain in-depth knowledge and hands-on experience in Oracle Database 19c ASM administration, mastering crucial skills from managing disk groups to advanced features like Flex ASM and encrypting ACFS file systems.

Learning Objectives and Outcomes

  • Understand the architecture and components of Oracle Automatic Storage Management (ASM).
  • Learn to administer ASM instances, including starting and stopping ASM instances and node listeners.
  • Gain proficiency in the configuration and management of Flex ASM for greater flexibility and scalability.
  • Acquire skills to manage ASM disk groups, set attributes, and perform disk rebalancing operations effectively.
  • Develop the ability to perform consistency checks and repair disk group metadata.
  • Understand the concepts of Flex ASM Disk Groups and their benefits in a cloud environment.
  • Learn to manage ASM files, directories, and templates, as well as understand the functionality of ASM directories.
  • Master the administration of Oracle Automatic Storage Management Cluster File System (ACFS) and its extensions on Linux and UNIX systems.
  • Stay updated with the latest ACFS/ADVM enhancements including 4K sector and metadata support considerations.
  • Learn advanced topics such as encrypting ACFS file systems and performing point-in-time database clones for efficient data management.

Technical Topic Explanation

ASM files

ASM files, in the context of Oracle 19c, refer to Oracle Automatic Storage Management (ASM) configuration files. Oracle ASM is a data management technology that simplifies disk management, providing an alternative to conventional file systems and volume management. It optimizes storage performance and scalability by automatically distributing database files across disks in a balanced manner, enhancing data reliability and overall systems performance. ASM is integrated with Oracle Database 19c, ensuring efficient database operations and enabling easier storage setup and maintenance. Oracle ASM 19c is specifically the version associated with Oracle Database 19c, offering features suited to modern enterprise data handling needs.

Rebalance operations

Rebalance operations in the context of Oracle 19c Automatic Storage Management (ASM) are processes that redistribute the data across all available disks in an ASM disk group. This operation ensures that disk space is used efficiently and evenly, which enhances both the performance and reliability of the database. Rebalancing is triggered automatically when disks are added or removed from the disk group, or when disks fail, ensuring optimal data distribution and storage performance continuity. This feature is vital for maintaining system performance and data integrity in dynamic storage environments.

ASM instances

ASM (Automatic Storage Management) instances in Oracle 19c simplify the management of database datafiles, control files, and log files. They use disk groups to automate the storage of these files across multiple disks, enhancing performance and ensuring data safety without manual intervention. ASM achieves high availability by redistributing data automatically among disks whenever the storage configuration changes. This feature is integral to Oracle databases, especially in large, dynamic environments, making it a core component of Oracle 19c’s database management capabilities.

ASM Disk Groups

Administering ASM Disk Groups in Oracle 19c involves managing containers for data storage that are specifically designed to balance and optimize database performance. Oracle ASM (Automatic Storage Management) simplifies and automates the layout of data files, control files, and log files using disk groups. It enhances data reliability and performance by striping data across multiple disks and optionally mirroring for redundancy. Tasks in managing ASM disk groups include creating, altering, dropping, rebalancing, and checking disk groups for consistency, usually managed via Oracle ASM tools or SQL commands, ensuring a robust environment for database systems.

Flex ASM

Flex ASM is a feature in Oracle ASM (Automatic Storage Management), primarily introduced in Oracle 19c. It enhances database high availability by allowing an Oracle ASM instance to run on a separate server from the database servers. This separation means that if the database server fails, the ASM instance continues to operate unaffected, thus ensuring continuous management and accessibility of disk storage. Flex ASM also supports multiple ASM instances to provide additional fault tolerance and load balancing for disk group metadata operations, improving both performance and reliability of Oracle databases.

Disk group compatibility attributes

Disk group compatibility attributes in Oracle ASM 19c define the features that disk groups can support based on the Oracle ASM and database versions. These attributes, including COMPATIBLE.ASM and COMPATIBLE.RDBMS, ensure that all instances within a database environment can successfully access and manage the disk group. By setting these attributes, you tailor the behavior of disk groups to match specific version requirements, enhancing overall system stability and functionality. This management helps in optimizing software performance and maintaining backward compatibility, reducing potential conflicts between the ASM and database versions.

Oracle Automatic Storage Management Cluster File System (ACFS)

Oracle Automatic Storage Management Cluster File System (ACFS) is a scalable file system and storage management technology developed by Oracle. It simplifies the storage of files and applications across Oracle databases, aiding in the seamless management and organization of data. ACFS operates on top of Oracle ASM (Automatic Storage Management), enhancing its capabilities by supporting not just database files, but also any type of file. This system is integrated with Oracle 19c ASM, offering high availability, robust performance, and easy management of data in cluster environments, ideal for enterprises seeking efficient data handling and storage solutions.

ACFS/ADVM enhancements

ACFS (Oracle Automatic Storage Management Cluster File System) and ADVM (Automatic Storage Management Dynamic Volume Manager) are components of Oracle ASM 19c that enhance file and volume management for Oracle databases. In Oracle 19c, these enhancements include better integration and support for large files, improved performance and scalability in managing database files across different nodes in a cluster. ACFS has also improved security features and supports new types of data, while ADVM provides more flexible volume management, allowing for dynamic resizing of disk volumes without downtime, greatly enhancing operational flexibility and efficiency.

Oracle Automatic Storage Management (ASM)

Oracle Automatic Storage Management (ASM) is a data management solution primarily designed for Oracle databases. It simplifies the task of managing database datafiles, by automatically handling the storage layout and optimization tasks. Oracle 19c ASM enhances this functionality, providing tools for efficient database storage management, thereby ensuring higher performance, scalability, and reliability of database systems. ASM achieves this by balancing data evenly across disks, reducing bottlenecks, and improving data redundancy through mirroring strategies. It is an integral component for optimizing the performance of Oracle 19c databases.

ASM Disk Groups

ASM Disk Groups in Oracle 19c are essentially containers for the storage of database files managed by the Automatic Storage Management feature. They group together multiple disks, allowing Oracle to manage data storage and redundancy strategies more efficiently. This boosts data safety and enhances performance by balancing file distributions across disks, reducing the risk of data loss. ASM simplifies storage management, especially in large database environments, by automating various tasks that would otherwise need manual intervention. This feature is fundamental in supporting high-availability systems and is an integral component of Oracle ASM 19c.

4K sector support

4K sector support refers to the capability of a storage device to manage and store data in sectors or blocks that are 4,096 bytes in size, compared to older 512-byte sector formats. This technology improves storage efficiency and enhances error correction, leading to better data integrity and performance. Modern systems, including databases like Oracle ASM 19c, support 4K sectors, allowing them to handle larger volumes of data more effectively while optimizing disk space usage and access speed. This support is critical as databases grow and demand more efficient storage solutions.

Encrypting ACFS file systems

Encrypting ACFS file systems, part of Oracle's technology, involves securing data stored on these file systems by converting it into a coded form that can be accessed only with a decryption key. This ensures that sensitive information remains confidential and protected from unauthorized access. In Oracle ASM (Automatic Storage Management) 19c, this encryption process is integrated, enhancing security without sacrificing performance. This feature is crucial for organizations managing critical data, effectively mitigating risks of data breaches and complying with data protection regulations.

Point-In-Time Database Clones

Point-In-Time Database Clones are snapshots of a database taken at a specific moment. These clones create exact copies of the database's data and schema as they existed at a particular point in time. This feature is vital for tasks like testing, backup recovery, and troubleshooting, allowing professionals to work with a real but isolated copy without affecting the live database. This capability ensures data integrity and swift recovery in case of errors or data loss, enhancing the robustness of database management practices.

Target Audience for Oracle Database 19c: ASM Administration Workshop

The Oracle Database 19c: ASM Administration Workshop is designed for professionals managing databases and storage structures within an Oracle environment.


  • Database Administrators
  • Data Warehouse Administrators
  • Technical Administrators
  • Support Engineers
  • System Analysts
  • IT Infrastructure Engineers
  • Storage Administrators
  • Database Designers
  • Data Center Support Engineers
  • Oracle ASM Data Management Professionals
  • Oracle Consultants
  • Cloud Database Operators
  • Database Architects


Learning Objectives - What you will Learn in this Oracle Database 19c: ASM Administration Workshop?

Introduction to Course Learning Outcomes

Gain in-depth knowledge and hands-on experience in Oracle Database 19c ASM administration, mastering crucial skills from managing disk groups to advanced features like Flex ASM and encrypting ACFS file systems.

Learning Objectives and Outcomes

  • Understand the architecture and components of Oracle Automatic Storage Management (ASM).
  • Learn to administer ASM instances, including starting and stopping ASM instances and node listeners.
  • Gain proficiency in the configuration and management of Flex ASM for greater flexibility and scalability.
  • Acquire skills to manage ASM disk groups, set attributes, and perform disk rebalancing operations effectively.
  • Develop the ability to perform consistency checks and repair disk group metadata.
  • Understand the concepts of Flex ASM Disk Groups and their benefits in a cloud environment.
  • Learn to manage ASM files, directories, and templates, as well as understand the functionality of ASM directories.
  • Master the administration of Oracle Automatic Storage Management Cluster File System (ACFS) and its extensions on Linux and UNIX systems.
  • Stay updated with the latest ACFS/ADVM enhancements including 4K sector and metadata support considerations.
  • Learn advanced topics such as encrypting ACFS file systems and performing point-in-time database clones for efficient data management.