Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI) can be used for the following use cases:
* Database backups: Oracle Recovery Manager (RMAN) is an Oracle Database client that performs Oracle database backup and recovery. It automates the administration of Oracle backup strategies and greatly simplifies backing up, restoring, and recovering database files. RMAN can use OCI Object Storage as a backup destination, which offers reliable and cost-efficient data durability1.
* Database log files: Oracle Database can use OCI Object Storage as a destination for archiving redo log files, which are generated during normal database operation and contain a record of the changes made to the database. Archiving redo log files to OCI Object Storage can help reduce the storage costs and improve the availability and disaster recovery of the database2.
The other two options are not valid use cases for Oracle database with Object Storage in OCI:
* Database data files: Oracle Database cannot use OCI Object Storage as a storage option for data files, which store the actual data of the database. Data files require block storage, which provides low latency and high performance. OCI Object Storage is an object storage service, which provides high scalability and durability, but not low latency and high performance3.
* Database binaries: Oracle Database cannot use OCI Object Storage as a storage option for database binaries, which are the executable files and libraries that make up the Oracle Database software.
* Database binaries require a file system, which provides a hierarchical structure and metadata for files and directories. OCI Object Storage is an object storage service, which provides a flat namespace and metadata for objects3.
References: 1: Backing Up to Object Storage 2: Archiving Redo Log Files to Object Storage 3: Object Storage Overview