Re: ARCHIVELOG mode not enabling

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 12 Aug 1999 21:49:54 +0200
Message-ID: <934487408.13760.0.pluto.d4ee154e@news.demon.nl>

You forgot to change log_archive_start to true in init<sid>.ora. Your = database is now in archive mode, however redo logs going to be = overwritten need to be archived manually. For the time being you could = issue the command
archive log start '<destination dir>'
get back to the manual, change log_archive_start, log_archive_dest and = maybe log_archive_format in init<sid>.ora and that will become operational at the next reboot.

Hth,

Sybrand Bakker, Oracle DBA

  Sam Petitto <sam.petitto_at_netsec.net> wrote in message = news:37B31DD3.8144CE7D_at_netsec.net...
  Running 8i on NT. Do I have an obvious mistake ? I went verbatim = straight from the book:

  SVRMGR> connect internal 
  SVRMGR> shutdown 
  SVRMGR> startup mount 
  SVRMGR> alter database archivelog 
  SVRMGR> alter database open 

  every thing responded properly until I ran the command "archive log = list"
  Do I need to bounce the database for the change to take effect ? No = mention of that in manual.

  SVRMGR> archivelog list;

  Database log mode                                 Archive Mode 
  Automatic Archival                                 Disabled         /* =
This is the problem - should be Enabled */ 
  Archive destination                                 =
D:\Oracle\Ora8i\RDBMS 
  Oldest online log sequence                      2 
  Next log sequence to archive                  5 
  Current log sequence                              5 

  TIA for any comments/suggestions ...          

  --
  =

---

  Sam Petitto
  Database Engineer
  Network Security Technologies, Inc.
  http://www.netsec.net
(877)799.9380 Toll Free
(703)561.0420 Local
(703)561.0426 Fax

  =

---

  This electronic message contains information from Network Security = Technologies, Inc or its
  affiliates, which may be confidential, proprietary or otherwise = protected from disclosure. The
  information is intended to be used solely by the recipient(s) named = above for the purposes
  intended by the originator. If you are not an intended recipient, be = aware that any review,
  disclosure, copying, distribution or use of this transmission or its = contents is prohibited. If
  you have received this transmission in error, please notify us = immediately by telephone at (703)
  561-0420, or by electronic mail at sales_at_netsec.net      Received on Thu Aug 12 1999 - 14:49:54 CDT