Re: Help - Deleted ORA file and no Recent Backup

Assuming you are running the DB in archivelog mode, you will need to 1)shutdown the DB
2)restore the lost datafile from a backup, and archiv log files for that backup

3)mount the database
4)recover the datafile
5)open the database

HTH Neil

Andrew McKelvie wrote:
>
> We did something silly today with our Oracle 7.3 server and need some help
> fixing it.
>
> We deleted one of the user .ORA files because it had grown too large, 900 MB
> instead of 50 MB, and we wanted to rebuild it afresh. Unfortunatly we now
> can't start the instance even although all three of the services are running
> OK. We think that Oracle is looking for the .ORA file that we deleted and
> because it is missing Oracle thinks that the database is corrupt.
>
> Is there anyway of fixing this other than completely re-installing Oracle
> and recreating the users and the tables within the instance please let me
> know?
>
> TIA
>
> Andrew
Received on Fri Feb 04 2000 - 07:15:29 CST