About Database File Storage

Understand how database file storage is configured for Oracle Database Appliance X6-2.

Database file systems are used exclusively for storing database files, and they include a DATA file system for database data files and a RECO file system for storing archive files and backups. Oracle Database Appliance supports Oracle Automatic Storage Management Cluster File System (Oracle ACFS) or Oracle Automatic Storage Management (Oracle ASM) database file storage. You determine the type of database storage when you create the database.

About Oracle ASM Database Storage

Use Oracle ASM with Oracle Database 12c release 1 (12.1.0.2).

With Oracle ASM, database datafiles are stored in DATA diskgroup. Redo and archive files are in RECO diskgroup.

Reserved storage is the amount of Oracle Automatic Storage Management (Oracle ASM) storage required to maintain redundancy in the event of a disk failure. If you use the reserve storage capacity, then the system continues to run, and it is protected through Oracle ASM mirroring. However, in the event of a second disk failure, the system is then running in a non-protected and degraded mode. In this event, you must replace disks immediately.

See Also:

Oracle Automatic Storage Management Administrator's Guide for more information about Oracle ASM disk group capacity.

About Oracle ACFS Database Storage

Use Oracle ACFS with Oracle Database 12c release 1 (12.1.0.2) or Oracle Database 11g release 2 (11.2.0.4).

With Oracle ACFS, an Oracle ACFS file system is created from DATA diskgroup for each database to store datafiles, and an Oracle ACFS file system is created from RECO diskgroup for redo and fast recovery area for all databases.

Storage Configuration Options

When Oracle Database Appliance X6-2 is deployed, you can select one of the following configuration options to divide the storage capacity between DATA diskgroup and RECO diskgroup:

• External: Storage capacity is split between 80% for DATA and 20% for RECO.

• Internal: Storage capacity is split between 40% for DATA and 60% for RECO.

• Custom: Storage capacity is configurable from 10% to 90% for DATA and the remainder for RECO.

When you configure Oracle Database Appliance to use Custom data storage, the amount of usable storage is determined by the percentage configured for DATA.

You can run the lsdg command to determine the usable storage on the DATA disk group.