//
you're reading...
Oracle Database Appliance

Oracle Database Appliance (X5-2) Study (Virtualized Platform deployment) section 3

**This article is only for the purpose of demonstrating of my study of the Oracle Database appliance, not for any other purposes.**

Oracle Database Appliance Deployment (Virtualized Platform) section 3

Overview the storage configuration on the ODA

List all avaiable diskgroups

[grid@testodanode01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.2.0 Production on Wed Apr 13 10:36:02 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select name, state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
RECO                           MOUNTED
FLASH                          MOUNTED
REDO                           MOUNTED
DATA                           MOUNTED

View the information for all ACFS volumes created by ODA Grid defaultly

[grid@testodanode01 ~]$ asmcmd volinfo -G DATA -a
Diskgroup Name: DATA

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

[grid@testodanode01 ~]$ asmcmd volinfo -G FLASH -a
Diskgroup Name: FLASH

         Volume Name: FLASHDATA
         Volume Device: /dev/asm/flashdata-174
         State: ENABLED
         Size (MB): 571392
         Resize Unit (MB): 64
         Redundancy: MIRROR
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /u02/app/oracle/oradata/flashdata
	 

[grid@testodanode01 ~]$ asmcmd volinfo -G REDO -a
Diskgroup Name: REDO

         Volume Name: ACLDATSTORE
         Volume Device: /dev/asm/acldatstore-450
         State: ENABLED
         Size (MB): 60160
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath:

         Volume Name: ATESTREPO01
         Volume Device: /dev/asm/atestrepo01-450
         State: ENABLED
         Size (MB): 256
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath:

         Volume Name: ATESTREPO1
         Volume Device: /dev/asm/atestrepo1-450
         State: ENABLED
         Size (MB): 256
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath:

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

[grid@testodanode01 ~]$ asmcmd volinfo -G RECO -a
Diskgroup Name: RECO

         Volume Name: ACFSVOL
         Volume Device: /dev/asm/acfsvol-382
         State: ENABLED
         Size (MB): 102400
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /cloudfs

         Volume Name: DATAFSVOL
         Volume Device: /dev/asm/datafsvol-382
         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-382
         State: ENABLED
         Size (MB): 2414592
         Resize Unit (MB): 64
         Redundancy: HIGH
         Stripe Columns: 8
         Stripe Width (K): 1024
         Usage: ACFS
         Mountpath: /u01/app/oracle/fast_recovery_area/datastore

Get detailed file system information

[root@testodanode01 ~]# /sbin/acfsutil info fs

/cloudfs
    ACFS Version: 12.1.0.2.0
    on-disk version:       39.0
    flags:        MountPoint,Available
    mount time:   Wed Apr  6 13:11:28 2016
    allocation unit:       4096
    volumes:      1
    total size:   107374182400  ( 100.00 GB )
    total free:   107081220096  (  99.72 GB )
    file entry table allocation: 49152
    primary volume: /dev/asm/acfsvol-382
        label:
        state:                 Available
        major, minor:          251, 195586
        size:                  107374182400  ( 100.00 GB )
        free:                  107081220096  (  99.72 GB )
        metadata read I/O count:         597586
        metadata write I/O count:        11
        total metadata bytes read:       305964032  ( 291.79 MB )
        total metadata bytes written:    12800  (  12.50 KB )
        ADVM diskgroup         RECO
        ADVM resize increment: 67108864
        ADVM redundancy:       high
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED

/u02/app/oracle/oradata/flashdata
    ACFS Version: 12.1.0.2.0
    on-disk version:       45.0
    flags:        MountPoint,Available,AutoResizeEnabled
    mount time:   Wed Apr  6 13:11:28 2016
    allocation unit:       4096
    volumes:      1
    total size:   599147937792  ( 558.00 GB )
    total free:   559156969472  ( 520.75 GB )
    auto-resize increment:   59055800320  (  55.00 GB )
    auto-resize maximum:     0  ( 0.00 )
    file entry table allocation: 49152
    primary volume: /dev/asm/flashdata-174
        label:
        state:                 Available
        major, minor:          251, 89089
        size:                  599147937792  ( 558.00 GB )
        free:                  559156969472  ( 520.75 GB )
        metadata read I/O count:         600632
        metadata write I/O count:        124
        total metadata bytes read:       308261888  ( 293.98 MB )
        total metadata bytes written:    1077760  (   1.02 MB )
        ADVM diskgroup         FLASH
        ADVM resize increment: 67108864
        ADVM redundancy:       mirror
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  3
    snapshot space usage: 38655074304  (  36.00 GB )
    replication status: DISABLED

/odadatafs
    ACFS Version: 12.1.0.2.0
    on-disk version:       42.0
    flags:        MountPoint,Available
    mount time:   Wed Apr  6 13:11:29 2016
    allocation unit:       4096
    volumes:      1
    total size:   5368709120  (   5.00 GB )
    total free:   5278089216  (   4.91 GB )
    file entry table allocation: 49152
    primary volume: /dev/asm/datafsvol-382
        label:
        state:                 Available
        major, minor:          251, 195585
        size:                  5368709120  (   5.00 GB )
        free:                  5278089216  (   4.91 GB )
        metadata read I/O count:         597556
        metadata write I/O count:        11
        total metadata bytes read:       305948672  ( 291.77 MB )
        total metadata bytes written:    12800  (  12.50 KB )
        ADVM diskgroup         RECO
        ADVM resize increment: 67108864
        ADVM redundancy:       high
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED

/u01/app/oracle/oradata/datastore
    ACFS Version: 12.1.0.2.0
    on-disk version:       45.0
    flags:        MountPoint,Available,AutoResizeEnabled
    mount time:   Wed Apr  6 13:11:29 2016
    allocation unit:       4096
    volumes:      1
    total size:   66571993088  (  62.00 GB )
    total free:   61980356608  (  57.72 GB )
    auto-resize increment:   6442450944  (   6.00 GB )
    auto-resize maximum:     0  ( 0.00 )
    file entry table allocation: 1097728
    primary volume: /dev/asm/datastore-450
        label:
        state:                 Available
        major, minor:          251, 230401
        size:                  66571993088  (  62.00 GB )
        free:                  61980356608  (  57.72 GB )
        metadata read I/O count:         1652469
        metadata write I/O count:        1239769
        total metadata bytes read:       2417766400  (   2.25 GB )
        total metadata bytes written:    1760777728  (   1.63 GB )
        ADVM diskgroup         REDO
        ADVM resize increment: 67108864
        ADVM redundancy:       high
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED

/u01/app/oracle/fast_recovery_area/datastore
    ACFS Version: 12.1.0.2.0
    on-disk version:       45.0
    flags:        MountPoint,Available,AutoResizeEnabled
    mount time:   Wed Apr  6 13:11:31 2016
    allocation unit:       4096
    volumes:      1
    total size:   2531883220992  (   2.30 TB )
    total free:   2521691275264  (   2.29 TB )
    auto-resize increment:   252329328640  ( 235.00 GB )
    auto-resize maximum:     0  ( 0.00 )
    file entry table allocation: 2146304
    primary volume: /dev/asm/datastore-382
        label:
        state:                 Available
        major, minor:          251, 195587
        size:                  2531883220992  (   2.30 TB )
        free:                  2521691275264  (   2.29 TB )
        metadata read I/O count:         606065
        metadata write I/O count:        25547
        total metadata bytes read:       311443968  ( 297.01 MB )
        total metadata bytes written:    33098240  (  31.56 MB )
        ADVM diskgroup         RECO
        ADVM resize increment: 67108864
        ADVM redundancy:       high
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    number of snapshots:  0
    snapshot space usage: 0  ( 0.00 )
    replication status: DISABLED

/u02/app/oracle/oradata/datastore
    ACFS Version: 12.1.0.2.0
    on-disk version:       45.0
    flags:        MountPoint,Available,AutoResizeEnabled
    mount time:   Wed Apr  6 13:11:32 2016
    allocation unit:       4096
    volumes:      2
    total size:   15760382492672  (  14.33 TB )
    total free:   15758003310592  (  14.33 TB )
    auto-resize increment:   1575179255808  (   1.43 TB )
    auto-resize maximum:     0  ( 0.00 )
    file entry table allocation: 49152
    primary volume: /dev/asm/datastore-417
        label:
        state:                 Available
        major, minor:          251, 213505
        size:                  15760382492672  (  14.33 TB )
        free:                  15758003310592  (  14.33 TB )
        metadata read I/O count:         599402
        metadata write I/O count:        449
        total metadata bytes read:       306952192  ( 292.73 MB )
        total metadata bytes written:    1506816  (   1.43 MB )
        ADVM diskgroup         DATA
        ADVM resize increment: 67108864
        ADVM redundancy:       high
        ADVM stripe columns:   8
        ADVM stripe width:     1048576
    accelerator volume: /dev/asm/acldatstore-450
        accelerator version:   2
        label:
        state:                 Available
        major, minor:          251, 230402
        size:                  63082332160  (  58.75 GB )
        free:                  32096317440  (  29.89 GB )
        metadata read I/O count:         3249
        metadata write I/O count:        1413
        total metadata bytes read:       5095424  (   4.85 MB )
        total metadata bytes written:    2304000  (   2.19 MB )
        allocation success since mount:  100 %
    number of snapshots:  2
    snapshot space usage: 1790664704  (   1.66 GB )
    replication status: DISABLED

Review some database parameters

[oracle@testodanode01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 13 09:02:01 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u02/app/oracle/oradata/datast
                                                 ore/.ACFS/snaps/testdb/testdb/
                                                 spfiletestdb.ora
SQL> show parameter _dump;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/tes
                                                 tdb/testdb1/trace
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/tes
                                                 tdb/testdb1/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/diag/rdbms/tes
                                                 tdb/testdb1/trace

SQL> show parameter remote;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode             string      TIMESTAMP
remote_listener                      string      testdb-cluster-scan:1521
remote_login_passwordfile            string      EXCLUSIVE
remote_os_authent                    boolean     FALSE
remote_os_roles                      boolean     FALSE
result_cache_remote_expiration       integer     0
SQ>										 

List all database datafiles for testdb

SQL> column name format a150
SQL> select distinct name from v$datafile order by name;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/datastore/.ACFS/snaps/testdb/TESTDB/datafile/o1_mf_sysau
x_cjr8v35n_.dbf

/u02/app/oracle/oradata/datastore/.ACFS/snaps/testdb/TESTDB/datafile/o1_mf_syste
m_cjr8tws6_.dbf

/u02/app/oracle/oradata/datastore/.ACFS/snaps/testdb/TESTDB/datafile/o1_mf_undot
bs1_cjr8v8bn_.dbf

/u02/app/oracle/oradata/datastore/.ACFS/snaps/testdb/TESTDB/datafile/o1_mf_undot
bs2_cjr8vhnj_.dbf

NAME
--------------------------------------------------------------------------------

/u02/app/oracle/oradata/datastore/.ACFS/snaps/testdb/TESTDB/datafile/o1_mf_users
_cjr8vkod_.dbf
Advertisements

About daviewning

I am an Oracle DBA

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: