There are 2 types of logging mode in oracle database.


1. Archivelog mode

In this mode, after the online redo logs are filled , it will move to archive location

2. Noarchivelog mode

In this mode, filled online redo logs wont be archives, instead they will be overwritten.


Enable archive log mode:



Disable archivelog mode: