Field help (APROPLOGM)

Indicates if the ARCHIVELOG mode is activated or de-activated.

• NOARCHIVELOG :
  In mode, NOARCHIVELOG, the redo log online files are re-written each time a redo log online file is completed and where a log switch is launched. LGWR does not re-write a group of redo log files whilst the checkpoint for this group is not completed.

• ARCHIVELOG :
  If the database is configured in the mode ARCHIVELOG mode, the the completed redo groups must be archived. As all modifications carried out on the database are recorded in the redo log online files, the DBA can use the backup present on the hard disk and the archived redo log files to restore the database without losing any committed data.
  
  It is possible to archive the redo log files :
  - Manually.
  - Automatically : Recommended method.
  
  The initialisation parameter LOG_ARCHIVE_START, when it is TRUE indicates that the archiving is carried out automatically. When set to FALSE, indicates that the DBA is carried out manually. In automatic mode, the archiving is carried out thanks to the ARCn process and manually with SQL requests.