Re: Archiving database logs

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 11 Jun 2003 09:38:20 -0700
Message-ID: <1ac7c7b3.0306110838.1db788b8@posting.google.com>

Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<1qbkbvs9j86h2lkqh4ph1tfgvof0lat8an_at_4ax.com>...
> What is the diffence between
> alter database archivelog;
> and alter system archive log start?
>
> I am not sure when to use which.
> Thanks

both.

drake_at_DEV817> select log_mode from v$database;

LOG_MODE

ARCHIVELOG C:\>set oracle_sid=dev817

C:\>sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 11 12:25:58 2003

not connected> connect / as sysdba
Connected.
sys_at_dev817> archive log list

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            J:\Oracle\oradata\DEV817\archive
Oldest online log sequence     5915
Next log sequence to archive   5922
Current log sequence           5922

the statement:

SQL> alter database archivelog;

tells oracle to not overwrite an online redo log until it has been archived.

the statement:

SQL> archive log start;

tells oracle to start the archiver process. You will want to set this parameter in your init.ora file and/or spfile. You did not provide the oracle version - so this may or may not apply.

SQL> alter system set log_archive_start=true scope=both;

(I'm not sure if that works, not logged into a 9.2 db at the moment).

hth.

Paul Received on Wed Jun 11 2003 - 11:38:20 CDT