本文共 8621 字,大约阅读时间需要 28 分钟。
In Exadata, ADVM (ACFS) volume cannot be created due to the next errors:
ASMCMD> volcreate -G DATA -s 250G volume1
ORA-15032: not all alterations performedORA-15479: ASM diskgroup does not support volumesORA-15221: ASM operation requires compatible.asm of 12.1.0.2.0 or higher (DBD ERROR: OCIStmtExecute)1) Error description:
15221, 00000, "ASM operation requires compatible.asm of %s or higher"
// *Cause: The ASM operation specified requires a higher disk group// attribute value for compatible.asm.// *Action: Set the disk group attribute compatible.asm to or above the// requested version.//
2) Affected diskgroup (e.g. +DATA) has set compatible.asm 11.2.0.4.0 and compatible.rdbms 11.2.0.2 attributes:
GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS COMPATIBILITY DATABASE_COMPATIBILITY
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1 DATA MOUNTED HIGH 429981696 216209696 11943936 68088586 0 11.2.0.4.0 11.2.0.2.0
NAME VALUE GROUP_NUMBER
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~compatible.asm 11.2.0.4.0 1compatible.rdbms 11.2.0.2 1
3) In order to enable ACFS in Exadata, compatible.asm and compatible.rdbms attributes must be set both = 12.1.0.2.0 or higher in the diskgroup.
1) In order to enable ACFS in Exadata, please set the following compatible attributes in the associated diskgroup (e.g. +DATA) as follows:
SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.advm' = '12.1.0.2.0';
SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'compatible.asm' = '12.1.0.2.0';
2) Check the new attributes values:
$> asmcmd lsattr -G DATA -l
Name Value access_control.enabled FALSE access_control.umask 066 appliance._partnering_type ODA FIXED appliance.mode TRUE appliance.name ODA au_size 4194304 cell.smart_scan_capable FALSE cell.sparse_dg allnonsparsecompatible.advm 12.1.0.2.0compatible.asm 12.1.0.2.0 compatible.rdbms 11.2.0.4.0 content.check FALSE content.type data disk_repair_time 3.6h failgroup_repair_time 24.0h idp.boundary auto idp.type dynamic logical_sector_size 512 phys_meta_replicated true sector_size 512 thin_provisioned FALSE
3) And then create the ADVM volume as follows:
ASMCMD> volcreate -G DATA -s 250G volume1
=======================
ACFS是一个支持多个平台,可扩展的,基于ORACLE ASM的集群文件系统,可以用来存储数据库和各种应用的文件,包括数据库的trace文件,alert日志文件和配置文件等等,也可以用来存储视频,音频,文本,图片等文件。
一.查看集群中acfs相关服务是否正常
[grid@rac1 ~] crs_stat –t –v | grep –E ‘acfs|dg’
二.创建acfs逻辑卷
[grid@rac1 ~] asmcmd
ASMCMD [+] > volcreate -G data -s 10G volume1 # -G 磁盘组,-s 大小
ASMCMD [+] > volinfo -G data volume1 # 查看逻辑卷信息
Diskgroup Name: DATA
Volume Name: VOLUME1
Volume Device: /dev/asm/volume1-123 # 生成的设备名称
State: ENABLED
...
三.创建acfs文件系统
[root@rac1 ~] /sbin/mkfs -t acfs /dev/asm/volume1-123
mkfs.acfs: version = 11.2.0.1.0.0
mkfs.acfs: on-disk version = 39.0
mkfs.acfs: volume = /dev/asm/volume1-123
mkfs.acfs: volume size = 10737418240
mkfs.acfs: Format complete.
四.挂载acfs文件系统
[root@rac1 ~] /bin/mount -t acfs /dev/asm/volume1-123 /acfs1
五.注册acfs文件系统到集群
[root@rac1 ~] /sbin/acfsutil registry -a /dev/asm/volume1-123 /acfs1
注:注册后其他节点无需任何操作就可使用了,如果没有注册这一步,其他节点需要使用此文件系统的话,执行第六步
六.节点2启用acfs文件系统(如果执行了第五步,此步跳过)
[grid@rac1 ~] asmcmd
ASMCMD [+] > volenable -G data volume1
ASMCMD [+] > volinfo -G data volume1
[root@rac1 ~] /bin/mount -t acfs /dev/asm/volume1-123 /acfs1
七.授权acfs文件系统,测试是否能使用
[root@rac1 ~] chown –R oracle. /acfs1
[root@rac1 ~] echo “test acfs” > /acfs1/test.txt
[root@rac1 ~] cat /acfs1/test.txt
test acfs
------------------------------
This post talks about an Exadata RAC ASM issue. This issue is observed after completing Exadata patching. It is observed that the ACFS mount point is missing. The following steps explains how we identified the issue and How can we troubleshoot this issue.
This is a 8 node Exadata full rack. The ACFS mount point is missing on first node , but all other 7 nodes have this ASM mount point.
First try to get the missing mount point …
Use “df –h” on any node where you can see the ACFS mount point. In our case getting the ACFS mount point details from node2 exaaskmdb02
[root@exaaskmdb02 ~]# df -h /u01/app/askmacfs
Filesystem Size Used Avail Use% Mounted on /dev/asm/askmdata-282 512G 64G 449G 13% /u01/app/askmacfs [root@exaaskmdb01 ~]#
Check1 :
Using these details, try to manually mount the ACFS on node1 exaaskmdb01
[root@exaaskmdb01 ~]# mount -t acfs /dev/asm/askmdata-282 /u01/app/askmacfs
mount.acfs: CLSU-00100: operating system function: open64 failed with error data: 2 mount.acfs: CLSU-00101: operating system error message: No such file or directory mount.acfs: CLSU-00103: error location: OOF_1 mount.acfs: CLSU-00104: additional error information: open64 (/dev/asm/askmdata-282) mount.acfs: ACFS-02017: Failed to open volume /dev/asm/askmdata-282. Verify the volume exists. [root@exaaskmdb01 ~]#
We are not able to mount the ACFS mountpoint. The first approach for any troubleshooting is to analyze the error messages. Cetain times, there could be useful error messages, which can directly help to point to the issue. But sometimes, the error messages may not help to focus on the real issue , rather informational messages. Your experience will count a lot in these scenarios where you should be able to relate the error message to the issue.
Check2:
The error message which caught to our attention is “No such file or directory”. Now our next check will be to check the directories…
On exaaskmdb01 check the directories /dev/asm/askmdata-282 and /u01/app/askmacfs
[root@exaaskmdb01 ]# ls -lrt /dev/asm/askmdata-282
ls: cannot access /dev/asm/askmdata-282: No such file or directory[root@exaaskmdb01 ]# ls -ld /u01/app/askmacfs
drwxrwxr-x 11 grid oinstall 4096 May 9 12:00 /u01/app/askmacfs
Same thing, verify on any other node ( 2-8)
[root@exaaskmdb02 ]# ls -lrt /dev/asm/askmdata-282
brwxrwx--- 1 root asmadmin 248, 144385 Sep 12 15:33 /dev/asm/askmdata-282[root@exaaskmdb02 ]# ls -ld /u01/app/askmacfs
drwxrwxr-x 11 grid oinstall 4096 May 9 12:00 /u01/app/askmacfs
From the above check, it is clear that node1 exaaskmdb01 is missing a directory. Now lets check further how to bring this directory. As these are ACFS mounts, there could be possibility that these are missing due to ACFS drivers not loading properly during node reboot. Let’s concentrate on the ACFS drivers….
Check3:
Check acfs modules to be loaded …
[root@exaaskmdb01 ~]# lsmod | grep oracle
oracleacfs 4825088 0 oracleadvm 806912 3 oracleoks 659456 2 oracleacfs,oracleadvm
This check looks good, the acfs drivers are loaded properly. The next check would be to check the ACFS volume informaiton.
Check4:
ASMCMD> volinfo --all
Diskgroup Name: ASKM_DGVolume Name: ASKMDATA
Volume Device: /dev/asm/askmdata-282 State: DISABLED <<<< Check this. This volume is disabled. Size (MB): 524288 Resize Unit (MB): 64 Redundancy: MIRROR Stripe Columns: 8 Stripe Width (K): 1024 Usage: ACFS Mountpath: /u01/app/askmacfs
From the above output, we get that the volume is disabled. Now let’s check the same thing on the other nodes exaaskmdb02-08
[grid@exaaskmdb02 ~]$ asmcmd
ASMCMD> volinfo --all Diskgroup Name: ASKM_DGVolume Name: ASKMDATA
Volume Device: /dev/asm/askmdata-282 State: ENABLED <<< It is enabled on node2 Size (MB): 524288 Resize Unit (MB): 64 Redundancy: MIRROR Stripe Columns: 8 Stripe Width (K): 1024 Usage: ACFS Mountpath: /u01/app/askmacfs
From the above check4, we understood that this is due to the reason that the volume is not enabled by default after patching. Now we need to enable this volume and mount this ACFS manually.
Solution
ASMCMD> volenable -G ASKM_DG -a
ASMCMD> volinfo --all Diskgroup Name: ASKM_DGVolume Name: ASKMDATA
Volume Device: /dev/asm/askmdata-282 State: ENABLED Size (MB): 524288 Resize Unit (MB): 64 Redundancy: MIRROR Stripe Columns: 8 Stripe Width (K): 1024 Usage: ACFS Mountpath: /u01/app/askmacfsASMCMD> exit
[grid@exaaskmdb01 ~]$ ls -lrt /dev/asm/askmdata-282 brwxrwx--- 1 root asmadmin 248, 144385 Sep 12 15:56 /dev/asm/askmdata-282[root@exaaskmdb01 ~]# ls -ld /u01/app/askmacfs
drwxrwxr-x 2 grid oinstall 4096 Mar 18 2016 /u01/app/askmacfs[root@exaaskmdb01 ~]# mount -t acfs /dev/asm/askmdata-282 /u01/app/askmacfs
[root@exaaskmdb01 ~]# df -h /u01/app/askmacfs
Filesystem Size Used Avail Use% Mounted on /dev/asm/askmdata-282 512G 64G 449G 13% /u01/app/askmacfs [root@exaaskmdb01 ~]#
转载地址:http://jisof.baihongyu.com/