Skip to main content

How To Create ACFS File System In RAC Using Command Line in 13C



ORACLE GRID VERSION – 12.1.0.2
NODES – RAC1 , RAC2
OS – OLinux



DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB PATH HEADER_STATU
--------------- --------------- ---------- ---------- ---------- ----------------------------------- ------------
0 0 0 /dev/oracleasm/disks/OCRVOTE3 FORMER
OCRVOTE OCRVOTE4 12284 9312 2972 /dev/oracleasm/disks/OCRVOTE4 MEMBER
OCRVOTE OCRVOTE_0000 5116 3936 1180 /dev/oracleasm/disks/OCRVOTE1 MEMBER
OCRVOTE OCRVOTE_0001 5116 3896 1220 /dev/oracleasm/disks/OCRVOTE2 MEMBER
ORA_DATA OCRVOTE5 12287 10395 1892 /dev/oracleasm/disks/OCRVOTE5 MEMBER



Create an ASM DISKGROUP( ON NODE 1)



SQL> !echo $ORACLE_HOME
/u002/app/oracle/product/19.3.0/grid

SQL> !echo $ORACLE_SID
+ASM1
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 21 03:25:09 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0


CREATE DISKGROUP ACFSPOC EXTERNAL REDUNDANCY
DISK '/dev/oracleasm/disks/OCRVOTE3' ATTRIBUTE 'compatible.asm' = '12.1.0.0.0','compatible.rdbms'='12.1.0.0.0' ,'compatible.advm' = '12.1.0.0.0';

SQL> alter diskgroup ACFSPOC mount;
Diskgroup altered.
Mount the diskgroup from other nodes(On NODE 2)

[grid@rac1 ~]$ ssh rac2
Last login: Fri Jan 21 03:25:11 2022

[grid@rac2 ~]$ echo $ORACLE_HOME
/u002/app/oracle/product/19.3.0/grid
[grid@rac2 ~]$ echo $ORACLE_SID
+ASM2

[grid@rac2 ~]$ asmcmd
ASMCMD> mount ACFSPOC
ASMCMD> lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Voting_files Name
MOUNTED EXTERN N 512 512 4096 1048576 5119 5024 N ACFSPOC/
MOUNTED EXTERN N 512 512 4096 4194304 22516 5372 Y OCRVOTE/
MOUNTED EXTERN N 512 512 4096 1048576 12287 1892 N ORA_DATA/

check the diskgroup status( from any node)
Version 19.3.0.0.0

SQL> set lines 299
SQL> select GROUP_NUMBER,NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from gv$asm_diskgroup where NAME='ACFSPOC';



GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------

3 ACFSPOC 12.1.0.0.0 12.1.0.0.0

3 ACFSPOC 12.1.0.0.0 12.1.0.0.0


SQL> [grid@rac2 ~]$ crsctl stat res ora.ACFSPOC.dg -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------

Cluster Resources
-------------------------------------------------------------------------------
ora.ACFSPOC.dg(ora.asmgroup)
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
3 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
[grid@rac2 ~]$
Create a new ADVM volume in the diskgroup(ACFSPOC):(ON NODE 1)
ASMCMD> volcreate -G ACFSPOC -s 4G SHAREDVOL1
ASMCMD> volinfo --all

Diskgroup Name: ORA_DATA
Volume Name: SHAREDVOL1
Volume Device: /dev/asm/sharedvol1-302
State: ENABLED
Size (MB): 10240
Resize Unit (MB): 64
Redundancy: UNPROT
Stripe Columns: 8
Stripe Width (K): 1024
Usage: ACFS
Mountpath: /acfspoc

Diskgroup Name: ACFSPOC
Volume Name: SHAREDVOL1
Volume Device: /dev/asm/sharedvol1-240
State: ENABLED
Size (MB): 4096
Resize Unit (MB): 64
Redundancy: UNPROT
Stripe Columns: 8
Stripe Width (K): 1024
Usage:
Mountpath:



