Re: Please NEED HELP A.S.A.P S.O.S !!!!!!!!!!!!!

It depends on what you have on that datafile and if you want to keep that data at all. If you are running in noarchive log mode, just to open the database for user, you can bring that datafile offline and then drop the whole tablespace (alter database datafile '<..>' offline drop;) Then go to a test box, restore the last cold backup you have on the system, do a export on the tables which resign on that tablespace. Then go back to the production database, import the table back. You will still lose some data.

If you are running archive log file, you can try to recover to the time before Dr. Watson killed the Oracle processes.

Winnie

Vitaliy Mogilevskiy wrote in message <360062EA.6A2042C3_at_earthlink.net>...
>Oracle: 7.3.2.3.15
>OS: WindowsNT 4.0
>
>DR. Watson killed Oracle Proceses
>After restarting a server can not open database:
>
>ORA-01157: can not identify datafile 32 - file not found
>ORA-01110: data file 32: 'ARD02.DBF'
>
>The file is there but Oracle doesnot see it, because the file's date is
>7/27/98
>and all data files have current date stamp on them. Dr. Watson some how
>changed the
>date stamp on the file.
>
>Please help!!!!!!!!!!!!!!!!! Oracle support says we need to go to last
>knight backup set,
>Is there any other way to fix this mess.
>
>Thank You Vitaliy Mogilevskiy,
>Kittrich Corporation
>
Received on Thu Sep 17 1998 - 00:20:46 CDT