Re: Difference between alter system and alter database?

Peter wrote:
> What is the difference between alter system and alter database?
> When do you use one over the other?
>
> 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