— Create ACFS filesystem on 12c Linux Exadata —
1. Create a volume in ASM
ASMCMD [+] > volcreate -G datac1 -s 500G ACFS_VOL If you get like below error ORA-15032: not all alterations performed ORA-15479: ASM diskgroup does not support volumes ORA-15221: ASM operation requires compatible.asm of 12.1.0.2.0 or higher (DBD ERROR: OCIStmtExecute Check the Current Compatibility for the Diskgroup select group_number, name,compatibility, database_compatibility from v$asm_diskgroup GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY ------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ 1 DATAC1 12.1.0.1.0 11.2.0.2.0 2 DBFS_DG 12.1.0.0.0 11.2.0.2.0 3 RECOC1 12.1.0.1.0 11.2.0.2.0 SQL> alter diskgroup DATAC1 set attribute 'compatible.asm'='12.1.0.2.0'; Diskgroup altered. SQL> alter diskgroup RECOC1 set attribute 'compatible.asm'='12.1.0.2.0'; Diskgroup altered. SQL> alter diskgroup DBFS_DG set attribute 'compatible.asm'='12.1.0.2.0'; Diskgroup altered. SQL> select group_number, name,compatibility, database_compatibility from v$asm_diskgroup; GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY ------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ 1 DATAC1 12.1.0.2.0 11.2.0.2.0 2 DBFS_DG 12.1.0.2.0 11.2.0.2.0 3 RECOC1 12.1.0.2.0 11.2.0.2.0 Run again the volcreate command ASMCMD [+] > volcreate -G datac1 -s 500G ACFS_VOL
2. Check the volume information
ASMCMD [+] > volinfo -G datac1 ACFS_VOL Diskgroup Name: DATAC1 Volume Name: ACFS_VOL Volume Device: /dev/asm/acfs_vol-45 State: ENABLED Size (MB): 512000 Resize Unit (MB): 64 Redundancy: MIRROR Stripe Columns: 8 Stripe Width (K): 1024 Usage: Mountpath: sqlplus "/as sysasm" SELECT volume_name, volume_device FROM V$ASM_VOLUME WHERE volume_name ='ACFS_VOL'; VOLUME_NAME ------------------------------ VOLUME_DEVICE -------------------------------------------------------------------------------- ACFS_VOL /dev/asm/acfs_vol-45
3. Create a file system with the Oracle ACFS mkfs command using output of above command
With root user run below command
/sbin/mkfs -t acfs /dev/asm/acfs_vol-45 mkfs.acfs: version = 12.1.0.2.0 mkfs.acfs: on-disk version = 39.0 mkfs.acfs: volume = /dev/asm/acfs_vol-45 mkfs.acfs: volume size = 536870912000 ( 500.00 GB ) mkfs.acfs: Format complete.
4. Register the file system with the acfsutil registry command.
Create a directory called ACFS
cd / mkdir /ACFS /sbin/acfsutil registry -a /dev/asm/acfs_vol-45 /ACFS acfsutil registry: mount point /ACFS successfully added to Oracle Registry
Imp Note 1: Registering an Oracle ACFS file system also causes the file system to be mounted automatically whenever Oracle Clusterware or the system is restarted.
Imp Note 2: Oracle ACFS registration (acfsutil registry) is not supported in an Oracle Restart (standalone) configuration, which is a single-instance (non-clustered) environment.
5. Verify if ACFS filesystem mounted automatically
$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbSys1 30G 17G 12G 59% / tmpfs 252G 22G 231G 9% /dev/shm /dev/sda1 496M 54M 418M 12% /boot /dev/mapper/VGExaDb-LVDbOra1 99G 57G 37G 61% /u01 /dev/mapper/VGExaDb-LVDbOra2 197G 68G 119G 37% /u02 /dev/mapper/VGExaDb-LVBkp1 985G 288G 648G 31% /u03 /dev/asm/acfs_vol-45 500G 1.1G 499G 1% /ACFS
As you can see from above output the ACFS filesystem moutned automatically after registration
6. If you did not register the ACFS filesystem it will not mount automatically, you can mount the ACFS filesystem manually using below command
As root user
/bin/mount -t acfs /dev/asm/acfs_vol-45 /ACFS
7. Give appropriate permissions to the filesystem required by Oracle users
chown -R oracle:dba /ACFS su - oracle cd /ACFS touch abc.txt
One comment
Reblogged this on EasyOraDBA | Shadab Mohammad.