ODA Methods To Assess Storage for ACFS Using Oakcli dbstorage

Asset ID:	1-71-2044406.1
Update Date:	2015-09-28
Keywords:

Solution Type Technical Instruction Sure

Solution 2044406.1 : ODA Methods To Assess Storage for ACFS Using Oakcli dbstorage

Applies to:

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

Goal

ODA methods to quickly assess ACFS storage available, used and total by diskgroup with examples.
The following are not the only methods to confirm ACFS / ASM storage on ODA.

- More examples will be added

Solution

oakcli show dbstorage

All the DBs with DB TYPE as non-CDB share the same volumes

[root@x ]# oakcli show dbstorage

All the DBs with DB TYPE as non-CDB share the same volumes

DB_NAMES           DB_TYPE    Filesystem                                        Size     Used    Available    AutoExtend Size DiskGroup
-------            -------    ------------                                    ------    -----    ---------   ----------------   --------
s12122, t12123     non-CDB    /u01/app/oracle/oradata/datastore                   18G     7.17G      10.83G              1G        REDO
                              /u02/app/oracle/oradata/datastore                  711G     3.47G     707.53G             71G        DATA
                              /u01/app/oracle/fast_recovery_area/datastore       597G     1.38G     595.62G             59G        RECO

[root@x ]# su - grid
[grid@x ]$ . oraenv
ORACLE_SID = [grid] ? +ASM1
The Oracle base has been set to /u01/app/grid
[grid@x~]$ asmcmd

ASMCMD> lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED HIGH    N         512   4096    4194304    4915200 2680888          491520           729789              0             Y DATA/
MOUNTED HIGH    N         512   4096    4194304     5454280 2478232            641680         612184              0             N RECO/
MOUNTED HIGH    N         512   4096    4194304      280016   190616          140008            16869              0             N REDO/

ASMCMD> volinfo -G data -a
Diskgroup Name: DATA

         Volume Name: DATASTORE
         Volume Device: /dev/asm/datastore-419
         State: ENABLED
         Size (MB): 728064
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /u02/app/oracle/oradata/datastore

ASMCMD> volinfo -G reco -a
Diskgroup Name: RECO

         Volume Name: ACFSVOL
         Volume Device: /dev/asm/acfsvol-125
         State: ENABLED
         Size (MB): 51200
         Resize Unit (MB): 32
         Redundancy: HIGH
         Stripe Columns: 4
         Stripe Width (K): 128
         Usage: ACFS
         Mountpath: /cloudfs

         Volume Name: DATAFSVOL
         Volume Device: /dev/asm/datafsvol-125
         State: ENABLED
         Size (MB): 5120
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /odadatafs

         Volume Name: DATASTORE
         Volume Device: /dev/asm/datastore-125
         State: ENABLED
         Size (MB): 611328
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /u01/app/oracle/fast_recovery_area/datastore

NOTE

[root@x]# oakcli show dbstorage

ERROR: 2015-....: oakcli show dbstorage should be invoked from the first node

Attachments

This solution has no attachment