Re: Datafile deleted URGENT

Can you give us some more details..

1. Do you run in ARCHIVE LOG MODE
2. What backups do you have, COLD or HOT
3. If COLD how frequently like ONCE A NIGHT
4. Do you exports of your DB is so how frequently..

Reply

Regards

Vijay K Banda

Piotr Kolodziej <pkol_at_otago.gda.pl> wrote in article <6mlt2h$ggk$1_at_sunrise.pg.gda.pl>...
> >Question: someone deleted my datafiles on my Oracle Vesion 7.3.3 running
> >on SUN Solaris 2.55. Currently the database is complaining of read error
> >and cannot insert into tables, as these datafiles were used for index.
> >
> >I have tried using "alter database datefile ' ' offline drop" and then
> >do "recover database until cancel" but it still does not work.
> >
> >Could someone please help urgently.
>
>
> Is your database in archivelog or noarchivelog ?
> If in noarchivelog, you have to restore all database from
> backup or export.
>
> Regards,
> Piotr
>
>
Received on Mon Jun 22 1998 - 10:48:36 CDT