Oracle Database - How to know the archivelog mode ?

Card Puncher Data Processing


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.

Discover More
Card Puncher Data Processing
Oracle Database - How to change the Database Archiving Mode

To change the default mode from to
Card Puncher Data Processing
Oracle Database - Mode Archive Log / Archiving

Oracle Database lets you save filled groups of files to one or more offline destinations, known collectively as the archived , or more simply thearchive log. The process of turning redo log files into...

Share this page:
Follow us:
Task Runner