Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: only DBF

Re: only DBF

From: Thierry <thierry.constant2_at_wanadoo.fr>
Date: Sun, 7 Oct 2001 11:13:08 +0200
Message-ID: <3bc01c58$0$3654$626a54ce@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US