Oracle 11g ASM: how to create an Oracle ACFS File System in ASMCMD command line tool

Oracle 11g ASM: how to create an Oracle ACFS file system experiment environment in ASMCMD command line tool: Oracle 11g R2 RAC (11.2.0.3.5) oracle Enterprise Linux 5.6x86 1. Create an ASM disk group and mount the disk on two nodes. Then, partition the disk on the first node. [root @ rac1 ~] # Fdisk-lDisk/dev/sde: 2147 MB, 2147483648 bytes255 heads, 63 sectors/track, 261 cylindersUnits = cylinders of 16065*512 = 8225280 bytes Device Boot Start End Blocks Id System/dev/sde1 1 261 2096451 83 Linux creates an ASM disk on node 1st [root @ rac1 ~] # Oracleasm createdisk GOLDENGATE/dev/sde1 [root @ rac1 ~] # Oracleasm scandisks [root @ rac1 ~] # Oracleasm listdisksDATAFRAGOLDENGATEOCR_VOTE scan the ASM disk on node 2nd [root @ rac2 ~] # Oracleasm listdisksDATAFRAGOLDENGATEOCR_VOTE switch to the grid user on the first node. Execute ASMCA to create an ASM disk group. Create Oracle ADVM volume and diskgroup COMPATIBLE on the ASM diskgroup. ASM and COMPATIBLE. ADVM compatibility must be set to 11.2.0.2. You can select "Advanced Options" when creating a disk group to set this attribute for diskgroup. You can also use SQL commands to create or modify this attribute for a disk group. The method is as follows: alter diskgroup goldengate set attribute 'compatible. asm '= '11. 2.0.2 '; alter diskgroup goldengate set attribute' compatible. rdbms '= '11. 2.0.2 '; alter diskgroup goldengate set attribute' compatible. advm '= '11. 2.0.2'; 2. Create an Oracle ADVM volume and switch to the grid user. Go to the ASMCMD command line interface su-grid [grid @ rac1 ~]. $ Export ORACLE_SID = + ASM1 [grid @ rac1 ~] $ Asmcmd verify the actual size of the created ASM disk group ASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB quota Offline_disks Voting_files NameMOUNTED extern n 512 4096 1048576 5114 0 3027 0 0 n data/MOUNTED extern n 512 4096 1048576 5114 0 4613 0 0 n fra/mounted extern n 4613 512 4096 1048576 29 0 29 0 n goldengate/mounted extern n 2047 512 4096 1048576 0 2047 0 0 Y OCR_VOTE /create Ora Cle ADVM volume ASMCMD> volcreate-g goldengate-s 1900 m GOLDENGATE note that the size specified by the-s option must not exceed the actual size value displayed by the lsdg. Otherwise, the following error is reported: ASMCMD> volcreate-g goldengate-s 1950 m GOLDENGATEORA-15032: not all alterations performedORA-15041: diskgroup "GOLDENGATE" space exhausted (dbd error: OCIStmtExecute) determine whether the Oracle ADVM Volume creates ASMCMD> volinfo-g goldengate GOLDENGATEDiskgroup Name: GOLDENGATE Volume Device:/d Ev/asm/goldengate-257 State: ENABLED Size (MB): 1920 Resize Unit (MB): 32 Redundancy: UNPROT Stripe Columns: 4 Stripe Width (K): 128 Usage: Mountpath: SQL> col volume_device for a30SQL> col volume_name for a30SQL> SELECT volume_name, volume_device FROM V $ ASM_VOLUME 2 WHERE volume_name = 'goldengat'; VOLUME_NAME VOLUME_DEVICE contains invalid GOLDENGATE/d Ev/asm/goldengate-2573, create an Oracle ACFS File System [root @ rac1 ~] #/Sbin/mkfs-t acfs/dev/asm/goldengate-257mkfs.acfs: version = 11.2.0.3.0mkfs.acfs: on-disk version = 3920.mkfs.acfs: volume =/dev/asm/goldengate-257mkfs.acfs: volume size = 2013265920mkfs. acfs: Format complete. create an ACFS file system mount point on node 1 and node 2 [root @ rac1 ~] # Su-oracle [oracle @ rac1 ~] $ Mkdir-p/home/oracle/ggs [root @ rac2 ~] # Su-oracle [oracle @ rac2 ~] $ Mkdir-p/home/oracle/ggs register the just-created ACFS File System in the cluster mount registery, or manually mount it without registration. The advantage of registering an ACFS file system is that when the cluster checks mount registery every 30 seconds, the file system is automatically mounted on each node, when the cluster software or system is restarted, the file system is automatically mounted. [Root @ rac1 ~] #/Sbin/acfsutil registry-a/dev/asm/goldengate-257/home/oracle/ggsacfsutil registry: mount point/home/oracle/ggs successfully added to Oracle Registry manual mount command: [root @ rac1 ~] #/Bin/mount-t acfs/dev/asm/goldengate-257/home/oracle/ggs wait 30 seconds after executing the registration command, check whether the ACFS file system is attached to each node [root @ rac1 ~]. # Df-hFilesystem Size Used Avail Use % Mounted on/dev/sda1 30G 20G 7.7G 73% // dev/sda3 1003 M 39 M 914 M 5%/tmptmpfs 1.3G 454 M 814 M 36%/dev/shm/dev/asm/goldengate-257 1.9G 73 M 1.9G 4%/home/oracle/ggs [oracle @ rac2 ~] $ Df-hFilesystem Size Used Avail Use % Mounted on/dev/sda1 30G 21G 7.3G 74% // dev/sda3 1003 M 39 M 914 M 5%/tmptmpfs 1.3G 450 M 818 M 36%/dev/shm/dev/asm/goldengate-257 1.9G 137 M 1.8G 8%/home/oracle/ggs4, test file system [root @ rac1 ~] # Chown-R oracle: oinstall/home/oracle/ggs Node 1 [oracle @ rac1 ~] $ Echo "Oracle ACFS File System">/home/oracle/ggs/acfs. log [oracle @ rac1 ggs] $ more/home/oracle/ggs/acfs. logOracle ACFS File System Section 2 [oracle @ rac2 ~] $ More/home/oracle/ggs/acfs. logOracle ACFS File System