Home » RDBMS Server » Server Administration » Problem in dbw0 trace file
Problem in dbw0 trace file [message #191833] Fri, 08 September 2006 05:26 Go to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Dear All,
I am getting the following error while starting DB in test_dbw0_2246.trc

ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/ora3/oradata/test/temp_01.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory


UNIX : SunOs 5.8
DB : Oracle 9.2.0

Reply in Advance,
Shahnaz
Re: Problem in dbw0 trace file [message #191836 is a reply to message #191833] Fri, 08 September 2006 05:29 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Is the file physically present, i mean at the OS level?
Re: Problem in dbw0 trace file [message #191858 is a reply to message #191836] Fri, 08 September 2006 07:10 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
No, could you please tell me what needs to be done in this case?
Re: Problem in dbw0 trace file [message #191897 is a reply to message #191833] Fri, 08 September 2006 09:18 Go to previous message
KenJ
Messages: 69
Registered: July 2006
Location: London
Member
Restore and recover the file from a backup. If no backup, then you have problems.
Previous Topic: unlocking a object
Next Topic: date and time the a DB user logged into DB ?
Goto Forum:
  


Current Time: Mon Dec 05 09:06:26 CST 2016

Total time taken to generate the page: 0.17492 seconds