Re: Archiving database logs

Peter wrote:
> What is the diffence between
> alter database archivelog;
> and alter system archive log start?
>
> I am not sure when to use which.
> Thanks
>

HI,

ALTER DATABASE ARCHIVELOG - this statement you execute in database MOUNT mode switching between database NOARCHIVELOG and ARCHIVELOG mode.

alter system archive log start [to] - you puts when ARCH process fail or in initSID.ora, paramter LOG_ARCHIVE_START has FALSE.

Generally ALTER DATABASE ARCHIVELOG change database configuration LOG mode.

ALTER SYSTEM ARCHIVE LOG START/STOP[TO] controls the ARCH process. Also by using this command you can change the original archivelogs DESTINATION.

eg: ALTER SYSTEM ARCHIVE LOG START to '/arch2/SID'; then ARCH process after:
ALTER SYSTEM ARCHIVE LOG STOP or fail when filesystem is 100% used is starting generating ARCH files to new location.

-- 

   www.konsultancIT.pl
Oracle&MS-SQL consulting