Re: Dabatabase problem !!!! URGENT !!!!

Mark Powell wrote:

> Since you do not care about the lost files, re-create the entire database.
> First make sure that there are no files remaining like redo and control and
> then write a create database script to start all over.
>
> If you had a full export file you could recreate the missing tablespaces
> using it. If the system tablespace still exists you could use the alter
> database command to remove all missing files and open what is left. You
> could then drop and re-create the tablespaces.
>
> Either way good luck.
>
> Diego Pafumi <dpafumi_at_us.oracle.com> wrote in article
> <3652FEA4.3AE654D4_at_us.oracle.com>...
> > hi gurus !!!
> > I have a big question. I'm new here and someone delete all the *.dbf and
> > we don't have a backup. So what I want to do, is to re-install our
> > application. I don't care about the previous data there. So .... how can
> > I do to run my create tablespace commands????
> > because I'm trying to do under the svrmgrl, but I received a message as
> > "database not open" (previous I did a startup, but I received a ORA-1110
> > datafile not found).
> > So I don't know how to continue ????
> >
> > Thanks a lot !!!
> >
> > Diego
> >
> >

  Consider also to maintain/update your initSID.ora file. Yakub Received on Fri Dec 25 1998 - 00:00:00 CET