Oracle Database - How to know the archivelog mode ?
About
To know if the database is in Archivelog or Noarchivelog mode, you have to perform the statement below :
gerardnico@orcl> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
The default mode in the creation of a database is Noarchivelog to prevent the generation of Oracle Database - Redo Log (Transaction Log Files) during the installation.