6 Database Storage Recommendations

This topic explains the Oracle Banking Treasury Management database storage recommendations.

Oracle database 10g release 2 onwards, Automatic Storage Management (ASM) is the recommended storage option for the Oracle Banking Treasury Management database. ASM is an integrated cluster-aware volume manager and a file system designed and optimized for managing Oracle database files. ASM is the realization of the Oracle Stripe and Mirror Everything (SAME) storage management methodology researched and established as best practices for the Oracle database environment over many years.

Note:

For configuring ASM refer Automatic storage management best practice document provided by Oracle for your database version.

Key benefits of ASM

• I/O is spread evenly across all available disk drives to prevent hot spots and maximize performance.
• ASM eliminates the need for over provisioning and maximizes storage resource utilization facilitating database consolidation.
• Inherent large file support.
• Performs an automatic online redistribution after the incremental addition or removal of the storage capacity.
• Maintains redundant copies of data to provide high availability or leverage 3rd party RAID functionality.
• Supports Oracle Database 19c as well as Oracle Real Application Clusters (RAC).
• Capable of leveraging 3rd party multipathing technologies.
• For simple and easier migration to ASM, an Oracle Database 19c database can contain ASM and non- ASM files. Any new files can be created as ASM files whilst existing files can also be migrated to ASM.
• RMAN commands enable non- ASM managed files to be relocated to an ASM disk group.
• Oracle Database 19c Enterprise Manager is used to manage ASM disk and file management activities.