Re: Shutting down log archiving

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 27 Nov 1999 19:34:53 +0200
Message-ID: <3840163D.DCB930FA@0800-einwahl.de>

This will set the database to NOARCHIVELOG mode which I guess is not desired.

Just archive your redologs - they may be filled up in the meantime. What ARCH up to now did automatically for you you have to do now manually.

Martin

Kathinka Diehl wrote:
>
> Uwe Schneider <uwe.schneider_at_xlink.net> schrieb:
> >
> > I just wanted to stop the automatic archiving of redo logs on one
> > instance.
>
> SHUTDOWN IMMEDIATE
> STARTUP MOUNT
> ALTER DATABASE NOARCHIVELOG;
> ALTER DATABASE OPEN;
> ALTER SYSTEM ARCHIVE LOG STOP;
>
> That's it.
>
> HTH, Kathinka
Received on Sat Nov 27 1999 - 11:34:53 CST