When creating a new lv In the RAC environment, ensure that the permissions of the two nodes are synchronized.

AIX5.3ORACLE10GRAC environment, because CHMOD and CHOWN are not synchronized in two nodes when creating the LV, the node that has not set the permission reports a ORA-01186ORA-01157ORA-01110 Error

AIX5.3 ORACLE10G RAC environment, when creating a LV because CHMOD, CHOWN is not synchronized in two nodes, resulting in nodes with no permissions set reported ORA-01186 \ ORA-01157 \ ORA-01110 Error

AIX5.3 Oracle10G RAC environment, when creating a LV because CHMOD, CHOWN is not synchronized in two nodes, resulting in nodes with no permissions set reported ORA-01186 \ ORA-01157 \ ORA-01110 error, then, the data file problem occurs during the urgent removal of the data file, and is finally restored through Media recovery. This case tells us that we must pay attention to the synchronization of the permissions of the two nodes, even if it is not synchronized, do not easily OFFLINE, you can try to restart the node that was not synchronized before.

-- Actual steps --

Create a data36_disk Data File
Use smit lv
Pp size: 256 megabyte (s)
PPs: 10

-- Permission settings
Chown oracle: dba/dev/data36_disk
Chown oracle: dba/dev/rdata11_disk
Chmod 777/dev/data36_disk
Chmod 777/dev/rdata11_disk
The fatal problem lies in this step, because operations are performed only on one node of RAC, and permissions on the other node still exist,
Although no error is reported for the add datafile below, an error message is displayed in the log of another node:

-- Add data files to database tablespace
# 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,200 7, Oracle. All Rights Reserved.

Connected:
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 2500 M;
Tablespace altered.

-- An ERROR occurs on the RAC2 node at this time.
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

-- Modify the file permissions of Node 2
Chown oracle: dba/dev/data36_disk
Chown oracle: dba/dev/rdata11_disk
Chmod 777/dev/data36_disk
Chmod 777/dev/rdata11_disk

-- The problem persists, so it is urgent to go offline.
SQL> alter database datafile '/dev/rdata11_disk' offline;
Database altered.

-- Modification completed, ORA-01113 error occurs when going online again
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'

-- Perform the recover operation as prompted
SQL> 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_2518213614088933.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

-- The above message shows the cannot open archived log '/home/oracle/archlog/produc1/2_17592_614088933.arc'
-- If the file is suspected to be lost, go to the relevant directory to confirm
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
-- Confirm no file