file 24, couldnot online from a node (rac 9)

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Fri, 25 May 2007 19:26:24 +0700
Message-ID: <3edcb66e0705250526o114533cag2ccf10248d0b8810@mail.gmail.com>

some strange:
oracle 9i 9.2.0.6
fujitsu primecluster
solaris 9

on node 2, i could not online file 24, due to file not found, but it really there (i'm using softlink to /dev/rdsk)

ORA-01157: cannot identify/lock data file 24 - see DBWR trace file
ORA-01110: data file 24: '/oradata/PRSMA/prsma_raw_system_10g'
ORA-27041: unable to open file

SVR4 Error: 6: No such device or address Additional information: 2

ORA-01186: file 24 failed verification tests
ORA-01157: cannot identify/lock data file 24 - see DBWR trace file
ORA-01110: data file 24: '/oradata/PRSMA/prsma_raw_system_10g'

from node 1, it is OK.

node 2

SQL> select status,error,format from v$datafile_header where file#=24;

STATUS  ERROR                    FORMAT


------- -------------------- ----------

ONLINE  FILE NOT FOUND                0

node 1:

SQL> select status,error,format from v$datafile_header where file#=24;

STATUS  ERROR                    FORMAT


------- -------------------- ----------

ONLINE                                8

--

regards
ujang
--

http://www.freelists.org/webpage/oracle-l Received on Fri May 25 2007 - 07:26:24 CDT