Re: Archiving database logs

From: <sybrandb_at_yahoo.com>
Date: 11 Jun 2003 07:50:23 -0700
Message-ID: <a1d154f4.0306110650.51542e69@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

alter database archivelog puts the database in archivelog mode. This is NOT possible in an OPEN database.
Alter system archivelog start enables automatic archival. This statement is useless if the database is in noarchivelog mode as opposed to noarchivelog mode.

Sybrand Bakker
Senior Oracle DBA Received on Wed Jun 11 2003 - 09:50:23 CDT