Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: only DBF
Thanks for the answer...
"koert54" <koert54_at_nospam.com> a écrit dans le message de news:
6sFv7.88941$6x5.19740254_at_afrodite.telenet-ops.be...
> yes - if the database was shutdown first (normal, immediate or
> transactional - not abort) so a checkpoint was given to the
> datafiles.
> 1. recreate the init file (easy - it's a text file - throw some parameters
> in it or take a copy from another DB and adjust)
> 2. recreate the controlfile (see the 'create controlfile' statement)
> 3. startup nomount and launch the create controlfile statement
> 4. alter database open resetlogs (this will recreate your redolog files -
> because a checkpoint was given during shutdown no
> transactions were lost)
>
> cheers,
> Kurt
>
> "Thierry" <thierry.constant2_at_wanadoo.fr> wrote in message
> news:3bbf301e$0$1558$626a54ce_at_news.free.fr...
> > Hi,
> >
> > Is it possible to startup a database having only the *.dbf files ??
> > (i.e. no init, control, redo log ... )
> >
> > If yes, could you tell me how ?
> >
> > Thanks in advance ...
> >
> >
> >
>
>
Received on Sun Oct 07 2001 - 04:13:08 CDT