遇到ORA-01157 ORA-01110莫紧张，定睛一看也简单

1. 故障现象
运行查表空间脚本报错如下:

ERROR at line 1:
   ORA-01157: cannot identify/lock data file 
   1732 - see DBWR trace file
   ORA-01110: data file 1732: '/dev/rtestlv'
复制

2. 故障分析

##告警日志显示
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
Errors in file /home/oracle/app/oracle/diag/rdbms/xxx/XXXX/trace/XXXX_dbw0_43909598.trc:
ORA-01186: file 1732 failed verification tests
ORA-01157: cannot identify/lock data file 1732 - see DBWR trace file
ORA-01110: data file 1732: '/dev/rtestlv'
File 1732 not verified due to error ORA-01157
Errors in file /home/oracle/app/oracle/diag/rdbms/xxx/XXXX/trace/XXXX_dbw0_43909598.trc:
ORA-01157: cannot identify/lock data file 1732 - see DBWR trace file
ORA-01110: data file 1732: '/dev/rtestlv'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 13: Permission denied
Additional information: 11
Errors in file /home/oracle/app/oracle/diag/rdbms/xxx/XXXX/trace/XXXX_dbw0_43909598.trc:
ORA-01186: file 1732 failed verification tests
ORA-01157: cannot identify/lock data file 1732 - see DBWR trace file
ORA-01110: data file 1732: '/dev/rtestlv'
File 1732 not verified due to error ORA-01157
Wed Jan 23 14:36:31 2019
复制

3. 故障原因
原因:一 ，二节点裸设备文件属组不一致

4. 解决办法

XXX_RAC2[/dev]#ls -lrt **testlv
brw-rw----    1 root     system       50,547 Jan 21 17:21 testlv
crw-rw----    1 root     system       50,547 Jan 21 17:21 rtestlv

XXX_RAC2[/dev]#chown oracle:dba rtestlv

最后我们 check 一下 datafiles来更新该实例的sga信息,问题解决:
SQL> alter system check datafiles;

复制