Re: BIG PROBLEM - NEED HELP

Sabrina wrote:

> Hi everybody,
>
> I tried to start my database and get following error:
>
> *** SESSION ID:(2.1) 2003-09-06 21:49:14.344
> ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
> ORA-01110: data file 8: 'F:\DB STORAGE\USER1TREASURY01.ORA'
> ORA-27048: skgfifi: file header information is invalid
> OSD-04004: invalid file-header
> ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
> ORA-01110: data file 9: 'F:\DB STORAGE\USER1TREASURY02.ORA'
> ORA-27041: unable to open file
>
> The files "user1treasury01 and 02 doesnīt exist. What can I do to start the
> database?
> ITīS VERY URGENT
The FIRST thing you should do is calm down, take a couple of deep breaths and then start a full system backup. While it runs, you'll have time to rationally decide what your "best" option is and how to accomplish that goal. Just getting the DB open, is the least of your current problems.

The following need to be answered:
What caused the two files to disappear?
What can be done to prevent additional files from going missing? How are you going to recover the data that was in the two lost files? Received on Sat Sep 06 2003 - 16:58:27 CDT