본문 바로가기
스터디북

<12/27> Rac11g ASM

by 파이어볼러 2015. 12. 27.


SQL> select name, permissions, user_number, usergroup_number

  2  from v$asm_file f natural join v$asm_alias t

  3  where group_number=3;


NAME                           PERMISSIONS      USER_NUMBER USERGROUP_NUMBER

------------------------------ ---------------- ----------- ----------------

REGISTRY.255.898680637         rw-rw-rw-                  0                0



SQL> select name, value

  2  from v$asm_attribute

  3  where group_number=3 and name not like 'template%';


NAME                           VALUE

------------------------------ --------------------

disk_repair_time               3.6h

au_size                        1048576

sector_size                    512

compatible.asm                 11.2.0.0.0

compatible.rdbms               11.2.0.0.0

cell.smart_scan_capable        FALSE

access_control.enabled         FALSE

access_control.umask           066


8 rows selected.


create diskgroup acfsdg external redundancy

disk 'orcl:acfs1','orcl:acfs2','orcl:acfs3','orcl:acfs4'


SQL> alter diskgroup acfsdg set attribute 'compatible.asm'='11.2';


Diskgroup altered.


SQL> alter diskgroup acfsdg set attribute 'compatible.advm'='11.2';


Diskgroup altered.



[grid@node01 ~]$ srvctl start diskgroup -g ACFSDG


SQL> alter diskgroup acfsdg add volume apachevol size 1g;


SQL> alter diskgroup acfsdg add volume apachevol size 1g

  2  mirror stripe_width 128k stripe_columns 4;


[grid@node01 ~]$ asmcmd

ASMCMD> volcreate -G ACFSDG -s 1g apachevol


SQL> select volume_name,state,usage,volume_device,mountpath

  2  from v$asm_volume;


VOLUME_NAM STATE    USAGE VOLUME_DEVICE            MOUNTPATH

---------- -------- ----- ------------------------ ----------------------------------------

APACHEVOL  ENABLED  ACFS  /dev/asm/apachevol-340   /opt/oracle/acfsmounts/acfsdg_apachevol

ASMCMD> volinfo -G acfsdg -a

Diskgroup Name: ACFSDG


         Volume Name: APACHEVOL

         Volume Device: /dev/asm/apachevol-340

         State: ENABLED

         Size (MB): 864

         Resize Unit (MB): 32

         Redundancy: UNPROT

         Stripe Columns: 4

         Stripe Width (K): 128

         Usage: ACFS

         Mountpath: /opt/oracle/acfsmounts/acfsdg_apachevol


[grid@node01 ~]$ /sbin/mkfs -t acfs /dev/asm/apachevol-340

mkfs.acfs: version                   = 11.2.0.4.0

mkfs.acfs: on-disk version           = 39.0

mkfs.acfs: volume                    = /dev/asm/apachevol-340


[root@node01 ~]# mount -t acfs /dev/asm/apachevol-340 /opt/oracle/acfsmounts/acfsdg_apachevol/


[grid@node01 ~]$ /sbin/acfsutil registry -a /dev/asm/apachevol-340 /opt/oracle/acfsmounts/acfsdg_apachevol/


[grid@node01 ~]$ /sbin/acfsutil info fs /opt/oracle/acfsmounts/acfsdg_apachevol/

/opt/oracle/acfsmounts/acfsdg_apachevol/

    ACFS Version: 11.2.0.4.0

    flags:        MountPoint,Available

    mount time:   Sun Dec 27 16:02:27 2015

    volumes:      1

    total size:   905969664

    total free:   824135680

    primary volume: /dev/asm/apachevol-340

        label:

        flags:                 Primary,Available,ADVM

        on-disk version:       39.0

        allocation unit:       4096

        major, minor:          251, 174081

        size:                  905969664

        free:                  824135680

        ADVM diskgroup         ACFSDG

        ADVM resize increment: 33554432

        ADVM redundancy:       unprotected

        ADVM stripe columns:   4

        ADVM stripe width:     131072

    number of snapshots:  0

    snapshot space usage: 0

    replication status: DISABLED


[grid@node01 ~]$ df -h /opt/oracle/acfsmounts/acfsdg_apachevol/

Filesystem            Size  Used Avail Use% Mounted on

/dev/asm/apachevol-340

                      864M   79M  786M  10% /opt/oracle/acfsmounts/acfsdg_apachevol


[root@node01 ~]# /sbin/acfsutil size -256M /opt/oracle/acfsmounts/acfsdg_apachevol

acfsutil size: new file system size: 637534208 (608MB)

[root@node01 ~]# df -h /opt/oracle/acfsmounts/acfsdg_apachevol

Filesystem            Size  Used Avail Use% Mounted on

/dev/asm/apachevol-340

                      608M   79M  530M  13% /opt/oracle/acfsmounts/acfsdg_apachevol


[root@node01 ~]# /sbin/acfsutil snap create prerelease /opt/oracle/acfsmounts/acfsdg_apachevol  /

acfsutil snap create: Snapshot operation is complete.


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

/opt/oracle/acfsmounts/acfsdg_apachevol

    ACFS Version: 11.2.0.4.0

    flags:        MountPoint,Available

    mount time:   Sun Dec 27 16:02:27 2015

    volumes:      1

    total size:   637534208

    total free:   488574976

    primary volume: /dev/asm/apachevol-340

        label:

        flags:                 Primary,Available,ADVM

        on-disk version:       39.0

        allocation unit:       4096

        major, minor:          251, 174081

        size:                  637534208

        free:                  488574976

        ADVM diskgroup         ACFSDG

        ADVM resize increment: 33554432

        ADVM redundancy:       unprotected

        ADVM stripe columns:   4

        ADVM stripe width:     131072

        compatible.advm:       11.2.0.0.0

    number of snapshots:  1

    snapshot space usage: 49152

    replication status: DISABLED

'스터디북' 카테고리의 다른 글

<12/29> 이력서,result cache,12c RAC  (0) 2015.12.29
<12/28> MySQL RPM방식 설치  (0) 2015.12.28
<12/26> 성능고도화 Rac11g  (0) 2015.12.26
[12/24] MySQL APM 연동 설치  (0) 2015.12.26
<12/24> MySQL APM 연동 설치  (0) 2015.12.24