Re: Startup without redo logs?

Before you recreate the database, should you drop or delete the database first? Otherwise how to recreate the database while it already exists?

Please clarify, thanks a lot.

Cheers,
JK

"koert54" <k_at_k.com> wrote in message news:<yfm27.4729$z7.1186586_at_afrodite.telenet-ops.be>...
> if an alter database open resetlogs won't work try setting the following
> parameter in
> your init.ora :
> _allow_resetlogs_corruption=TRUE
> startup the db
> export the db
> recreate the db
> import the db
>
> cheers
> Kurt
>
>
> "Knut Talman" <knut.talman_at_mytoys.de> wrote in message
> news:3B49EA03.E08B354E_at_mytoys.de...
> > Hi,
> >
> > in our test environment a disk group had bad superblocks.
> > After fsck all of the redo logs are lost. Now I added new
> > logfile groups and tried to drop the old (missing) ones.
> > Of course, I could not drop or even clear all of them, because:
> >
> > ORA-01624: log 3 needed for crash recovery of thread 1
> > ORA-00312: online log 3 thread 1: '/opt/oracle/redo/redo31.log'
> > ORA-00312: online log 3 thread 1: '/opt/oracle/redo/redo32.log'
> >
> > Question: Is there any possiblity to bring a database online
> > in this situation (with no backup)?
> >
> > Regards,
> >
> > Knut
Received on Sat Jul 21 2001 - 16:34:48 CDT