Re: Archive Logging

From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1996/11/21
Message-ID: <32948E35.196E_at_dt.com.hk>#1/1

Arlie E. Hammons wrote:
>
> Is it possible to dynamically turn off and on archive logging?

If you mean to stop/start writing online redo log to OS files, it is yes.

   You can use sqlplus commands:

         ALTER SYSTEM  ARCHIVE LOG START;
         ALTER SYSTEM ARCHIVE LOG STOP;

   If you stop archiving, and when on-line redo log is full, the database
is suspended.

If you mean to establish archivelog/noarchivelog mode, it is no. You must mount the database and closed, then issue command:

    ALTER DATABASE ARCHIVELOG;
    ALTER DATABASE NOARCHIVELOG;
Before and after you issue above two commands, it is recommended to make a
cool full database backup.

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049

Received on Thu Nov 21 1996 - 00:00:00 CET