Re: redologs removed

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<bf5vnu$poh$1_at_news.fujitsu-siemens.com>...
> Knackeback wrote:
> > During a large update the redolog-files filled up my oracle partition
> > completely.
> > The database came to a standstill.
> > I rebooted my machine but was still not able to start the database.
> > Now I did a big big mistake - I removed the redolog files to get
> > temporary space (my idea was to shrink datafiles after the database
> > would
> > be online again).
> > The database now complains exactly about the missing redolog files.
> > Is there a way to make the database fit for work without recreate it ?
> Yes. Look up carefully what "alter database open resetlogs" means,
> when to use it, its implications, what you lose and then do it.
> And put your redologs on a different disks. I know, it's always a fight with
> the HW admin but one that should be fought.
>
> Lots of Greetings!
> Volker

Knackeback, Volker's advice may work if the 'current' redo log is still there, otherwise you would have potential corruption since current redo log activity may or may not have been written to disk. If this is a production db then your best option might be to perform a point in time recovery up throught the last archived redo log before the problem.

HTH -- Mark D Powell -- Received on Thu Jul 17 2003 - 08:00:24 CDT