How to disable the archive on re-do logs?

[Former Member]

Gurus:

Please help with this. Thanks!

[Former Member · Accepted solution]

Hi Christy,

You can do it from SQLPlus:

startup mount;

alter database noarchivelog;

alter database open;

Or you can do it with the BRTOOLS (follow this link):

http://howtosap.blogspot.com/2009/08/brtools-to-turn-off-archive-log-1.html

Regards,

Federico Biavati

Edited by: Federico Biavati on Nov 16, 2009 11:53 AM

Ops, sorry! wrong DB!!

[lbreddemann · Accepted solution]

> Edited by: Federico Biavati on Nov 16, 2009 11:53 AM

> Ops, sorry! wrong DB!!

😄

Ok, where might somebody find such highly confidential information?

Yes!

The documentation: [Changing Log Settings|http://maxdb.sap.com/doc/7_7/0b/e1ab506fd040f7b62d31a62b70b0c9/content.htm]

Just use the DB Studio tool for it.

regards,

Lars