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: