How to start ARCHIVELOG ?

From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/07/28
Message-ID: <DCF69t.1v4_at_mecati.mecasoft.ch>#1/1


Hi!

I have a database created with NOARCHIVELOG option. Now, I would like to start ARCHIVELOG. What I have to do exactly? Here is what I've tryied:

Parameters in initxxx.ora:

    log_archive_start       = true
    log_archive_dest        = /users/oracle7/dbs/test7/arch/arch.log
    log_archive_format      = 'log%s_%t.arc'
    log_archive_buffer_size = 32
    log_archive_buffers     = 4


As sqldba:

    sqldba> alter database close;
    sqldba> alter database dismount;
    sqldba> alter database mount exclusive;

    sqldba> alter database archivelog;

    sqldba> shutdown
    sqldba> startup open test7

    sqldba> show parameters arch

    NAME                       TYPE    VALUE
    -------------------------- ------- ------------------------------
    log_archive_buffer_size    integer 32
    log_archive_buffers        integer 4
    log_archive_dest           string  /users/oracle7/dbs/test7/arch/arch.log
    log_archive_format         string  'log%s_%t.arc'
    log_archive_start          boolean TRUE


The /users/oracle7/dbs/test7/arch directory is still void... why ?? Stefano


______________________|    Stefano Unternaehrer    |__________________________
\  Mecasoft SA        |         Oracle DBA         | fax:    +41 93 335 507  /
 \ 6600 Muralto       |     and  PL/SQL, Pro*C     | voice:  +41 93 337 444 /
  \                   |     C, XWindow & Motif     |                       /
  /                   |     Software Developer     | email:                \
 / Switzerland Europe |____________________________|  dba,unter_at_mecasoft.ch \
/________________________)                      (____________________________\
Received on Fri Jul 28 1995 - 00:00:00 CEST

Original text of this message