Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reducing Redo Log
On Sat, 13 Jun 1998 14:33:18 GMT, you wrote:
>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
>
don't do this. _allow_resetlogs_corruption is a *last ditch*, to be used only when told to by support, parameter.
_disable_logging just shouldn't be used -- at all. If the instance fails (machine is powered down, instance crash, anything like that) your database is gone. You might be able to get it up again with _allow_resetlogs_corruption (but maybe not) and EVEN IF YOU DO you must only use that instance to export important data and import that into a clean instance.
Once you use _allow_resetlogs_corruption, the database files are not necessarily consistent with eachother. Internal errors will almost surely happen either today or some time in the future.
>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.
>
Your lucky it was only once. This is truely *terrible* advice for someone running a production instance.
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Jun 13 1998 - 12:55:48 CDT