Archivelog mode

ARCHIVELOG mode

The mode of the database in which log transport services archives filled online redo logs to disk. Specify the mode at database creation or by using the SQL ALTER DATABASE ARCHIVELOG statement. You can enable automatic archiving either dynamically using the SQL ALTER SYSTEM ARCHIVE LOG START statement or by setting the initialization parameter LOG_ARCHIVE_START to true.

Running your database in ARCHIVELOG mode has several advantages over NOARCHIVELOG mode. You can:

• Back up your database while it is open and being accessed by users
• Recover your database to any desired point in time

To protect your database that is in ARCHIVELOG mode in case of failure, back up your archived logs.

See also archived redo log, NOARCHIVELOG mode, and redo log

 

 

archiver process (ARCn)

 On the primary database site, the process (or a SQL session performing an archival operation) that creates a copy of the online redo logs, either locally or remotely, for standby databases. On the standby database site, the ARCn process archives the standby redo logs to be applied by the managed recovery process (MRP). 

ARCH

Setting this attribute on the LOG_ARCHIVE_DEST_n initialization parameter indicates that the archiver process (ARCn) will create archived redo logs on the primary database and also transmit redo logs for archival at specified destinations. 

To see process

select *

from

   v$session

where

   type ='BACKGROUND';