file 24, couldnot online from a node (rac 9)
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 25 May 2007 19:26:24 +0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
