Re: Reducing Redo Log

From: <ttitus_at_my-dejanews.com>
Date: Sat, 13 Jun 1998 14:33:18 GMT
Message-ID: <6lu2je$a8h$1@nnrp1.dejanews.com>

Welcome to the world of undocumented Oracle parameters.

In Oracle 7.3, do the following: - disable archiving - add the following to your init.ora file: _disable_logging = TRUE _allow_resetlogs_corruption = TRUE - then startup mount, and finally open database recover autocancel should do the trick

Be sure to have a full backup; I've tried this a couple of times and in one case had to completely recreate the database.

Tobias Titus

In article <1998060902120300.WAA16067_at_ladder03.news.aol.com>, razer99_at_aol.com (Razer99) wrote:
>
> Along a similar track.
> I have a client from the mainframe world who would like
> to COMPLETELY turn off redo logs at night for
> batch processing. I disagree with this, but...
>
> Is their anyway to do that with having to alert all the tables?
> Could you redirect the redo logs to /dev/null
>
> As I recall the Oracle books state that you
> MUST have at least two redo logs at all times.
>
> rick tucker
> razer99_at_aol.com
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat Jun 13 1998 - 09:33:18 CDT