[grid@rac2 ~]$ crsctl stat res ora.ACFSPOC.SHAREDVOL1.advm -t

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

Name Target State Server State details

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

Local Resources

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

ora.ACFSPOC.SHAREDVOL1.advm
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE

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

[grid@rac2 ~]$



create mount point with proper permission on both nodes:
[grid@rac1 ~]$ su - root
Password:
Last login: Fri Jan 21 03:18:19 IST 2022 from 192.168.56.1 on pts/3
[root@rac1 ~]# mkdir /acfspoc2
[root@rac1 ~]# chown oracle:oinstall /acfspoc2
[root@rac1 ~]# ssh rac2 mkdir /acfspoc2
root@rac2's password:
[root@rac1 ~]# ssh rac2 chown oracle:oinstall /acfspoc2
root@rac2's password:
[root@rac1 ~]#



[grid@rac1 ~]$ /sbin/mkfs -t acfs /dev/asm/sharedvol1-240
mkfs.acfs: version = 19.0.0.0.0
mkfs.acfs: on-disk version = 39.0
mkfs.acfs: volume = /dev/asm/sharedvol1-240
mkfs.acfs: volume size = 4294967296 ( 4.00 GB )
mkfs.acfs: Format complete.
Register the ACFS file system with CRS:



$ORACLE_HOME/bin/srvctl add filesystem -d /dev/asm/sharedvol1-240 -m /acfspoc2 -u oracle -fstype ACFS -autostart ALWAYS

[root@rac1 ~]# crsctl stat res -t |grep acfs
ora.acfspoc.sharedvol1.acfs
ora.ora_data.sharedvol1.acfs
ONLINE ONLINE rac1 mounted on /acfspoc,
ONLINE ONLINE rac2 mounted on /acfspoc,
[root@rac1 ~]# crsctl status res ora.acfspoc.sharedvol1.acfs -t


Name Target State Server State details
--------------------------------------------------------------------------------

Local Resources
--------------------------------------------------------------------------------
ora.acfspoc.sharedvol1.acfs
OFFLINE OFFLINE rac1 STABLE
OFFLINE OFFLINE rac2 STABLE
--------------------------------------------------------------------------------

[root@rac1 ~]#
Start the ACFS file system resource:( on node 1 from the root)
[root@rac1 ~]# srvctl start filesystem -d /dev/asm/sharedvol1-240
[root@rac1 ~]#
[root@rac1 ~]# crsctl status res ora.acfspoc.sharedvol1.acfs -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------

Local Resources
--------------------------------------------------------------------------------
ora.acfspoc.sharedvol1.acfs
ONLINE ONLINE rac1 mounted on /acfspoc2
,STABLE
ONLINE ONLINE rac2 mounted on /acfspoc2
,STABLE

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

[root@rac1 ~]# srvctl config filesystem
Volume device: /dev/asm/sharedvol1-240
Diskgroup name: acfspoc
Volume name: sharedvol1
Canonical volume device: /dev/asm/sharedvol1-240
Accelerator volume devices:
Mountpoint path: /acfspoc2
Mount point owner: oracle
Mount point group: oinstall
Mount permissions: owner:oracle:rwx,pgrp:oinstall:r-x,other::r-x
Mount users: grid
Type: ACFS
Mount options:
Description:
ACFS file system is enabled
ACFS file system is individually enabled on nodes:
ACFS file system is individually disabled on nodes:
Volume device: /dev/asm/sharedvol1-302
Diskgroup name: ora_data
Volume name: sharedvol1
Canonical volume device: /dev/asm/sharedvol1-302
Accelerator volume devices:
Mountpoint path: /acfspoc
Mount point owner: oracle
Mount point group: oinstall
Mount permissions: owner:oracle:rwx,pgrp:oinstall:r-x,other::r-x
Mount users: grid
Type: ACFS
Mount options:
Description:
ACFS file system is enabled
ACFS file system is individually enabled on nodes:
ACFS file system is individually disabled on nodes:



