ORACLE: Use ASM for Automatic Storage Management, which is highly recommended.

ASM is a data storage solution launched by Oracle for Oracle database systems. it is similar to the soft RAID of OS. However, it has a special hierarchy in the system architecture and serves upper-layer software (ASM) applications directly, it can be understood as a compound product that spans {hardware Partition + raid + OS volume management + OS file system.

Because of its streamlined and optimized Implementation of the storage system architecture, it has {good Io performance \ flexible scalability \ High Security} performance. It is also closely integrated with Oracle database instances, consistent management style!

ASM is introduced from Oracle 10g and recommended in 11g.

In a formal production environment, ASM should use a real physical disk system. Of course, it is for testing purposes or Oracle's ulterior motives. It also supports the file system approach!

ASM supports real disk partitions. You can use the asmtoolg tool \ dbca to manage and set disk partitions. This is simple and will not be described here!

ASM also supports the OS file mode, provided that an implicit parameter is set in the initialization parameter configuration file of + ASM"_ Asm_allow_only_raw_disks = false", How to set it? Do you know? You really don't know?

TIPS:

During dbca configuration, when setting the + ASM instance for the first time, manually add the specified implicit Parameter

When adding disks during dbca configuration, you can adjust the "asm_diskstring" parameter to locate disks or files in different paths.

The only required parameter for the ASM instance is"Instance_type = ASM (not the default RDBMS)"