aix5.3 oracle10g rac环境，新建lv时由于chmod、chown未在两个节点同步，导致未设置权限的节点报ora-01186\ora-01157\ora-01110错误，后对数据文件紧急下线过程中又出现数据文件问题，最后通过media recovery恢复。该案例告诉我们务必注意两个节点权限的同步，即使不同步也不要轻易offline，可尝试重启之前未同步的节点。
--实际步骤--
新建data36_disk数据文件
通过smit lv
pp size: 256 megabyte(s)
pps: 10
--权限设置
chown oracle:dba /dev/data36_disk
chown oracle:dba /dev/rdata11_disk
chmod 777 /dev/data36_disk
chmod 777 /dev/rdata11_disk
致命的问题就出在这一步，因为只在rac的其中一个节点进行了操作，，另外一个节点的权限仍然有问题，
虽然下面的add datafile没有报错，但是另外一个节点的日志出现了错误提示：
--向数据库表空间添加数据文件
# su - oracle
[you have new mail]
$ sqlplus / as sysdba
sql*plus: release 10.2.0.4.0 - production on sat feb 12 21:26:42 2011
copyright (c) 1982, 2007, oracle. all rights reserved.
connected to:
oracle database 10g enterprise edition release 10.2.0.4.0 - 64bit production
with the partitioning, real application clusters, olap, data mining
and real application testing options
sql> alter tablespace produc_data add datafile '/dev/rdata11_disk' size 2500m;
tablespace altered.
--这个时候rac2节点出现error
sat feb 12 21:33:00 2011
errors in file /home/oracle/admin/produc/bdump/produc2_dbw0_803734.trc:
ora-01186: file 45 failed verification tests
ora-01157: cannot identify/lock data file 45 - see dbwr trace file
ora-01110: data file 45: '/dev/rdata11_disk'
file 45 not verified due to error ora-01157
--修改节点2的相关文件权限
chown oracle:dba /dev/data36_disk
chown oracle:dba /dev/rdata11_disk
chmod 777 /dev/data36_disk
chmod 777 /dev/rdata11_disk
--问题依旧，于是紧急下线
sql> alter database datafile '/dev/rdata11_disk' offline;
database altered.
--修改完成，再次上线时出现ora-01113错误
sql> alter database datafile '/dev/rdata11_disk' online;
alter database datafile '/dev/rdata11_disk' online
*
error at line 1:
ora-01113: file 48 needs media recovery
ora-01110: data file 48: '/dev/rdata11_disk'
--根据上述提示进行recover操作
sql> recover datafile recover datafile '/dev/data36_disk';
ora-00279: change 2986334634 generated at 02/12/2011 21:40:35 needed for thread1
ora-00289: suggestion : /home/oracle/archlog/produc1/1_25181_614088933.arc
ora-00280: change 2986334634 for thread 1 is in sequence #25181
specify log: {=suggested | filename | auto | cancel}
ora-00279: change 2986334634 generated at 02/12/2011 19:35:48 needed for thread2
ora-00289: suggestion : /home/oracle/archlog/produc1/2_17592_614088933.arc
ora-00280: change 2986334634 for thread 2 is in sequence #17592
specify log: {=suggested | filename | auto | cancel}
ora-00308: cannot open archived log '/home/oracle/archlog/produc1/2_17592_614088933.arc'
ora-27037: unable to obtain file status
ibm aix risc system/6000 error: 2: no such file or directory
additional information: 3
--上面提示cannot open archived log '/home/oracle/archlog/produc1/2_17592_614088933.arc'
--怀疑文件丢失，进入相关目录确认
sql> exit
disconnected from oracle database 10g enterprise edition release 10.2.0.4.0 - 64bit production
with the partitioning, real application clusters, olap, data mining
and real application testing options
$ cd /home/oracle/archlog/produc1/
$ ls -lt|grep 2_17592_614088933
--确认没有文件