Re: only DBF

From: koert54 <koert54_at_nospam.com>
Date: Sat, 06 Oct 2001 15:30:10 GMT
Message-ID: <6sFv7.88941$6x5.19740254@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 Sat Oct 06 2001 - 10:30:10 CDT