OraFAQ Forum: Server Administration » Problem in dbw0 trace file

Home » RDBMS Server » Server Administration » Problem in dbw0 trace file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in dbw0 trace file [message #191833]

Fri, 08 September 2006 05:26

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

Report message to a moderator

Re: Problem in dbw0 trace file [message #191836 is a reply to message #191833]

Fri, 08 September 2006 05:29

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Is the file physically present, i mean at the OS level?

Report message to a moderator

Re: Problem in dbw0 trace file [message #191858 is a reply to message #191836]

Fri, 08 September 2006 07:10

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

No, could you please tell me what needs to be done in this case?

Report message to a moderator

Re: Problem in dbw0 trace file [message #191897 is a reply to message #191833]

Fri, 08 September 2006 09:18

KenJ
Messages: 69
Registered: July 2006
Location: London

Member

Restore and recover the file from a backup. If no backup, then you have problems.

Report message to a moderator

Previous Topic:	unlocking a object
Next Topic:	date and time the a DB user logged into DB ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 16:27:09 CST 2025