Getting error while starting oracle

[network_4]

Hi.. While starting oracle database getting below error, If any one can help me. I am using HP-UX 11.00 with oracle 8i.

+++++++++++++++++++++++++Error message+++++++++++

startup
ORACLE instance started.
Total System Global Area 1253846036 bytes
Fixed Size 76820 bytes
Variable Size 622977024 bytes
Database Buffers 614400000 bytes
Redo Buffers 16392192 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/ora8/oracle/oradata/pandb/rbs01.dbf'

[Peter Godron]

hi,
does your dbf file exist on the disk ?
What additional info is in the trc file ?

Looks like you are running Oracle 8 ?

Have you checked:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=567689
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=31164
https://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1083100
or even
http://www.jlcomp.demon.co.uk/faq/lostdatafile_nobackup.html
and metalink: 1060605.6 (Oracle 7)

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

[Hein van den Heuvel]

Well, looks like a bad-news - good news case.

The bad news is that a database file has been mangled. Hopefully it was teh only one.

The good news is that, judging by the name, this perticulare datafile did not hold critical information for restart.

Investigate a little as to what want wrong with file 3. Try things like:
#df /ora8/oracle/oradata
#ls -l ...
#dd bs=1024k if=/ora...rbs01.dbf of=/dev/nul

And then just drop bring up oracel, create a temporary system undo space, drop that RBS tablespace, create a fresh one, create teh segments, online the segments and go!

>> see DBWR trace file

Be sure to do that!

Hope this helps,

Hein van den Heuvel
HvdH Performance Consulting

[Peter Godron]

Hi,
can you now please update the thread with the feedback on the suggested solutions.

If the problem is solved, could you please complete the thread by awarding points to helpful answers and summarising the solution for you.

Please read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

So far you have only awarded points to 1 out of 16 answers !!