Now validate the ACFS mount points

[grid@rac1 ~]$ df -h |grep asm
/dev/asm/sharedvol1-302 10G 97M 10G 1% /acfspoc
/dev/asm/sharedvol1-240 4.0G 85M 4.0G 3% /acfspoc2



[root@rac1 ~]# ssh rac2 df -h| grep asm

root@rac2's password:
/dev/asm/sharedvol1-302 10G 97M 10G 1% /acfspoc
/dev/asm/sharedvol1-240 4.0G 85M 4.0G 3% /acfspoc2


Resize ACFS
[grid@rac1 ~]$ asmcmd lsattr -l -G ACFSPOC
Name Value
access_control.enabled FALSE
access_control.umask 066
au_size 1048576
cell.smart_scan_capable FALSE
compatible.advm 12.1.0.0.0
compatible.asm 12.1.0.0.0
compatible.rdbms 12.1.0.0.0
content.check FALSE
content.type data
disk_repair_time 12.0h
failgroup_repair_time 24.0h
idp.boundary auto
idp.type dynamic
phys_meta_replicated true
sector_size 512
thin_provisioned FALSE

[grid@rac1 ~]$ acfsutil size 9G /acfspoc
acfsutil size: new file system size: 9663676416 (9216MB)
[grid@rac1 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 1.5G 0 1.5G 0% /dev
tmpfs 4.0G 1.1G 3.0G 27% /dev/shm
tmpfs 1.5G 26M 1.5G 2% /run
tmpfs 1.5G 0 1.5G 0% /sys/fs/cgroup
/dev/sda3 20G 4.4G 16G 23% /
/dev/sda7 5.9G 128M 5.8G 3% /tmp
/dev/sda2 30G 15G 15G 51% /u008
/dev/sda8 9.8G 33M 9.8G 1% /apps/goldengate
/dev/sda5 20G 5.7G 14G 29% /stage_software
/dev/sda1 30G 8.5G 21G 29% /u002
tmpfs 294M 0 294M 0% /run/user/1002
tmpfs 294M 12K 294M 1% /run/user/42
tmpfs 294M 0 294M 0% /run/user/1001
tmpfs 294M 0 294M 0% /run/user/0
/dev/asm/sharedvol1-302 9.0G 97M 9.0G 2% /acfspoc
/dev/asm/sharedvol1-240 4.0G 85M 4.0G 3% /acfspoc2

[grid@rac1 ~]$ acfsutil size 10G /acfspoc

acfsutil size: new file system size: 10737418240 (10240MB)
[grid@rac1 ~]$ df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 1.5G 0 1.5G 0% /dev
tmpfs 4.0G 1.1G 3.0G 27% /dev/shm
tmpfs 1.5G 26M 1.5G 2% /run
tmpfs 1.5G 0 1.5G 0% /sys/fs/cgroup
/dev/sda3 20G 4.4G 16G 23% /
/dev/sda7 5.9G 128M 5.8G 3% /tmp
/dev/sda2 30G 15G 15G 51% /u008
/dev/sda8 9.8G 33M 9.8G 1% /apps/goldengate
dev/sda5 20G 5.7G 14G 29% /stage_software
/dev/sda1 30G 8.5G 21G 29% /u002
tmpfs 294M 0 294M 0% /run/user/1002
tmpfs 294M 12K 294M 1% /run/user/42
tmpfs 294M 0 294M 0% /run/user/1001
tmpfs 294M 0 294M 0% /run/user/0
/dev/asm/sharedvol1-302 10G 97M 10G 1% /acfspoc
/dev/asm/sharedvol1-240 4.0G 85M 4.0G 3% /acfspoc2















Comments

Post a Comment

Popular posts from this blog

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...
Post a Comment
Read more

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...
Post a Comment
Read more

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...
Post a Comment
Read more