Oracle Database - How to know the archivelog mode ?

About

To know if the database is in Oracle Database - ARCHIVELOG or Oracle Database - NOARCHIVELOG mode, you have to perform the statement below :

[email protected]> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

The default mode in the creation of a database is Oracle Database - NOARCHIVELOG to prevent the generation of Oracle Database - Redo Log (Transaction Log Files) during the installation.


Powered by ComboStrap