Oracle Database - How to know the archivelog mode ?

> Database > Oracle Database

Table of Contents

1 - About

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

gerardnico@orcl> SELECT log_mode FROM v$database;

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.

db/oracle/archivelog_display_mode.txt · Last modified: 2017/09/06 19:27 by gerardnico