In this article we are going to see Oracle Archiver (ARCn) Background Process.
- Archiver processes (ARCn) are background processes that exist only when the database is in archivelog mode and automatic archiving is enabled.
- In which case ARCn automatically archives online redologfiles. Log writer process (LGWR) cannot reuse and overwrite an online redolog group until it has been archived.
- The database starts multiple archiver processes as needed to ensure that the archiving of filled online redologs does not fall behind.Possible processes include ARC0-ARC9 and ARCa-ARCt (31 possible destinations).
- you can have up to ten archiver processes running for a single instance in Oracle.
- The LOG_ARCHIVE_MAX_PROCESSES parameter specifies the number of ARCn processes that database initially invokes.If you anticipate a heavy workload for archiving.Such as during bulk loading of data you can increase the maximum number of archiver processes.There can also be multiple archivelog destinations.It is recommended that there be at least one archiver process for each destination.
- The archiver process copies redo log files to a designated storage device after a log switch has occurred. ARCn processes are present only when the database is in ARCHIVELOG mode, and automatic archiving is enabled ARCn Responsible for copying online redo log to archival storage before being reused. Runs only when database is in Archivelog Mode.When a Redo Log File fills up, Oracle switches to the next Redo Log File.
Connect with me:-
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr