The two configurations that you should select and use while configuring a Virtual Machines (VM) database (DB) system are:
* Use Automatic Storage Management (ASM) for the storage management software of single and two-node VM deployments1. ASM is a feature of Oracle Database that provides a volume manager and a file system for Oracle data files, control files, and log files2. ASM simplifies the administration of Oracle Database files by managing the disk space allocation and optimizing the I/O performance2. ASM is the recommended storage management software for Oracle Database on Oracle Cloud Infrastructure1.
* Use Logical Volume Manager (LVM) for the storage management of single-node VM deployments1. LVM is a tool that allows you to create, resize, and delete logical volumes on your disks3. LVM provides more flexibility and control over your storage configuration than using raw partitions3. LVM is the default storage management software for single-node VM deployments on Oracle Cloud Infrastructure1.
The configurations that you should not select or use are:
* Use Object Storage buckets for DATA, redo logs, and archive logs. Object Storage is a service that provides scalable and durable storage for unstructured data such as images, videos, or backups4. Object Storage is not suitable for storing Oracle Database files that require high performance and low latency4.
Object Storage is mainly used for backup and recovery purposes for Oracle Database on Oracle Cloud Infrastructure.
* Configure storage to assign 40% to DATA and the rest to redo logs and archive logs. This is not a recommended configuration because it does not take into account the actual storage requirements and performance characteristics of your database workload1. You should plan your storage capacity and performance based on the size, growth rate, and I/O patterns of your data, log, and tempdb files1. You should also use separate disks or disk groups for each file type to avoid contention and optimize I/O throughput1.
References:
* Storage Configuration for Virtual Machine DB Systems
* Overview of Automatic Storage Management (ASM)
* Logical Volume Manager Administration
* Overview of Object Storage
* [Backing Up a Database to Object Storage by Using RMAN]