Customer Queries On ODA Storage/Resize ACFS filesystem

Asset ID:	1-71-2221700.1
Update Date:	2017-03-11
Keywords:

Solution Type Technical Instruction Sure

Solution 2221700.1 : Customer Queries On ODA Storage/Resize ACFS filesystem

Applies to:

Oracle Database Appliance X5-2 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Goal

Customer Queries

~~~~~~~~~~~~

A. we are migrating EBS database to ODA BASE as per document “ http://www.oracle.com/technetwork/database/database-appliance/oda-ebs-virtualized-wp-2183063.pdf
as per page 11 we need to perform step "oakcli create dbstorage –db PROD"

as per the admin guide we need to select a template out of the following 8

Please select one of the following for Database Class [1 .. 8] :
1 => odb-01s ( 1 cores , 4 GB memory)
2 => odb-01 ( 1 cores , 8 GB memory)
3 => odb-02 ( 2 cores , 16 GB memory)
4 => odb-04 ( 4 cores , 32 GB memory)
5 => odb-06 ( 6 cores , 48 GB memory)
6 => odb-12 ( 12 cores , 96 GB memory)
7 => odb-16 ( 16 cores , 128 GB memory)
8 => odb-24 ( 24 cores , 192 GB memory)

1. How number of cores and memory is related to storage configuration?
2. How dbstorage template CPU and memory configuration is related to ODA_BASE CPU and memory configuration ?
3. What will be the criteria for Database license ODA_BASE CPU or the CPU's from template ?
4. We currently have ODA_BASE configured with 6 CPU's(12 cores) and 32 GB memory, can we use template 6 odb-12 in this case ? if not how best we can map the existing ODA_BASE resources with dbstorage.
5. If we configure using template odb-12 now, advise the possible options to increase the CPU, memory and storage for future requirements.

B. How to resize the ACFS filesystem (Increase/Decrease) once the db storage is created?

Solution

A. Please refer to the below docs regarding the ODA templates and this will answer your first 4 questions.

https://docs.oracle.com/cd/E68623_01/doc.121/e68637/GUID-20839BC4-4ED8-4E40-964D-A60BF12CA72C.htm#CMTAR270

5. You can increase the CPU and memory from DOM0 if this is a VM environment.

B. You need to follow the below steps to increase or decrease the ACFS file system.

How to increase the ACFS file system?

You can either use oakcli utility or acfs utility to resize the ACFS file system.

Please Note oakcli utility can be used only to add the space. With ACFS utility you can Increase/Decrease the ACFS file system.

[root@odax32in1 ~]# oakcli resize dbstorage -h
Usage:
oakcli resize dbstorage [-data <size>] [-reco <size>] [-redo <size>] [-flash <size>] [-cdb <db_name>]

where:
data - extendable size in GB for the DATA volume
redo - extendable size in GB for the REDO volume
reco - extendable size in GB for the RECO volume
flash - extendable size in GB for the FLASH volume (this is available from x5-2 hardware)
db_name - volumes created for this 'cdb' database get extended.

How to increase or decrease the ACFS file system using ACFS command?

You can use acfsutil to resize the ACFS file systems, Please refer to the below link,

https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfs_util010.htm#OSTMG95233

For Example

I just tested it this is how we reduce the size of the ACFS volume which is mounted on RECO Disk Group.

[root@odax32in1 ~]# df -h

/dev/asm/datastore-216
7.5T 68G 7.5T 1% /u01/app/oracle/fast_recovery_area/datastore

[root@odax32in1 ~]# acfsutil size -1T /u01/app/oracle/fast_recovery_area/datastore
acfsutil size: new file system size: 7122129518592 (6792192MB)

[root@odax32in1 ~]# df -h

/dev/asm/datastore-216
6.5T 68G 6.5T 2% /u01/app/oracle/fast_recovery_area/datastore

Attachments

This solution has no attachment