How To Automatically Resize the ACFS Filesystem To Use Available Space On ODA X6-2 S/M/L

Asset ID:	1-71-2386235.1
Update Date:	2018-04-30
Keywords:

Solution Type Technical Instruction Sure

Solution 2386235.1 : How To Automatically Resize the ACFS Filesystem To Use Available Space On ODA X6-2 S/M/L

Applies to:

Oracle Database Appliance X6-2 S/M/L Hardware - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Goal

How to automatically resize the ACFS filesystem in order to use the available space on ODA X6-2 S/M/L

BackGround

External or Internal

When ODA 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.

Custom

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

For ACFS, if you select Oracle ASM for database storage when you create a database, then an Oracle ASM Cluster file system (ACFS) is not created. All files are in an Oracle ASM diskgroup.

If you select Oracle ACFS for database storage, then each database has its own Oracle ACFS mount point:

DATA diskgroup: /u02/app/oracleuser/oradata/db_name

RECO diskgroup: /u03/app/oracleuser.

With Oracle ACFS, the following are created:

A 100G ACFS is created from +DATA diskgroup for each database. This Oracle ACFS automatically extends the space on demand.

A common Oracle ACFS with 25% of +RECO diskgroup is created with auto extension on. This file system is used for fast recovery area and redo logs for all databases.

Solution

If you are upgrading from old version or you find that the space is not automatically resized then you will need to check the ACFS AutoResizeEnabled setting

1- Check if the autoresize is enabled

# acfsutil info fs -o autoresize /u03/app/oracle

If the command returns 0 then autoresize is not enabled

If the command returns 1 then autoresize is enabled

- You can also check

# acfsutil info fs

flags: MountPoint,Available,AutoResizeEnabled

Note: The flag "AutoResizeEnabled". If it is missing then Autoresize is not enabled.

2- You will need to enable it by specifying the auto extend size

Here is how you change auto extend size.

-a 0 to disable it
-a 10G (or 100G) to specify what is the auto extend space.

Example: To autoresize by 10G

# acfsutil size -a 10G /u03/app/oracle
acfsutil size: ACFS-03642: successfully updated auto-resize settings

Attachments

This solution has no attachment