Re: Redolog file can not be written to HD

if you do not have space for your logs than the simplest way to solve it is:

1. shutdown the database.
2. make a cold backup of ALL the files (control, data even init.ora)
3. delete all your log files.
4. restart the database in archive mode.

In case of restore you will have to start from restoring the files from the backup, apply all the logs and so on.

There are many other ways. This is the simplest.

George

<u132781982_at_spawnkill.ip-mobilphone.net> wrote in message news:l.985722315.1556457519@[198.138.198.252]...
> After upgraded from 8.1.6 to 8.1.7, everything seems
> to work fine except the redologs can not be written
> to the Disk. After all the online redos have been
> filled up, database just hung there. We would have
> to restart the database. So we are now forced to run
> the database in NOARCHIVELOG mood.
>
> Could somebody help me please?
> Thanks
>
>
>
>
> --
> Sent by dbadba62 from hotmail part of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Tue Mar 27 2001 - 20:40:37 CST