Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> file 24, couldnot online from a node (rac 9)
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
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
![]() |
![]() |