Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shutting down log archiving

Re: Shutting down log archiving

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: Thu, 18 Nov 1999 10:21:42 +0100
Message-ID: <810gon$1arp9$1@fu-berlin.de>

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 Thu Nov 18 1999 - 03:21:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US