Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Archiving database logs

Re: Archiving database logs

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Jun 2003 06:38:17 -0700
Message-ID: <2687bb95.0306110538.1f754804@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

Peter, the first command changes the database from noarchivelog mode to archivelog mode. You generally do this only once when you convert your database to archive log mode, then you use the second command to start automatic archiving of the used redo logs. You would then set log_archive_start in the init.ora to start automatic archiving when the instance is started so you do not have to reissue the command every time you start Oracle.

HTH -- Mark D Powell -- Received on Wed Jun 11 2003 - 08:38:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US